Re: reliability?

Posted in 2008

Andrew Ford — Wed, 7 May 2008 10:23:27 -0500 — source: Usenet: comp.databases.informix

> 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