DB2 - Problembeschreibung
Problem IC84690 | Status: Geschlossen |
QUERY WITH A UNION AND TWO CORRELATED BRANCHES MIGHT RETURN INCORRECT RESULTS IN PARTITIONED DATABASE ENVIRONMENTS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If you are using the partitioned database environment and your query satisfies the following conditions, then the results returned might be incorrect 1. there is a table, T1, that is hash distributed across two or more database partitions; 2. T1 is correlated to multiple branches below a UNION; 3. each branch of the UNION is correlated to at least one different column in T1; 4. one of the branches is correlated to the hash distribution key of T1; 5. the columns in the select list of each UNION branch includes the correlation column. The following is an example of a query that satisfies the above conditions, where T1 is hash distributed on column X: SELECT * FROM T1, TABLE(SELECT X FROM T2 WHERE X = T1.X UNION ALL SELECT Y FROM T3 WHERE Y = T1.Y); | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users of database partitioning feature. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.5 Fix Pack 10 * **************************************************************** | |
Local-Fix: | |
You can avoid the problem by rewriting the query to remove the correlation below the UNION. | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 10 | |
Workaround | |
See Local Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC85422 IC85425 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.06.2012 21.08.2012 07.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |