|
Problem IT04364
|
Status: Closed |
DB2 MIGHT ABEND WHEN EXECUTING QUERY CONTAINING A SUBSELECT WITH REDUNDANT PREDICATES |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Under rare scenarios, DB2 might abend if the following
conditions are true:
1) The query contains one or more subqueries. The subquery can
be of the form EXISTS, NOT EXISTS, etc.
2) The subquery contains one or more correlated predicates
3) Atleast one of the correlated predicate in the subquery can
be proven to be redundant due to a check constraint, tautology
predicates, etc.
4) The subquery and the correlated column reference the same
view or common table expression. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Unknown *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 101 fix pack 5 *
**************************************************************** |
| Local Fix: |
Remove the redundant predicate |
| Solution |
Fixed in DB2 version 101 fix pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.09.2014
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
