subquery as input to procedure fails
------------------------------------
Key: TEIID-849
URL:
https://jira.jboss.org/browse/TEIID-849
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.0
A subquery as an input to a procedure (exec) will fail because it is never resolved.
Also within the scope of a procedure something like:
select e1 into #t1 from pm1.g1;
select e2 from (exec pm1.sq2((select max(e1) from #t1))) x;
will fail since the temp table store is not known inside the procedure plan that is
evaluating the input parameters.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: