|
Problem IT36498
|
Status: Closed |
DB2 MAY RETURN
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When customer is trying to concatenate a non-string(numerics)
with a string(varchar), DB2 will implicitly cast non-string to a
string. Because the default string units are CODEUNITS32 and
each character takes 4 bytes, DB2 need to fix the string length.
A bug exists in this step; if the numeric is a column from a
column-organized table one of the following errors may occur:
SQL0901N Â The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
MinMaxPartialEvaluator.cpp:98".) SQLSTATE=58004
or
SQL0901N Â The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
GetJoinPayloadEvaluator.cpp:167.") SQLSTATE=58004
An FODC_AppErr will be generated. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of DB2 with Column-organized databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 11.5 Mod 6 *
**************************************************************** |
| Local Fix: |
Modify the query so that the non-string is explicitly CAST to a
string by use of the CAST function. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All users of DB2 with Column-organized databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 11.5 Mod 6 *
**************************************************************** |
| Comment |
Problem fixed in DB2 11.5 Mod 6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.04.2021
21.06.2021
21.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
