|
Problem IC99823
|
Status: Geschlossen |
-901 FROM RUNNING A QUERY. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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". |
| Lösung |
fixed in fp10. |
| Workaround |
n/a |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.03.2014
18.02.2015
18.02.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.10
|
 |
