home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC91290 Status: Geschlossen

A RECURSIVE UNION ALL QUERY USING TYPED PARAMETER MARKER FOR SEED ARM AND
LITERAL VALUE FOR ITERATIVE ARM, MAY FAIL WITH -344

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
The problem may occur if the seed arm of UNION ALL has a typed 
parameter marker and the iterative arm has a specific literal 
value. 
 
Here is the example of the query: 
 
WITH CTE1 (TEST_VAR) 
AS 
( 
SELECT CAST( ? AS CHAR(2)) 
FROM Table (values (1)) 
UNION ALL 
SELECT CAST( 'ab' AS CHAR(2)) 
FROM CTE1 T1 
WHERE T1.TEST_VAR = ?) SELECT * from CTE1 ;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2 v101fp3                                       * 
****************************************************************
Local-Fix:
Use literal values or typed parameter markers for both arms of 
UNION ALL.
Lösung
db2v101fp3 ,the query will compile successfully
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.04.2013
17.10.2013
17.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version