|
Problem IT01340
|
Status: Geschlossen |
INCORRECT RESULTS MIGHT BE RETURNED WHEN QUERYING A COLUMN-ORGANIZED TABLE WHEN USING "GROUP BY <INTEGER_COLUMN>" |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Incorrect results might be returned when querying a
column-organized table when all of the following is true:
- The table was populated with the LOAD command.
- The table has a column that is defined using an integer data
types (SMALLINT, INT, or BIGINT).
- The table is queried using a "GROUP BY <integer column>"
clause. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5.0.4. *
**************************************************************** |
| Local-Fix: |
To workaround the problem populate the table with the IMPORT or
INGEST utility instead of the LOAD command.
No permanent damage is caused by this problem. Simply apply the
fix and rerun the SQL statement. |
| verfügbare FixPacks: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
The problem was first fixed in DB2 version 10.5.0.4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.04.2014
08.09.2014
08.04.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
