On 07/05/2008, Keith Simmons <smiley73@[EMAIL PROTECTED]
> wrote:
> On 07/05/2008, Andrew Ford <aford@[EMAIL PROTECTED]
> 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@[EMAIL PROTECTED]
> > 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
