DB2 - Problembeschreibung
Problem IC99601 | Status: Geschlossen |
DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT IN QUERY WITH CORRELATED SUBSELECT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
DB2 might produce SQL0901N when the following conditions are true: 1. There is a NOT IN subquery 2. The NOT IN subquery contains one or more scalar subqueries which have correlation 3. The parent of the NOT IN subquery, i.e. the column on which NOT IN predicate is applied is nullable 4. There is another table in the query which is joined to the parent table eg. create table X(col1 int, col2 int); <--------- condition 3 SELECT col1 FROM X, <-------------- parent table Y <-------------- condition 4 WHERE X.col1 = Y.col1 AND X.col1 NOT IN ( <----------------- condition 1 SELECT col1 FROM A, D WHERE A.col2 = D.col2 AND A.col3 = D.col3 AND D.col4 = ( SELECT <----------------- condition 2 MAX(col4) FROM E WHERE E.col2 = D.col2 ) ); The stack trace might be as follows: 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloDumpDiagInfoHandler 5 __invoke_dynamic_linker__ 6 pthread_kill 7 sqloDumpEDU 8 sqldDumpContext 9 sqlrr_dump_ffdc 10 sqlzeDumpFFDC 11 sqlzeSqlCode 12 sqlnn_erds 13 sqlng_build_INDX_key ---->>> SQL0901N 14 sqlng_build_KEY_obj 15 sqlng_build_INDX_obj | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 version 10.1 Fix pack 4 * **************************************************************** | |
Local-Fix: | |
db2set DB2_ANTIJOIN=YES | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 version 10.1 Fix pack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC99808 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.02.2014 21.07.2014 21.07.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |