DB2 - Problem description
Problem IT33870 | Status: Closed |
SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Db2 may generate 901 when the following conditions are met - There is one or more Outer Joins in the query - There is one or more IN/EXISTS subquery predicate that references Row Preserving side of Outer Join - There is one or more references to SYSIBM.DUAL on the Null Producing side of Outer Join AssertionFailedException: An assertion 'mInputTypeInfo[i].type.isNullable() || attrVec->getNullIndicatorsGeneral()->isAllZeros()' failed. Additional info: type and content in attribute mismatch31T8 Thrown at TableQueueEvaluator.cpp : 281 ... [4] 0x0000100009425ECC _ZN7ibm_cde5query24TableQueueWriteEvaluator35sanityCheckAttribut eTypeNullabilityERKNS0_8WorkUnitE + 0x1BC [5] 0x0000100009451C20 _ZN7ibm_cde5query31TableQueueWriteHashDirEvaluator26processInput sSynchronouslyEv + 0x100 [6] 0x00001000075495DC _ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt ateEPNS0_19OptPredicateTrackerE + 0x8DC | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.08.2020 20.11.2020 20.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |