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
> >
> > 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
>
sending to informix-list