INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A stored procedure using the mutliset data type may be
reoptimized when it is executed by a session two or more times.
This results in updates to the sysprocplan system catalogue
table which may lead to performance issues relating to the
volume of logical log records or other threads having to wait on
concurrent update activity.

An example of a stored procedure using the multiset data type:

create procedure proc1(p_col1 int8)
define v_col1 multiset(int8 not null);
define l_count integer;

let v_col1 = multiset(
   select item col1::int8
   from tab1
   where col1 = p_col1);

select count(*) into l_count
from tab1
where col1 in (select * from table(v_col1));
end procedure;

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC12.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Stored procedure using multiset data type is continually     *
* reoptimized when executed multiple times.                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

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

26.12.2018
04.10.2019
04.10.2019

12.10.xC12