[teiid-issues] [JBoss JIRA] (TEIID-3706) Add distinct from syntax in for each row procedures

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3706:
-------------------------------------

             Summary: Add distinct from syntax in for each row procedures
                 Key: TEIID-3706
                 URL: https://issues.jboss.org/browse/TEIID-3706
             Project: Teiid
          Issue Type: Enhancement
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
            Priority: Minor
             Fix For: 8.12


Similar to postgresql, it would be good to allow for a quick comparison of new/old values to determine if row processing is needed.  Something like:

IF new IS DISTINCT FROM old THEN
...




--
This message was sent by Atlassian JIRA
(v6.4.11#64026)