Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC80062 Status: Geschlossen

OPTIMIZER INCORRECT RESULTS FOR JOIN WITH REDUNDANT PREDICATES ON DPF

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
Different results for a query on DPF and non-DPF systems 
 
 
The following query returns no rows on non DPF , but 
incorrectly 2 rows on DPF 
 
WITH val (a1)   AS (VALUES ('')) ,def (a2,b2) AS (VALUES 
('dsf',''), 
('tsx','')) ,sel AS ( SELECT val.a1 ,'' AS c FROM val LEFT OUTER 
JOIN 
def ON def.a2 = '' ) SELECT def.a2 ,sel.a1 ,sel.c FROM def INNER 
JOIN 
sel ON def.a2 = sel.a1 AND def.b2 = '' ; 
 
 
(no tables required )
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.1 Fix Pack 12                       * 
****************************************************************
Local-Fix:
set optimization level 1
Lösung
Upgrade to DB2 version 9.1 Fix Pack 12
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.11.2011
31.10.2012
31.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP12
Problem behoben lt. FixList in der Version
9.1.0.12 FixList