|
Problem IC79662
|
Status: Closed |
DB2 MIGHT GIVE A -901 ON QUERY WITH DISTINCT OUTER JOIN AND IS NULL PREDICATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 970 fixpack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem is fixed in DB2 version 970 fixpack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.11.2011
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
