DB2 - Problem description
Problem IT17712 | Status: Closed |
USING ARRAY() CRASHES DB2 INSTANCE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Using ARRAY() will crash the DB2 instance with the following function stack: sqlnq_proc_agf sqlnq_sem_function_call sqlnp_smactn sqlnp_parser sqlnp_main sqlnn_cmpl sqlnn_cmp sqlra_compile_var sqlra_find_var The problem can be reproduced by: CREATE TABLE ADDRESS" ( "O_I_IDF" BIGINT NOT NULL , "T_I_STREET" VARGRAPHIC(100 CODEUNITS16) NOT NULL , "T_I_HOUSE_NUMBER" VARGRAPHIC(10 CODEUNITS16) NOT NULL , "T_I_POSTAL_CODE" VARGRAPHIC(20 CODEUNITS16) NOT NULL , "T_I_CITY" VARGRAPHIC(100 CODEUNITS16) NOT NULL , "C_I_COUNTRY_CODE" VARCHAR(5 OCTETS) , "T_I_COUNTRY" VARGRAPHIC(100 CODEUNITS16) NOT NULL ) ; ALTER TABLE ADDRESS ADD CONSTRAINT "ADDRESS_PK" PRIMARY KEY ("O_I_IDF"); select array(a.o_i_idf) into add_de from address a; | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade DB2 Server to v10.5 Fix Pack 9 * **************************************************************** | |
Local Fix: | |
Do not use ARRAY() this is unsupported SQL, instead use ARRAY_AGG() | |
Solution | |
Problem first fixed in v10.5 Fix Pack 9 | |
Workaround | |
See LOCAL FIX | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |