If you add "delimident=y" to the driver parameter of a Server Registration for an Information connection and then try to show the Procedure Properties for a procedure, it will fail at extraction. This query will be executed and it will fail :
SELECT
OWNER,
PROCNAME,
DATA,
SP.PROCID,
ifx_param_types(sp.procid) param_types,
seqno
from
informix.sysprocedures sp,
informix.sysprocbody sb
where
sp.procid = sb.procid and
datakey = 'T' and
UPPER(procname) = UPPER('metadata') and
UPPER(owner) = UPPER('sysibm') and
ifx_param_types(sp.procid) = "" and
externalname is null
order by
sb.seqno
Reason for failure is the double quotes used in [ifx_param_types(sp.procid = ""] where we should use single quotes.
This is done in ExtractProcedure line 1118.
Made changes to extract procedure/function/params to correctly quote function call withing extraction query
Made changes to extract procedure/function/params to correctly quote function call withing extraction query
Issue #13071 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.0-dev-34, v15.0.11-2, v14.0.19-2 |
No time estimate |
This is done in ExtractProcedure line 1118.