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

Add distinct from syntax in for each row procedures for Teiid

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Issue Links

          clones

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIIDDES-2652 Add distinct from syntax in for each row procedures

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: