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

support UPDATE SQL JOIN / FROM

    Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 13.x
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Teiid currently supports basic SET = value WHERE = value syntax.

      Having the ability to join for an UPDATE would allow to be pulled from various sources and not value updates at a time.

      The link below contains examples of various syntaxes of an UPDATE with a JOIN could be accomplished.

      http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

      This enhancement request was the result of the discussion here:
      https://developer.jboss.org/thread/273066

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                omarbkhan Omar Khan
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: