[
https://issues.jboss.org/browse/TEIIDDES-923?page=com.atlassian.jira.plug...
]
Mark Drilling resolved TEIIDDES-923.
------------------------------------
Fix Version/s: 7.7
Resolution: Done
Modified PreviewDataWorker, which was not doing the parameter replacement correctly for
null values.
Passing NULL into a Procedure in Preview Causes Exception
---------------------------------------------------------
Key: TEIIDDES-923
URL:
https://issues.jboss.org/browse/TEIIDDES-923
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 7.4
Reporter: Ted Jones
Assignee: Mark Drilling
Fix For: 7.7
I have a virtual procedure that accepts one parameter that may be null. When I pass a
value in it works fine but when I check the NULL checkbox fir the input variable I get the
following exception, "Remote org.teiid.api.exception.query.QueryValidatorException:
Bind variables (represented as "?") were found but are allowed only in prepared
or callable statements."
Here is the generated query from preview: select * from ( exec RestfulBooks.getBooks(?) )
AS X_X
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira