[jira] [Created] (IGNITE-9873) SQL: MERGE requires column names specified explicitly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-9873) SQL: MERGE requires column names specified explicitly

JIRA jira@apache.org
Pavel Kuznetsov created IGNITE-9873:
---------------------------------------

             Summary: SQL: MERGE requires column names specified explicitly
                 Key: IGNITE-9873
                 URL: https://issues.apache.org/jira/browse/IGNITE-9873
             Project: Ignite
          Issue Type: Bug
            Reporter: Pavel Kuznetsov


Doc (https://apacheignite-sql.readme.io/docs/merge) defines MEGE operator:

{noformat}
MERGE INTO tableName [(columnName [,...])]
  [KEY (columnName [,...])]
  {VALUES {({ DEFAULT | expression } [,...])} [,...] | select}
{noformat}

So square brackets tell us columnName part can ben ommited. But in this case we'll have parsing error.

How to reproduce:
execute sql script via any api.

{noformat}
CREATE TABLE TEST (ID LONG PRIMARY KEY, VAL LONG);
MERGE INTO TEST VALUES (1, 2);
{noformat}

But command below works well though:
{noformat}
MERGE INTO TEST (ID, VAL) VALUES (1, 2);
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)