APAR status
Closed as program error.
Error 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 <signal frame> valstore_deepcopy merge_next sort_open prepselect open_cursor sq_open sqmain spawn_thread th_init_initgls startup
Local fix
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). * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC6.
Temporary fix
Comments
APAR Information
APAR number
IT36187
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-11
Closed date
2021-05-12
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024