DB2 - Problem description
Problem IT37674 | Status: Closed |
WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Inconsistent results are possible when SELECT COUNT query is executed on "ORGANIZE BY COLUMN" table. The issue is happening due to internal dictionary and encoding optimizations. Query has to have an equality predicate. Example: select count(*) from t1 where myint=563422 The issue does not happen if the predicate is changed to use "like" or an arithmetic operation: select count(*) from t1 where myint like '563422%' select count(*) from t1 where (myint*2) = 1126844 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Columnar tables only * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description and install the fix * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Columnar tables only * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description and install the fix * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.07.2021 01.12.2021 09.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |