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

[ https://issues.jboss.org/browse/TEIID-2237?page=com.atlassian.jira.plugin... ] 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}" 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 "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