|
Problem IT34658
|
Status: Closed |
DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Db2 query may generate FODC and APP_Err or wrong result when the
following conditions are met:
-NPS mode is set ("export SQL_COMPAT = 'NPS' " for IIAS and
Netezza compatibility mode)
-Source is a partitioned column-organized table
-There is a subtraction between dates
-At least one argument of the date subtraction is nullable
Repro:
create table t1_date(nullableC1 date ,notnullableC2 date not
null) organize by column;
insert into t1_date values(null, current date);SET
SQL_COMPAT='NPS';
select (nullableC1-notnullableC2) from t1_date; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* db2 luw users *
****************************************************************
* PROBLEM DESCRIPTION: *
* Db2 query may generate FODC and APP_Err or wrong result when *
* the following conditions are met: *
* -NPS mode is set *
* -Source is a partitioned column-organized table *
* -There is a subtraction between dates *
* -At least one argument of the date subtraction is nullable *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Local Fix: |
NA |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* db2 luw users *
****************************************************************
* PROBLEM DESCRIPTION: *
* Db2 query may generate FODC and APP_Err or wrong result when *
* the following conditions are met: *
* -NPS mode is set *
* -Source is a partitioned column-organized table *
* -There is a subtraction between dates *
* -At least one argument of the date subtraction is nullable *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.10.2020
31.03.2021
06.04.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
