Re: 9.40uc3 NVL problem
This is a known issue, fix will be in 9.40.xC5
"Alinda Watson" <alinda.watson@vcontractor.co.za> wrote in message news:<c7t0p2$ft2$1@terabinaries.xmission.com>...
> Same problem on 9.40.FC3, but no problem on 9.40.FC4W2 (both AIX 5.2)
>
>
> Alinda Watson
> -----Original Message-----
> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
> On Behalf Of Marino Decaro
> Sent: 12 May 2004 09:07
> To: informix-list@iiug.org
> Subject: Re: 9.40uc3 NVL problem
>
>
> I have the same problem with IDS 9.40.FC3 on Tru64 UNIX V5.1B
>
> --
> Ciao,
> Marino Decaro
>
> "Alexey Sonkin" <alexeis@grandvirtual.com> ha scritto nel messaggio
> news:c7rc2a$pb3$1@terabinaries.xmission.com...
> >
> > Hi, everybody,
> >
> > 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
> >
> >
> >
> > sending to informix-list
>
>
> ?This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp "
>
> sending to informix-list