| Subject | Re: [firebird-support] changed WHERE behavior from fb 1.5 to 2.5 |
|---|---|
| Author | Anderson Farias |
| Post date | 2011-01-20T11:46:28Z |
Hi Martijn,
|What happens if you use ()?
|
|select * from my_table
|where (status=0)
|and (cast(code as integer)=1)
Same exact behaviors
|Which indexes are used?
None. NATURAL scan in all cases
Regards,
Anderson
|What happens if you use ()?
|
|select * from my_table
|where (status=0)
|and (cast(code as integer)=1)
Same exact behaviors
|Which indexes are used?
None. NATURAL scan in all cases
Regards,
Anderson