DB2 - Problembeschreibung
Problem IC65953 | Status: Geschlossen |
RECURSIVE QUERY WITHOUT INITIALIZATION FULLSELECT HANGS DURING COMPILATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
A recursive query that is missing the initialization full select hangs during compilation. Here is an example of such a query: with tab (col) as (select 'const' from tab) select * from tab Because there is no initialization full select, the query would never return any rows. This is a badly written query where the intention was either: a) a recursive query but the initialization full select was merely neglected b) that the table reference 'tab' in the the common table expression full select is a real table. In this case, the table references must be changed or qualified to avoid confusion, e.g.: with A.tab (col) as (select 'const' from B.tab) select * from A.tab | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Recursive query * **************************************************************** * PROBLEM DESCRIPTION: * * A recursive query that is missing the initialization full * * select hangs during compilation. * * Here is an example of such a query: * * * * with tab (col) as (select 'const' from tab) select * from * * tab * * * * Because there is no initialization full select, the query * * would never return any rows. This is a badly written query * * where the intention was either: * * * * a) a recursive query but the initialization full select was * * merely neglected * * b) that the table reference 'tab' in the the common table * * expression full select is a real table. In this case, the * * table references must be changed or qualified to avoid * * confusion, e.g.: * * * * with A.tab (col) as (select 'const' from B.tab) select * * * * * from A.tab * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.5 Fix Pack 6 or later * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 version 9.5 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65954 IC65955 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.01.2010 17.03.2010 17.03.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |