IC65115: CREATE PROCEDURE OR FUNCTION IN A LET STATEMENT AND ASSIGN THE RETURNED VALUE TO NULL CAUSES ENGINE TO CRASH

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 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