[jira] [Created] (IGNITE-10824) SQL: mixing _key and key columns in the DML queries must be disallowed

["Pavel Kuznetsov (JIRA)" <ji...@apache.org>]

Pavel Kuznetsov created IGNITE-10824:
----------------------------------------

             Summary: SQL: mixing _key and key columns in the DML queries must be disallowed
                 Key: IGNITE-10824
                 URL: https://issues.apache.org/jira/browse/IGNITE-10824
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Pavel Kuznetsov
            Assignee: Pavel Kuznetsov


DML should contain either placeholder for _key (_val) or subset of key (value) columns but not both. Also we should keep in mind _key/_value aliases

Given table with primary key column {{id}}. Next query should be validated to parsing error:
{code:sql}
INSERT INTO TEST_TABLE (_key, id, salary) VALUES (1, 2, 42);
UPDATE TEST_TABLE SET _val = 1, salary = 2;
{code}   



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