INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The following esql/c program


$include sqlca;

#include 

main()
{
$char buffer[600];

$drop database b;
$create database b;

sprintf ( buffer, " create procedure create_function_in_sp()
DEFINE GLOBAL gl_trace SMALLINT DEFAULT 0;     IF (gl_trace = 1)
THEN       TRACE ON;    END IF; CREATE FUNCTION
get_genr_alias_doc_st(pPb_Num INTEGER, pSub_id SMALLINT, PDoc_St
CHAR(3), pI_code CHAR(5))      RETURNS CHAR(6)       return
get_genr_alias_doc_st(pPb_Num, pSub_id, PDoc_St, pI_code) ;
END FUNCTION ;  END PROCEDURE" );

$prepare p1 from :buffer;
printf( " %d 
 ",sqlca.sqlcode );
$execute p1 ;
printf( " %d 
 ",sqlca.sqlcode );
}


creates an af file with the stack

0x0000000001331ae6 (oninit) afstack
0x0000000001338cac (oninit) mt_ex_throw_sig
0x00000000012df593 (oninit) afsig_handler
0x00007f00bae71b10 (Linux) 
0x000000000064b2df (oninit) getvartype
0x0000000000819d39 (oninit) gettypeexpr
0x0000000000640039 (oninit) op_bind_rtn
0x00000000006391fc (oninit) buildexpr
0x000000000063c9b4 (oninit) expr2expr
0x000000000064cd6e (oninit) ip_bldsexpr
0x0000000000656138 (oninit) dcmpbody
0x0000000000657c55 (oninit) decompile_proc
0x00000000006772e4 (oninit) retrieve_cache
0x000000000069962e (oninit) udr_getbyid_uid
0x000000000069a820 (oninit) udr_dropid
0x00000000006718ee (oninit) pr_compile
0x00000000009787bd (oninit) creatproc
0x0000000000689a6e (oninit) aud_creatproc
0x00000000005aefb2 (oninit) excommand
0x00000000009b32ac (oninit) sq_execute


running the same statement in dbaccess will return an error
-201.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to version 14.10.xC2.                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* A create procedure statement that includes a create function *
* statement fails in getvartype instead of returning a -201    *
* syntax error.                                                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.04.2019
20.09.2019
20.09.2019

14.10.xC2