one more short question:
How to obtain fix?
Sure - I can find it on fixcentral but as far as I know our client has no
more active support...


"Bingjie Miao" <nobody@nowhere.com> wrote in message
news:fvteot$p16$1@aioe.org...
> This problem exists on the following versions:
>
> 9.40: 9.40.xC8W2 through 9.40.xC8W7, 9.40.xC9, should be fixed by
> 9.40.xC9W1 and above.
> 10.00: 10.00.xC5, 10.00.xC6, should be fixed by 10.00.xC6W1 and above
> including 10.00.xC7 and 10.00.xC8.
>
> It does not exist in 11.10 and above.
>
> Bingjie Miao
>
>
> "Kevin Cherkauer" <invalid_address@nowhere.com> wrote in message
> news:fvt7jp$adn$1@aioe.org...
>> 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?
>>>
>>>
>>
>>