DB2 - Problembeschreibung
Problem IC88758 | Status: Geschlossen |
REMOVE REDUNDANT SUBTERM PREDICATE FROM AN OR PREDICATE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
An OR(disjunct) predicate has multiple subterm predicates, called SP1, SP2, and so on. Each OR subterm predicate SP is either a simple predicate or multiple predicates combined with AND (conjunct). Given two subterm predicates, SPi and SPj, if SPi is identical to SPj or SPi is identical to any conjunct predicate under SPj, SPj has no filtering effect and will be removed from the parent OR predicate. As example: select * from table where ( ( col1 = 1 ) or ( col1 = 2 ) ) or ( ( col2 = 1 ) and ( col1 = 2 ) ) P1: ( col1 = 1 ) or P2: ( col1 = 2 ) ) or P3: ( ( col2 = 1 ) and ( col1 = 2 )) Predicate P3 is redundant - it is true only if P2 is true, thus can be safely removed during query rewrite phase | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.7 Fixpak 8 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 9.7 Fixpak 8 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC91303 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.11.2012 29.04.2013 29.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |