|
Problem IC73756
|
Status: Geschlossen |
DB2 MAY RETURN INCORRECT RESULT FROM SELECT DISTINCT LEFT OUTER JOIN UNION ALL VIEW |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
An SQL statement to perform a left outer join between tables or
views along with a UNION ALL view may return incorrect results.
The UNION ALL view must be the right table or null-producing
table of the left outer join. In addition, the SELECT clause
must be specified with DISTINCT for the tables or views.
The above mentioned scenario will likely cause DB2 to return
more rows from the left outer joining process, than the optimum
value. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of Db2 V9.1, V9.5, V9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* An SQL statement to perform a left outer join between tables *
* or *
* views along with a UNION ALL view may return incorrect *
* results. *
* The UNION ALL view must be the right table or null-producing *
* *
* table of the left outer join. In addition, the SELECT clause *
* *
* must be specified with DISTINCT for the tables or views. *
* *
* *
* *
* *
* *
* The above mentioned scenario will likely cause DB2 to return *
* *
* more rows from the left outer joining process, than the *
* optimum *
* value. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to most current fix pack. *
**************************************************************** |
| Local-Fix: |
Run the following commands to stop DB2 instance, set the
registry variable and restart DB2:
db2stop force
db2set DB2_UNION_OPTIMIZATION=DISABLE_OJPPD_FOR_NP
db2start
This will avoid optimization that can lead to incorrect results. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.01.2011
08.12.2011
08.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.11
|
 |
