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

Enhance MERGE to support INSERT/UPDATE and DELETE

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.4
    • Query Engine
    • None

      Add delete support to MERGE. Example is SQL Server:

      MERGE <target_table> [AS TARGET]
      USING <table_source> [AS SOURCE]
      ON <search_condition>
      [WHEN MATCHED
      THEN <merge_matched> ]
      [WHEN NOT MATCHED [BY TARGET]
      THEN <merge_not_matched> ]
      [WHEN NOT MATCHED BY SOURCE
      THEN <merge_ matched> ];

            Unassigned Unassigned
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: