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

    Description: 
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.

  was:
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}"


    
> 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