[teiid-issues] [JBoss JIRA] (TEIID-2237) jdbc native query issues

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-2237:
----------------------------------

    Issue Type: Bug  (was: Feature Request)

    
> jdbc native query issues
> ------------------------
>
>                 Key: TEIID-2237
>                 URL: https://issues.jboss.org/browse/TEIID-2237
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.2
>
>
> A non-prepared procedure only works if the procedure has no parameters.  It should be allowed to work even with parameters through literal substitution.
> Also the parsing loop incorrectly increments the parsing position after a match.  This means that the character after a positional reference is lost.  The workaround for typical scenarios would be to use extra whitespace. i.e.
> instead of {code}select * from tbl where x = $1 and y = $2{code}
> use {code}select * from tbl where x = $1  and y = $2{code}
> Note the extra space after $1.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira