[jira] [Created] (TRAFODION-1509) MERGE DELETE + WHEN NOT MATCHED clause

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

David Wayne Birdsall created TRAFODION-1509:
-----------------------------------------------

             Summary: MERGE DELETE + WHEN NOT MATCHED clause
                 Key: TRAFODION-1509
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1509
             Project: Apache Trafodion
          Issue Type: New Feature
          Components: sql-cmp
    Affects Versions: 1.2-incubating
            Reporter: David Wayne Birdsall
            Priority: Minor


MERGE DELETE + WHEN NOT MATCHED clause is partially implemented in the Trafodion compiler. At the moment, it is controlled by CQD COMP_BOOL_175. If this CQD is 'ON', the feature is activated. The default is 'OFF' and results in a SQL error 3241 if attempted. Before pull request #102 (associated with JIRA TRAFODION-25), the existing implementation of MERGE DELETE + WHEN NOT MATCHED yields semantically incorrect plans when the TSJRule is invoked in the optimizer. When the TSJRule is invoked the resulting plan fails to execute the WHEN NOT MATCHED clause. Pull request #102 fixes this, by not allowing the TSJRule to fire in this case. Unfortunately optimization fails in Phase 1 for lack of plan with this change. This JIRA is being filed so that follow-up work in this area can be done.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)