Informix - Problem description
Problem IT28752 | Status: Closed |
CREATE SP INCLUDING A CREATE FUNCTION STATEMENT FAILS IN GETVARTYPE INSTEAD OF RETURNING A -201 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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. | |
Problem Summary: | |
**************************************************************** * 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: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.04.2019 20.09.2019 20.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
14.10.xC2 | |
Problem solved according to the fixlist(s) of the following version(s) |