Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4235

dynamic sql recursion check not valid after caught exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0, 8.12.5, 8.13.5
    • 8.7
    • Query Engine
    • None

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: