[jira] [Created] (CALCITE-5852) Enhance for MERGE INTO statement

["hongyu guo (Jira)" <ji...@apache.org>]

hongyu guo created CALCITE-5852:
-----------------------------------

             Summary: Enhance for MERGE INTO statement
                 Key: CALCITE-5852
                 URL: https://issues.apache.org/jira/browse/CALCITE-5852
             Project: Calcite
          Issue Type: Improvement
            Reporter: hongyu guo


In Calcite, MERGE INTO statement:
{code:sql}
merge:
      MERGE INTO tablePrimary [ [ AS ] alias ]
      USING tablePrimary
      ON booleanExpression
      [ WHEN MATCHED THEN UPDATE SET assign [, assign ]* ]
      [ WHEN NOT MATCHED THEN INSERT VALUES '(' value [ , value ]* ')' ]
{code}

SQL-2011 and postgres support for <merge when clause>:

{code:sql}
-- when matched clause
WHEN MATCHED [ AND <search condition>  ]
      THEN <merge update or delete specification> 

-- when not matched clause
 WHEN NOT MATCHED [ AND <search condition>  ]
      THEN <merge insert specification> 
{code}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)