|
Problem IT38155
|
Status: Closed |
TRAP POSSIBLE WHEN COLUMNAR QUERY RUNNING WITH THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
TRAP POSSIBLE WHEN A RUNNING A COLUMNAR QUERY WITH
THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE CONTAINS MORE THEN 10
values.
Stack will have createForNotInList.
Example:
sqloEDUCodeTrapHandler
SyntaxTree::print
SynopsisInListPredicateDeriver::createForNotInList
Parser::makeDerivedPred
Parser::makeDerivedWhere
Parser::addSynopsisQuery
Parser::prepareSingleTableQuery |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or higher *
**************************************************************** |
| Local Fix: |
Do not run this type of query with db2trc on. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or higher *
**************************************************************** |
| Comment |
Upgrade to 11.5.7 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.08.2021
01.12.2021
01.12.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
