|
Problem IC65255
|
Status: Geschlossen |
QUERY CONTAINING LEFT/RIGHT OUTER JOIN (LOJ), UNION ALL AND ANSI INNER JOIN OVER DISTINCT SUBSELECT WITH LOJ MAY ABEND INSTANCE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
DB2 instance may abend if a query with the following
characteristics is issued:
- Contains a subselect which consumes the output of a union all
(UA) and an ansi inner join (IJ)
- The subselect joins the UA and IJ with a left or right outer
join (LOJ) where the UA is a null-producer for the LOJ
- The IJ consumes a distinct subselect (DISTSEL)
- DISTSEL contains a left or right outer join (LOJ') |
| Problem-Zusammenfassung: |
DB2 instance may abend if a query with the following
characteristics is issued:
- Contains a subselect which consumes the output of a union all
(UA) and an ansi inner join (IJ)
- The subselect joins the UA and IJ with a left or right outer
join (LOJ) where the UA is a null-producer for the LOJ
- The IJ consumes a distinct subselect (DISTSEL)
- DISTSEL contains a left or right outer join (LOJ') |
| Local-Fix: |
Rewrite the query in question to a semantically equivalent form
that precludes the conditions described |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
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 |
First fixed in DB2 UDB Version 9.1, FixPak 9 |
| Workaround |
Rewrite the query in question to a semantically equivalent form
that precludes the conditions described |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65403
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.12.2009
14.04.2010
14.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.0.,
9.1.
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
