Informix - Problem description
Problem IT36187 | Status: Closed |
SERVER ASSERT FAIL IN VALSTORE_DEEPCOPY FROM QUERY USING UNION AND CONCAT OF CHARACTER FIELDS > 215 AND OTHER FIXED TYPES | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
The following SQL reproduces the problem: create temp table p ( pa1_name char(60) not null ); insert into p values ("NAME"); select pa1_name || 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' || 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' || 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' || 'aaaaaa' || 1 from p union select " " as Description from p ; However the problem will only reproduce if the 0x1000 flag is NOT present in SQL_FEAT_CTRL2 (this flag is present by default) The stack from the asserting thread is as follows: afstack mt_ex_throw_sig afsig_handler valstore_deepcopy merge_next sort_open prepselect open_cursor sq_open sqmain spawn_thread th_init_initgls startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.03.2021 12.05.2021 12.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |