[teiid-issues] [JBoss JIRA] (TEIID-2145) DDL options clause with namespace prefix is failing to parse correctly

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711325#comment-12711325 ] 

Steven Hawkins commented on TEIID-2145:
---------------------------------------

It needs quoted.
                
> DDL options clause with namespace prefix is failing to parse correctly
> ----------------------------------------------------------------------
>
>                 Key: TEIID-2145
>                 URL: https://issues.jboss.org/browse/TEIID-2145
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.1
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>
> when there is namespace prefix in the options clause with DDL metadata it fails to parse colon (:) as the prefix separator. for example ddl below will fail
> {code}
>  SET NAMESPACE 'http://teiid.org/rest' AS REST;
>             CREATE VIRTUAL PROCEDURE g1Table() RETURNS TABLE (xml_out xml) OPTIONS (UPDATECOUNT 0, REST:METHOD 'GET', REST:URI 'g1')
>             AS
>             BEGIN
>                 SELECT XMLELEMENT(NAME "all", XMLAGG(XMLELEMENT(NAME "row", XMLFOREST(e1, e2)))) AS xml_out FROM Txns.G1;
>             END        
> {code}
> either Teiid needs to find another delimiter or escape it or parser it as string rather than in id() in the parser

--
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