|
Problem IC79641
|
Status: Closed |
DB2 MIGHT GIVE A -901 ON QUERY WITH DISTINCT OUTER JOIN AND IS NULL PREDICATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
DB2 might give a -901 if the query satisfies the following
conditions:
1. The query has an outer join between base tables.
2. The outer join has a DISTINCT.
3. The output column list from outer join contains one or more
columns from the null producing side.
4. There is an IS NULL predicate above the outer join on the
same column(s) as 3.
eg.
Select c1 from
( select DISTINCT t1.c1, t2.c2 < ------------- condition 2,3
from t1 left join <---------------- condition 1
t2
on t1.c1 = t2.c1) tmp(c1,c2)
where tmp.c2 is null; <--------------- condition 4
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Had
troubles while
removing an unreferenced QCL.".) SQLSTATE=58004
Stack:
sqlnr_Manual2NativeAJ[85]
sqlnr_optprep[125]
sqlnr_optprep_action[100]
sqlnr_comp[110]
sqlnr_seq[100]
sqlnr_rcc[100]
sqlnr_exe[1200]
sqlnn_cmpl[370] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 might give a -901 if the query satisfies the following *
* conditions: *
* *
* 1. The query has an outer join between base tables. *
* 2. The outer join has a DISTINCT. *
* 3. The output column list from outer join contains one or *
* more *
* columns from the null producing side. *
* 4. There is an IS NULL predicate above the outer join on the *
* same column(s) as 3. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 950 fix pack 9 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in DB2 950 fix pack 9 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC79662
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2011
22.03.2012
22.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.,
9.5.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
