[ https://issues.apache.org/jira/browse/IGNITE-14573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324300#comment-17324300 ]
Stanilovsky Evgeny commented on IGNITE-14573: --------------------------------------------- This patch fixes _null_update_merge.test_ but need to decide what to do with "!=" syntax. > DML operations failure. > ----------------------- > > Key: IGNITE-14573 > URL: https://issues.apache.org/jira/browse/IGNITE-14573 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Stanilovsky Evgeny > Assignee: Stanilovsky Evgeny > Priority: Major > Labels: calcite > Time Spent: 10m > Remaining Estimate: 0h > > As a result, insert with further read operations will fail. > For example: > {code:java} > CREATE TABLE IF NOT EXISTS test (id INTEGER, a INTEGER); > INSERT INTO test VALUES (1, 1), (2, 2), (3, 3), (4, NULL);" > UPDATE test SET a=CASE WHEN id=1 THEN 7 ELSE NULL END WHERE id <= 2"; > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)