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

anonymous block dynamic issues

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 9.2, 9.1.3
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Using execute immediate 'begin ... end'

      Has several issues. First any variable references such as rowcount will be rewritten in the outer scope and not evaluated as part of the procedure. Also the anonymous block cannot be used with targeting an into as the statement we create is insert into select ... from (begin ... end) .. - which is not valid, however the exception message does not make this clear.

      So we either need to improve these issues or disallow using anonymous blocks as dynamic sql.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: