DB2 - Problem description
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) |