|
Problem IC96253
|
Status: Geschlossen |
DB2 MAY ABEND WHILE COMPILING QUERY HAVING NESTED OR PREDICATE WITH (NOT) EXISTS SUBTERM |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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>" |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem is first fixed in DB2 Version 10.1 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.09.2013
14.04.2014
14.04.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
