reliability?

IBM Informix Dynamic Server Version 10.00.UC5 on redhat Try this: SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 An the answer is ..... 1 A know that stupid questions generates stupid answers but still.... Anyone has come to that?

Same on HPUX 11.11, IDS10.00.FC6 > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of piotrek > Sent: Wednesday, May 07, 2008 10:39 AM > To: informix-list@iiug.org > Subject: reliability? > > > IBM Informix Dynamic Server Version 10.00.UC5 on redhat > > Try this: > SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 > An the answer is ..... 1 > > A know that stupid questions generates stupid answers but still.... > > Anyone has come to that? > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

piotrek wrote: > IBM Informix Dynamic Server Version 10.00.UC5 on redhat > > Try this: > SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 > An the answer is ..... 1 > A know that stupid questions generates stupid answers but still.... > > Anyone has come to that? > > > Works fine on 10.00.UC1 on SuSE.

I just tried this on recent builds of the next-to-be-released 10.00, 11.10, and 11.50 versions (currently these are numbered 10.00.xC9, 11.10.xC2W3, 11.50.xC2; of course these numbers might change and my posting this is no guarantee from IBM that these will necessarily be released...), and it worked correctly on all of them. All of these were on 64-bit x86 Linux. The same query also worked against a regular table on all of them. (sysmaster tables are not normal tables -- they are what we call pseudotables. The code to access them produces them out of thin air, or rather out of the contents of memory on the fly, so it's possible for some things to be broken for particular sysmaster tables that work correctly for other sysmaster tables and normal tables.) This has the flavor of a bug that has already been found and fixed in later fixpacks. I will ask the optimizer team if they know of any such fix having been done. -- Kevin Cherkauer Software Engineer IBM Informix Dynamic Server -- Database Kernel "piotrek" <piotrUSUN_T_O110@o2.pl> wrote in message news:fvsfda$4q7$1@pippin.nask.net.pl... > IBM Informix Dynamic Server Version 10.00.UC5 on redhat > > Try this: > SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 > An the answer is ..... 1 > A know that stupid questions generates stupid answers but still.... > > Anyone has come to that?

Bingjie Miao on the optimizer team tells me this bug was indeed fixed already. He already sent a reply posting via a moderated feed, so it should arrive here eventually. :-) -- Kevin Cherkauer Software Engineer IBM Informix Dynamic Server -- Database Kernel "Kevin Cherkauer" <invalid_address@nowhere.com> wrote in message news:fvt3g8$c9o$1@aioe.org... >I just tried this on recent builds of the next-to-be-released 10.00, 11.10, >and 11.50 versions (currently these are numbered 10.00.xC9, 11.10.xC2W3, >11.50.xC2; of course these numbers might change and my posting this is no >guarantee from IBM that these will necessarily be released...), and it >worked correctly on all of them. All of these were on 64-bit x86 Linux. The >same query also worked against a regular table on all of them. (sysmaster >tables are not normal tables -- they are what we call pseudotables. The >code to access them produces them out of thin air, or rather out of the >contents of memory on the fly, so it's possible for some things to be >broken for particular sysmaster tables that work correctly for other >sysmaster tables and normal tables.) > > This has the flavor of a bug that has already been found and fixed in > later fixpacks. I will ask the optimizer team if they know of any such fix > having been done. > > -- > Kevin Cherkauer > Software Engineer > IBM Informix Dynamic Server -- Database Kernel > > > "piotrek" <piotrUSUN_T_O110@o2.pl> wrote in message > news:fvsfda$4q7$1@pippin.nask.net.pl... >> IBM Informix Dynamic Server Version 10.00.UC5 on redhat >> >> Try this: >> SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 >> An the answer is ..... 1 >> A know that stupid questions generates stupid answers but still.... >> >> Anyone has come to that? > >