|
Problem IC96253
|
Status: Closed |
DB2 MAY ABEND WHILE COMPILING QUERY HAVING NESTED OR PREDICATE WITH (NOT) EXISTS SUBTERM |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
DB2 may abend when the SQL statement satisfies all the following
conditions:
1. Query has an equality predicate between simple column and a
constant value, i.e. Q1.col1 = <literal>.
2. The same query block also has an OR predicate, e.g. "P1 OR P2
OR .. OR Pn", Pi stands for an OR subterm predicate.
3. An OR subterm predicate Pi contains "Pa1 AND Pa2.. AND Pak".
One Pa is a provable FALSE predicate and another Pa is an
EXISTS, NOT EXISTS, IN, or NOT IN predicate. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on DB2 V10.1 Fix Pack 2 or below *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 Version 10.1 Fix Pack 3 or later *
**************************************************************** |
| Local Fix: |
Reduce query optimization level to 0,1, 2, or 3 by using
command, e.g, "db2 set current query optimization <optlevel>" |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem is first fixed in DB2 Version 10.1 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.09.2013
14.04.2014
14.04.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
