Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2505

Add distinct from syntax in for each row procedures for Teiid

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Obsolete
    • Icon: Minor Minor
    • 4.6.0.Final
    • None
    • Sequencers
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes

      TEIID-3546 allows for a quick comparison of row values:

      IF (\"new\" IS [NOT]DISTINCT FROM \"old\")
      BEGIN
      ...
      END

      This can currently only be used in an IF statement.

      See https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQLGrammar-ifStatement

              Unassigned Unassigned
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: