[teiid-issues] [JBoss JIRA] (TEIID-2237) jdbc native query issues
[
https://issues.jboss.org/browse/TEIID-2237?page=com.atlassian.jira.plugin...
]
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