DB2 - Problembeschreibung
Problem IT25735 | Status: Geschlossen |
INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
This issue can only happen in Fixpaks 8,9 and 10. Users might observe incorrect results when running a query with the following characteristics: 1. the query has an outer join 2. the outer join columns contain expressions 3. the row preserving side of the outer join has a GB or UNION 4. the null producing side of the outer join has a GB, UNION or CSE 5. there is at least one outer join predicate referencing only the null producing columns The wrong result set usually contains less rows than the correct result set. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 11 or higher * **************************************************************** | |
Local-Fix: | |
N/A | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : IT25706 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.07.2018 25.02.2020 25.02.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |