DB2 - Problembeschreibung
Problem IC80744 | Status: Geschlossen |
QUERIES WITH ORDER BY AND OUTER JOINS MAY RETURN SQL1585N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - 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.5 fixpack 10. * **************************************************************** | |
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. | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.5 FixPack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC80769 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.01.2012 22.08.2012 22.08.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |