|
Problem IC65255
|
Status: Closed |
QUERY CONTAINING LEFT/RIGHT OUTER JOIN (LOJ), UNION ALL AND ANSI INNER JOIN OVER DISTINCT SUBSELECT WITH LOJ MAY ABEND INSTANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
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 |
| available fix packs: |
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
|
| Solution |
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-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65403
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.12.2009
14.04.2010
14.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.,
9.1.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
