|
Problem IC99823
|
Status: Closed |
-901 FROM RUNNING A QUERY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Some necessary conditions to hit the problem are:
The query is in a pattern of
SELECT FROM (<SUBQUERY1> as A, (SELECT FROM WHERE <ANYCOL> IN
<SUBQUERY2>) as B) WHERE A.col1 = B.col1 GROUP BY A.col2;
here,
SUBQUERY1 = SELECT col1, col2 from <SUBQUERY3> GROUP BY col1,
col2
SUBQUERY2 = SELECT DISTINCT col1 from <SUBQUERY3>
SUBQUERY3 = SELECT col1, col2 from <base tables> WHERE
<ANYPREDICATES> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* v9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Some necessary conditions to hit the problem are: *
* The query is in a pattern of *
* SELECT FROM (<SUBQUERY1> as A, (SELECT FROM WHERE <ANYCOL> *
* IN *
* <SUBQUERY2>) as B) WHERE A.col1 = B.col1 GROUP BY A.col2; *
* *
* here, *
* SUBQUERY1 = SELECT col1, col2 from <SUBQUERY3> GROUP BY *
* col1, *
* col2 *
* SUBQUERY2 = SELECT DISTINCT col1 from <SUBQUERY3> *
* SUBQUERY3 = SELECT col1, col2 from <base tables> WHERE *
* <ANYPREDICATES> *
****************************************************************
* RECOMMENDATION: *
* apply fp10 *
**************************************************************** |
| Local Fix: |
Manually rewrite SUBQUERY2 from "SELECT DISTINCT col1 from
<SUBQUERY3>" to "SELECT col1 from <SUBQUERY3> GROUP BY col1". |
| Solution |
fixed in fp10. |
| Workaround |
n/a |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.03.2014
18.02.2015
18.02.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
