[teiid-issues] [JBoss JIRA] (TEIID-4235) dynamic sql recursion check not valid after caught exception
Steven Hawkins (JIRA)
issues at jboss.org
Tue May 31 19:38:00 EDT 2016
Steven Hawkins created TEIID-4235:
-------------------------------------
Summary: dynamic sql recursion check not valid after caught exception
Key: TEIID-4235
URL: https://issues.jboss.org/browse/TEIID-4235
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
With a procedure like:
begin
execute immediate
exception e
...
execute immediate ...
An exception on the second execute immediate will be seen like:
org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ..." due to: TEIID30347 There is a recursive invocation of group 'proc'. Please correct the SQL.
Even when the dynamic sql does not re-invoke the proc. The issue is that when catching the initial exception thrown doesn't clear the entry from the recursion stack.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list