[teiid-issues] [JBoss JIRA] (TEIID-1920) Dynamic sql using a non-literal requires a keyword

Tue Jan 31 13:13:48 EST 2012

     [ https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1920.
-----------------------------------

    Resolution: Done

Updated the docs and the string form to use EXECUTE IMMEDIATE.  Also corrected UVAR to DVAR.

> Dynamic sql using a non-literal requires a keyword
> --------------------------------------------------
>
>                 Key: TEIID-1920
>                 URL: https://issues.jboss.org/browse/TEIID-1920
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1.1
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.7
>
>
> When entering dynamic sql in designer, the resulting string form omits the string keyword.  However the resulting form will not parse is a non-literal dynamic sql string is used.  We should use a string from that has IMMEDIATE.
> Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to DVAR.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira