Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1270

SQL Templates for Insert, Update, and Delete queries need to be modified to represent new syntax for Teiid 7.7

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 7.7
    • 7.7
    • Transformations
    • None

    Description

      The latest Teiid has changed the Update/Insert/Delete SQL to utilize the "FOR EACH ROW" concept instead of the "CREATE VIRTUAL PROCEDURE"

      Also the content of the SELECT has changed to use the NEW, OLD and CHANGED terms

      See Teiid 7.7 Reference Guide for details

      Attachments

        Issue Links

          is related to

          Sub-task - The sub-task of the issue TEIIDDES-1223 Create SQL String Template framework and dialog for use in new view construction and SQL editing

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              mdrillin1@redhat.com Mark Drilling (Inactive)
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: