[ https://issues.apache.org/jira/browse/IGNITE-14573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325489#comment-17325489 ]
Stanilovsky Evgeny commented on IGNITE-14573: --------------------------------------------- @ScriptRunnerTestsEnvironment(scriptsRoot = "src/test/sql", regex = "/update/null_update_merge.test") works fine for now. > 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)