|
Problem IC80769
|
Status: Geschlossen |
QUERIES WITH ORDER BY AND OUTER JOINS MAY RETURN SQL1585N |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Queries with ORDER BY and Outer Joins where the ON clause of
some (or all) of the
Outer Joins contains predicates of the form (1=0) or predicates
that can be
proved it is always false may return SQL1585N. Such queries
requires the width of the rows,
the sum of the length of all the columns in the SELECT clause,
exceeding the largest pagesize
of the system temporary tablespace. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Queries with ORDER BY and Outer Joins where the ON clause of *
* some (or all) of the *
* Outer Joins contains predicates of the form (1=0) or *
* predicates *
* that can be *
* proved it is always false may return SQL1585N. Such queries *
* requires the width of the rows, *
* the sum of the length of all the columns in the SELECT *
* clause, *
* exceeding the largest pagesize *
* of the system temporary tablespace. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB version 9.7 fixpack 6. *
**************************************************************** |
| Local-Fix: |
Remove unnecessary ORDER BY columns deriving from the right
table of the LEFT OUTER JOIN
(or the left table of the RIGHT OUTER JOIN) that contains the
false predicate in the ON clause. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 6. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.01.2012
11.06.2012
11.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
