INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The stored procedure

create procedure test(p_skip smallint)
select * into p_retval from ( select skip p_skip first 1 * from
table(set{0,1,2}) order by 1);
return p_retval;


can return wrong values, if used a number of times with
different p_skip values, if no update statistics is run
inbetween.

When running update statistics before calling the stored
procedure everything is fine.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* SELECT within a stored procedure may return wrong result     *
* when skip and parameter is used.                             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

07.03.2019
26.09.2019
26.09.2019

12.10.xC13