Informix - Problembeschreibung
Problem IT19360 | Status: Geschlossen |
QUERY LOOPS IN OPLOOKSUBQ, WILL RESULST IN STACK OVERFLOW OR HANG | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
The following query will cause a stack overflow, and an hang of the instance, if SHMTOTAL is not set: create database stack_issue; create table t1 (a int, ord int); create table t2 (ord int); insert into t1 values (1, 1); insert into t2 values (1); select t1.ord, sum (a) from t1, t2 where t1.ord = t2.ord order by 1, (case when ord >10 then ord-12 else ord end) Note that t1 and t2 have a column with the same name. As soon as the name of the column is changed, the statement will work. The query is causing a loop in oplooksubq, if a stack a gathered with onmode -I 722 it will show lots of calls to this function. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Informix user query with order by/group by on same column * * name from different tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local-Fix: | |
Note that t1 and t2 have a column with the same name. As soon as the name of the column is changed, the statement will work. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.02.2017 10.07.2017 10.07.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC9 | |
Problem behoben lt. FixList in der Version |