> Curious, I ran this one using set explain:
Same kind of thing going on in 11.10, except the optimizer drops the right
condition (colno >= 1)
SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1
Estimated Cost: 101
Estimated # of Rows Returned: 1
1) informix.syscolumns: INDEX PATH
(1) Index Keys: tabid colno (Key-Only)
Index Key Filters: (informix.syscolumns.colno > 1 )
10.00 bug obviously, wonder if it is fixed in versions >= UC6 AND versions
>
UC6.
Andrew
