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

Provide UI changes required for changes to behavior of Update queries in Teiid

    XMLWordPrintable

Details

    • Documentation (Ref Guide, User Guide, etc.)

    Description

      Teiid 7.3 release included changes to how Teiid processes Update queries. Teiid Designer will need to change the Transformation Editor to accommodate these changes.

      The "Select" SQL will now be "analyzed" and validated to determine what "Update" capabilities will be enabled. The generated "Default" queries should also be removed and NO SQL defined if "Use Default" is enabled for Insert/Update/Delete

      This is a departure from our legacy user experience, so the UI will have to be tweaked to recognize and interpret the new validation logic and display to user whether Insert/Update/Delete will be possible base don the Select.

      One thought was decorating the I/U/D tab text with ICONS's to indicate "Allowed" or "Disallowed"

      Attachments

        1. new-update-tabs-decoration_REV_A.png
          new-update-tabs-decoration_REV_A.png
          26 kB
        2. new-update-tabs-decoration.png
          new-update-tabs-decoration.png
          40 kB
        3. override-user-sql.png
          override-user-sql.png
          17 kB
        4. status.patch
          8 kB
        5. teiid_embedded_query_updatevalidator.patch
          82 kB
        6. TEIIDDES-806-IRC-1.txt
          6 kB
        7. UpdateValidator.patch
          5 kB

        Activity

          People

            blafond Barry LaFond
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: