RE: 9.40uc3 NVL problem
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