|
Problem IT35670
|
Status: Closed |
REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAYRESULT IN -901
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Query execution may return -901 when the query includes one of
following builtin functions, the first argument (source
string) has string units CODEUINTS32 and it is derived from a
column-organized table:
REGEXP_EXTRACT (synonym for REGEXP_SUBSTR)
REGEXP_REPLACE
REGEXP_SUBSTR
And the REGEXP function in the context of DISTINCT or the
MIN/MAX aggregate functions. For example:
select distinct regexp_replace(cu32,'','') from columnarTable;
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
MinMaxPartialEvaluator.cpp:98".)
SQLSTATE=58004 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to in Db2 version 11.5.5.1 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to in Db2 version 11.5.5.1 *
**************************************************************** |
| Comment |
First fixed in Db2 version 11.5.5.1 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2021
01.04.2021
01.04.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
