[jira] [Created] (CALCITE-5326) SqlMerge generate extra bracket on toSqlString

["Christophe Le Saec (Jira)" <ji...@apache.org>]

Christophe Le Saec created CALCITE-5326:
-------------------------------------------

             Summary: SqlMerge generate extra bracket on toSqlString
                 Key: CALCITE-5326
                 URL: https://issues.apache.org/jira/browse/CALCITE-5326
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Christophe Le Saec
         Attachments: SqlMergeTest.java

Following this [mails exchange|https://lists.apache.org/thread/pgycm37ld6v92llv1t6bdmk80wylcspj], i build this JIRA about SQL Merge.
Using SQLMerge on this unit test [^SqlMergeTest.java] i tried to generate [SQL Merge SQL code|https://en.wikipedia.org/wiki/Merge_(SQL)].
this generate
{code:sql}
MERGE INTO "OUT_TABLE" AS "Target"
USING "IN_TABLE" AS "Source"
ON "TARGET"."ID" = "SOURCE"."IDENT"
WHEN MATCHED THEN UPDATE SET "TARGET"."FIELD1" = "SOURCE"."F1", "TARGET"."FIELD2" = "SOURCE"."F2"
WHEN NOT MATCHED THEN INSERT ("TARGET"."ID", "TARGET"."FIELD1", "TARGET"."FIELD2") (VALUES ("SOURCE"."IDENT", "SOURCE"."F1", "SOURCE"."F2"))
{code}
that doesn't work because of the bracket before VALUES on last line.

just removing brackets
{code:sql}
WHEN NOT MATCHED THEN INSERT ("TARGET"."ID", "TARGET"."FIELD1", "TARGET"."FIELD2") VALUES ("SOURCE"."IDENT", "SOURCE"."F1", "SOURCE"."F2")
{code}
make the query work.



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