Informix - Problembeschreibung
Problem IT09482 | Status: Geschlossen |
IWA: OFFLOADING OF A QUERY WITH IN CLAUSE CAN FAIL WITH ERROR CODES -904, 57011 | |
Produkt: | |
INFORMIX WHSE A / 5725D1400 / C10 - IDS 12.10 | |
Problembeschreibung: | |
When you are running a query which is offloaded to the Informix Warehouse Accelerator the query execution can be canceled with an error: 26561: cannot map to Informix sqlcode: DRDA OPEN IWA error:-904,'57011', Query compilation failed... In the message log of the operating system the Informix Warehouse Accelerator is running on you will find an exception: AssertionFailedException: An assertion 'mCodesAndValues != __null' failed. Additional info: Pointer to CodesValues is NULL followed by CompilerException: Query compilation failed with error condition 'An assertion 'mCodesAndValues != __null' failed. Additional info: Pointer to CodesValues is NULL When the IN clause is rewritten with OR the exception will not occur. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * IWA acceleration with IN clause inside CASE ... WHEN * * construct within WHERE clause of SELECT query. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 or newer version. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.06.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |