[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 resolved TEIID-2237.
-----------------------------------

    Resolution: Done


fixed the parsing and non-prepared binding logic.  the were additional unit tests added, but as part of the refactoring for TEIID-2177.
                
> jdbc native query issues
> ------------------------
>
>                 Key: TEIID-2237
>                 URL: https://issues.jboss.org/browse/TEIID-2237
>             Project: Teiid
>          Issue Type: Feature Request
>    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