[ https://issues.apache.org/jira/browse/IGNITE-10824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750842#comment-16750842 ]
Vladimir Ozerov commented on IGNITE-10824: ------------------------------------------ [~pkouznet], unfortunately fix doesn't work, I reverted it. Please take a look at {{IgniteCacheUpdateSqlQuerySelfTest}}: # Several tests fail # {{testUpdateValueAndFields}} pass, while it should fail - it has {{INSERT}} which updates both {{_VAL}} and {{ID}} field which is a part of value > 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 > Priority: Minor > Fix For: 2.8 > > Time Spent: 20m > Remaining Estimate: 0h > > 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}} and value column {{salary}}. Next > queries 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)