Informix - Problembeschreibung
Problem IT27559 | Status: Geschlossen |
STORED PROCEDURE USING MULTISET DATA TYPE IS CONTINUALLY REOPTIMIZED WHEN EXECUTED MULTIPLE TIMES | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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; | |
Problem-Zusammenfassung: | |
**************************************************************** * 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: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.12.2018 04.10.2019 04.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC12 | |
Problem behoben lt. FixList in der Version |