|
Problem IT01340
|
Status: Closed |
INCORRECT RESULTS MIGHT BE RETURNED WHEN QUERYING A COLUMN-ORGANIZED TABLE WHEN USING "GROUP BY <INTEGER_COLUMN>" |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
The problem was first fixed in DB2 version 10.5.0.4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.04.2014
08.09.2014
08.04.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
