|
Problem IC80769
|
Status: Closed |
QUERIES WITH ORDER BY AND OUTER JOINS MAY RETURN SQL1585N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| 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 was first fixed in DB2 UDB Version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.01.2012
11.06.2012
11.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
