(ignite) branch master updated: IGNITE-28852 SQL Calcite: Add test for binary operator in UPDATE (#13324)

[tkalkirill]

This is an automated email from the ASF dual-hosted git repository.

tkalkirill pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ignite.git


The following commit(s) were added to refs/heads/master by this push:
     new 2dddb28a31c IGNITE-28852 SQL Calcite: Add test for binary operator in 
UPDATE (#13324)
2dddb28a31c is described below

commit 2dddb28a31c16a5ac5ed357bb2a7b8ea68719a81
Author: Kirill Tkalenko <tkalkir...@yandex.ru>
AuthorDate: Mon Jul 13 13:06:51 2026 +0300

    IGNITE-28852 SQL Calcite: Add test for binary operator in UPDATE (#13324)
---
 .../processors/query/calcite/integration/IntervalTest.java       | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git 
a/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/integration/IntervalTest.java
 
b/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/integration/IntervalTest.java
index af26b4bc618..63b2e816dfd 100644
--- 
a/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/integration/IntervalTest.java
+++ 
b/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/integration/IntervalTest.java
@@ -394,6 +394,15 @@ public class IntervalTest extends 
AbstractBasicIntegrationTest {
         assertThrows("SELECT EXTRACT(MONTH FROM INTERVAL 1 DAY)", 
IgniteSQLException.class, "Cannot apply");
     }
 
+    /** */
+    @Test
+    public void testDmlIntervalArithmetic() {
+        sql("CREATE TABLE test(ts TIMESTAMP)");
+        sql("INSERT INTO test VALUES (?)", Timestamp.valueOf("2021-01-01 
00:00:01"));
+        sql("UPDATE test SET ts = ts - INTERVAL 1 SECOND");
+        assertQuery("SELECT * FROM 
test").returns(Timestamp.valueOf("2021-01-01 00:00:00")).check();
+    }
+
     /** */
     public Object eval(String exp, Object... params) {
         return executeSql("SELECT " + exp, params).get(0).get(0);