Informix - Problembeschreibung
Problem IC61686 | Status: Geschlossen |
ENGINE CRASH WITH A SELECT IF TABLE NAME IS A DOTTED COLLECTION TYPE (LIST, SET, MULTISET) | |
Produkt: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problembeschreibung: | |
If a table name is one of the following ... set, list or multiset (collection types)... then a select statement which uses the table name dot column name will crash the engine. You may need to drop the table and re-create it to see the crash. The first time through, you will see an error. examples ... create table list (name char(5)); select list.name from list; drop table list; create table list (name char(5)); select list.name from list; The stack is rcaseshift spparse parsecmd sqcmd sq_cmnd sq_prepare sqmain listen_verify spawn_thread startup + 0xa8 The system does not crash if the sql is changed to "select name from list". | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 11.50XC4 * **************************************************************** * PROBLEM DESCRIPTION: * * Engine Crashes when Collection type keywords are used as a * * table name in a select through a dotted column. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC5 and above. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem first fixed in IDS 11.50 XC5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.06.2009 21.01.2010 21.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
11.50.0, 11.50.xC5 | |
Problem behoben lt. FixList in der Version | |
11.50.xC5 |