APAR status
Closed as program error.
Error description
If the value within brackets in a select statement is greater than the number of characters within single quotes, the engine will assert fail and crash. Example syntax: SELECT '1234'[5] FROM TABLE' stack trace: afstack mt_ex_throw_sig afsig_handler p_smdotted p_smexpr p_smselect p_smunion p_smquery p_smstmt p_smentry spparse parsecmd sqcmd sq_cmnd sq_prepare sqmain spawn_thread startup *nosymtab
Local fix
Use this syntax instead: SELECT '1234' FROM TABLE
Problem summary
**************************************************************** * USERS AFFECTED: * * 11.50.XCX users * **************************************************************** * PROBLEM DESCRIPTION: * * Server can crash when user uses this negative case i.e. * * doing subscript operation on the constant string where the * * index of the subscript is beyond the string length. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC9. * ****************************************************************
Problem conclusion
Server will no longer crash but will return an error for the case i.e. doing subscript operation on the constant string where the index of the subscript is beyond the string length. Fixed in IDS 11.50.xC9.
Temporary fix
Comments
APAR Information
APAR number
IC76167
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-04
Closed date
2011-09-27
Last modified date
2011-09-27
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 September 2011