[Fwd: Re: 9.40uc3 NVL problem - bug B167699]
I sent the message below to Alexey, and he responded that he'd posted
it to c.d.i and there were other postings there too - but I can't see
it so I'm resending - apologies for duplication if it is duplicated.
Note that since this, Alison has reported that the proble appears in
9.40.FC3 on AIX 5.2, but appears to be fixed in 9.40.FC4W2 on AIX 5.2.
==message to Alexey==
Bug - to be precise, B167699. Please log a case against it.
It reproduces in 9.30 as well as 9.40; it does not reproduce in 7.31
(or, you say, 9.21).
(Alexey - If you get a chance, please post this to c.d.i. - thanks.)
--
Jonathan Leffler (jleffler@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"
>> ----- Message from "Bent_Andy" <abent@aetinc.com> on Tue, 11 May
>> 2004 15:40:44 -0500 -----
>>
>> Subject:
>>
>> RE: 9.40uc3 NVL problem
>>
>>
>> reproducible on 9.40.FC2W4 hpux 11.0
>>
>> Andy
>>
>
>>> > -----Original Message-----
>>> > From: owner-informix-list@iiug.org
>>> > [mailto:owner-informix-list@iiug.org] On Behalf Of Alexey Sonkin
>>> > Sent: Tuesday, May 11, 2004 3:20 PM
>>> > To: Alexey Sonkin; 'informix-list@iiug.org'
>>> > Subject: AW: 9.40uc3 NVL problem
>>> >
>>> > P.S.
>>> >
>>> > Forgot to mention the workaround:
>>> >
>>> > select NVL(
>>> > (select min(t1.id) from my_test t1 where num>4 )::INT,
>>> > (select max(t2.id) from my_test t2)::INT
>>> > )
>>> > from 'informix'.systables;
>>> >
>>> > Actually, we don't like that solution - we need to re-write a
>>> > lot of code...
>>> >
>>> > ------------------------------------------
>>> > Alexey Sonkin
>>>> > > -----Original Message-----
>>>> > > From: Alexey Sonkin
>>>> > >
>>>> > > I've just encountered an interesting problem with 9.40uc3
>>>> > > (Linux) This
>>>> > > is a small regression code to reproduce the problem:
>>>> > >
>>>> > > ----------------------------
>>>> > > create table my_test ( id serial, num integer); >>>> > >
>>>> > > insert into my_test values(1,1);
>>>> > > insert into my_test values(2,2); >>>> > >
>>>> > > select NVL(
>>>> > > (select min(t1.id) from my_test t1 where num>4 ), (select
>>>> > > max(t2.id)
>>>> > > from my_test t2)
>>>> > > )
>>>> > > from 'informix'.systables; -- <<<< this works fine
>>>> > >
>>>> > > insert into my_test values(3000000,3); >>>> > >
>>>> > > select NVL(
>>>> > > (select min(t1.id) from my_test t1 where num>4 ), (select
>>>> > > max(t2.id)
>>>> > > from my_test t2)
>>>> > > )
>>>> > > from 'informix'.systables; -- <<<< this gives an ERROR -1207
>>>> > >
>>>> > > ----------------------
>>>> > >
>>>> > > -1207 Converted value does not fit into the allotted space.
>>>> > >
>>>> > > Bug or feature?
>>>> > > It doesn't reproduce on 9.21uc4
>>>> > >
>>>> > > ------------------------------------------
>>>> > > Alexey Sonkin
--
Jonathan Leffler (jleffler@earthlink.net, jleffler@us.ibm.com)
#include <disclaimer.h>
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/