by "piotrek" <piotrUSUN_T_O110@[EMAIL PROTECTED]
>
May 7, 2008 at 05:17 PM
> The AND is being dropped. It would seem that the optimizer looks for
> simplifications that can be applied and in this case is dropping the
more
> > restritive filter. Of course I could be giving the optimizer too much
> credit.
exectly - just changing the order of filter is enought to change ther
result
SELECT MIN(colno) FROM syscolumns WHERE colno>1 AND colno>=1
gives 2
