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

For Each processing for instead of triggers should materialize change set before processing

    XMLWordPrintable

Details

    Description

      Currently when a view is defined with Inserts, Updates and Deletes with Instead of Triggers with "FOR EACH" row processing, the change set (the rows that are changing for the statement) typically is like

      loop on (select ids from (view) where predicate) 
      begin 
          procedure body 
      end 
      

      where there is a possibility that "procedure body" will change underlying tables such that the "loop on" query results could vary during the processing. Like concurrent updates. This could be avoided by materializing the ids in #temp table before processing any of the rows.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: