You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Pavel Kuznetsov (JIRA)" <ji...@apache.org> on 2018/10/12 14:08:00 UTC
[jira] [Created] (IGNITE-9873) SQL: MERGE requires column names
specified explicitly
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)