APAR status
Closed as program error.
Error description
Create procedure or function in a LET statement and assign the returned value to null causes engine to crash. Query Example: ============== CREATE Function test_pro() RETURNING INTEGER; DEFINE trid INTEGER; LET user = ''; begin on exception TRACE 'hit my error'; end exception Select tr_id into trid From er_trans; if trid > 3 then raise exception 96; end if; end RETURN trid; End Function; Stacks Example: ================ (oninit)afstack (oninit)mt_ex_throw_sig (oninit)afsig_handler (oninit)p_smstmt (oninit)p_smentry (oninit)spparse (oninit)parsecmd (oninit)sqcmd (oninit)sq_cmnd (oninit)sq_prepare (oninit)sqmain (oninit)spawn_thread (oninit)startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Informix 11.50 users * **************************************************************** * PROBLEM DESCRIPTION: * * When used illegally, the system oprtator e.g. USER, TODAY, * * etc. can crash the server. * **************************************************************** * RECOMMENDATION: * * Upgrade to latest 11.50.xC7 and above. * ****************************************************************
Problem conclusion
Problem first fixed in Informix 11.50.xC7
Temporary fix
Comments
APAR Information
APAR number
IC65115
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
2009-12-11
Closed date
2010-10-01
Last modified date
2010-10-01
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":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 October 2010