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

Tue Oct 2 16:20:03 EDT 2012

Steven Hawkins created TEIID-2237:
-------------------------------------

             Summary: 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 "select * from tbl where x = $1 and y = $2", 
use "select * from tbl where x = $1  and y = $2"

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