[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:comment-tabpanel&focusedCommentId=12723741#comment-12723741 ] 

Steven Hawkins commented on TEIID-2237:
---------------------------------------

Arg... the commit set was actually https://source.jboss.org/changelog/Teiid?cs=4506 - which is incorrectly attributed to TEIID-2238.  Also line 203 should not be
{code}this.preparedValues = obj.getArguments();{code}
but instead
{code}this.preparedValues.add(obj.getArguments().get(i));{code}
which is being addressed post much refactoring on trunk.
                
> 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