| Subject | Re: [firebird-support] changed WHERE behavior from fb 1.5 to 2.5 |
|---|---|
| Author | martijn@pecsforall.com |
| Post date | 2011-01-20T08:15:49Z |
> select * from my_tableWhat happens if you use ()?
> where status=0
> and cast(code as integer)=1
select * from my_table
where (status=0)
and (cast(code as integer)=1)
Which indexes are used?
Martijn