× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
NielsGron reported 2015-02-03T15:23:43Z  · last modified 2015-02-04T01:31:17Z

We are using a double quote for string compare in query for extraction of procedure


customer request
Priority Minor
Complexity Unknown
Component App - Schema Browser
Version 14.0

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.

 

1 attachment

Issue #13071

Closed
Fixed
Resolved 2015-02-03T19:32:04Z
 
 
Completion
No due date
Fixed Build v16.0.0-dev-34, v15.0.11-2, v14.0.19-2
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017