|
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) |
