[IGNITE-9873] SQL: MERGE requires column names specified explicitly

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Pavel Kuznetsov
• Created: 12/Oct/18 14:07
• Updated: 12/Oct/18 15:04

Description

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

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

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.

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

But command below works well though:

MERGE INTO TEST (ID, VAL) VALUES (1, 2);