IT06676: EQUAL EXPRESSION USING A SPL CALL IN A WHERE CLAUSE IN A STORED PROCEDURE CAN RETURN 9791/110 IN EV_PROCVAR/GETVARDATA

APAR status

• Closed as program error.

Error description

• When a select in a stored procedure is using an expression like
  
      let mnewklass  = (select a.klass from ccontract a
  --> here
                         where
  a.number==vklgetccont(VKL_CR_CONTRACT,'L')
                           and ncontract==VKL_CR_CONTRACT);
  
  where a stored procedure is called on the right hand side of an
  equal expression,
  the server can return 9791 / -110 to the session and write an
  assert failure file with the following
  stack:
  
  oninit :: var_unset_err
  oninit :: getvardata
  oninit :: geval
  oninit :: routine_evalargs
  oninit :: exroutine
  oninit :: multiexcmp
  oninit :: geval
  oninit :: ev_geval2
  oninit :: new_eval
  oninit :: readidx_new
  oninit :: gettupl
  oninit :: scan_next
  oninit :: getrow
  oninit :: fetchrow
  oninit :: doselect
  oninit :: exsubq
  oninit :: ev_cb
  oninit :: new_eval
  oninit :: ip_evalexpr
  oninit :: runproc
  oninit :: udrlm_spl_execute
  oninit :: udrlm_exec_routine
  oninit :: udr_execute
  oninit :: udr_spl_curnext
  oninit :: ip_curnext
  oninit :: ip_fetch
  oninit :: getrow
  oninit :: fetchrow
  oninit :: exfetch
  oninit :: sql_nfetch
  oninit :: sq_nfetch
  oninit :: sqmain
  oninit :: listen_verify
  oninit :: spawn_thread
  oninit :: th_init_initgls
  oninit :: startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Iterative stored procedure used inside the query             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10                          *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RC10 PSY

     UP