|
Problem IC79641
|
Status: Geschlossen |
DB2 MIGHT GIVE A -901 ON QUERY WITH DISTINCT OUTER JOIN AND IS NULL PREDICATE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
The problem is first fixed in DB2 950 fix pack 9 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC79662
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.11.2011
22.03.2012
22.03.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.0.,
9.5.0
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.9
|
 |
