DB2 - Problembeschreibung
Problem IT02262 | Status: Geschlossen |
DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERY WITH MULTIPLE QUANTIFIED SUBQUERIES IN OR PREDICATE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Under rare scenarios, DB2 might produce incorrect results if the following conditions are true: 1) The query contains 2 or more quantified subqueries. There are subqueries of the form ALL, ANY, SOME 2) The subqueries are part of an OR predicate 3) The result set within one or more subqueries is empty eg. select * from t1 where (exists (select * from t3 where t1.c1 = t3.c1) OR c1 = ANY (select c1 from t4)); | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 Cancun Release 10.5.0.4 * **************************************************************** | |
Local-Fix: | |
db2set -im DB2COMPOPT=NO_EORE | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 Cancun Release 10.5.0.4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.06.2014 03.11.2014 03.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |