SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-07-2008, 06:21 PM
| ||||
| ||||
 Re: reliability? On 07/05/2008, Keith Simmons <smiley73@googlemail.com> wrote: > On 07/05/2008, Andrew Ford <aford@networkip.net> wrote: > > > Same on HPUX 11.11, IDS10.00.FC6 > > > > > > > Not the same result on IDS 11.10.UC1, Red Hat Enterprise Linux ES release 4. > > > > > echo "SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1" | > > > dbaccess sysmaster > > > > Database selected. > > > > > > > > (min) > > > > 2 > > > > 1 row(s) retrieved. > > > > > > > > Database closed. > > > > > > Andrew > > > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > Would appear to be an IDS10 issue:- > IDS 9.4 FC6 on AIX returns 2 > IDS 10.0 FC5 on AIX returns 1 > IDS 10.0 FC5 on Solaris returns 1 > IDS 9.3 TC2 on Windoze returns 2 > > Keith > Got the same explain as Mark from IDS10 but 'expected' from IDS9. Reversing the selections in IDS 10 SELECT MIN(colno) FROM syscolumns WHERE colno>1 AND colno>=1 still produces a limited explain:- Estimated Cost: 262 Estimated # of Rows Returned: 1 1) informix.syscolumns: INDEX PATH (1) Index Keys: tabid colno (Key-Only) Index Key Filters: (informix.syscolumns.colno > 1 ) but uses the firstcriteria and produces the 'correct' answer. Buggy Bug Bug Keith      |
Linear Mode
