py: add new negative arithmetic tests

rivudhk · mihaibudiu · commit 267b6d32d155 · 2025-10-08T15:33:45.000Z
Signed-off-by: rivudhk &lt;rivudhkr@gmail.com&gt;
diff --git a/python/tests/runtime_aggtest/negative_tests/test_neg_arithmetic.py b/python/tests/runtime_aggtest/negative_tests/test_neg_arithmetic.py
@@ -259,3 +259,183 @@ def __init__(self):
         self.expected_error = (
             "'4294966290 / 0' causes overflow for type INTEGER UNSIGNED"
         )
+
+
+# Subtraction
+class neg_sub_tiny_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_tiny_int AS SELECT
+                      - tiny_int - tiny_int2 AS tiny_int
+                      FROM numeric_tbl
+                      WHERE id = 0"""
+        self.expected_error = "'-120 - 100' causes overflow for type TINYINT"
+
+
+class neg_sub_small_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_small_int AS SELECT
+                      - small_int - small_int2 AS small_int
+                      FROM numeric_tbl
+                      WHERE id = 0"""
+        self.expected_error = "'-32750 - 32700' causes overflow for type SMALLINT"
+
+
+class neg_sub_big_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_big_int AS SELECT
+                      - big_int - big_int2 AS big_int
+                      FROM numeric_tbl
+                      WHERE id = 0"""
+        self.expected_error = "'-8123302036854775807 - 9223372036854775807' causes overflow for type BIGINT"
+
+
+class neg_sub_intt(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_intt AS SELECT
+                      - intt - intt2 AS intt
+                      FROM numeric_tbl
+                      WHERE id = 0"""
+        self.expected_error = (
+            "'-2147483647 - 2147483000' causes overflow for type INTEGER"
+        )
+
+
+class neg_sub_tiny_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_tiny_un_int AS SELECT
+                      tiny_int2 - tiny_int AS tiny_un_int
+                      FROM numeric_un_tbl
+                      WHERE id = 0"""
+        self.expected_error = "'200 - 250' causes overflow for type TINYINT UNSIGNED"
+
+
+class neg_sub_small_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_small_int AS SELECT
+                      small_int - small_int2 AS small_un_int
+                      FROM numeric_un_tbl
+                      WHERE id = 0"""
+        self.expected_error = (
+            "'65430 - 65435' causes overflow for type SMALLINT UNSIGNED"
+        )
+
+
+class neg_sub_big_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_big_un_int AS SELECT
+                      big_int - big_int2 AS big_un_int
+                      FROM numeric_un_tbl
+                      WHERE id = 0"""
+        self.expected_error = "'12446742073709541615 - 18446742073709541615' causes overflow for type BIGINT UNSIGNED"
+
+
+class neg_sub_un_intt(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW sub_un_intt AS SELECT
+                      intt2 - intt AS un_intt
+                      FROM numeric_un_tbl
+                      WHERE id = 0"""
+        self.expected_error = (
+            "'4292966290 - 4294966290' causes overflow for type INTEGER UNSIGNED"
+        )
+
+
+# MOD
+class neg_mod_tiny_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_tiny_int AS SELECT
+                      tiny_int % 0::TINYINT AS tiny_int
+                      FROM numeric_tbl
+                      WHERE id = 1"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_small_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_small_int AS SELECT
+                      small_int % 0::SMALLINT AS small_int
+                      FROM numeric_tbl
+                      WHERE id = 1"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_big_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_big_int AS SELECT
+                      big_int % 0::BIGINT AS big_int
+                      FROM numeric_tbl
+                      WHERE id = 1"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_intt(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_intt AS SELECT
+                      intt % 0::INTEGER AS intt
+                      FROM numeric_tbl
+                      WHERE id = 1"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_tiny_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_tiny_un_int AS SELECT
+                      tiny_int % 0::TINYINT UNSIGNED AS tiny_un_int
+                      FROM numeric_un_tbl"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_small_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_small_un_int AS SELECT
+                      small_int % 0::SMALLINT UNSIGNED AS small_un_int
+                      FROM numeric_un_tbl"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_big_un_int(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_big_un_int AS SELECT
+                      big_int % 0::BIGINT UNSIGNED AS big_un_int
+                      FROM numeric_un_tbl"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
+
+
+class neg_mod_un_intt(TstView):
+    def __init__(self):
+        # checked manually
+        self.sql = """CREATE MATERIALIZED VIEW mod_un_intt AS SELECT
+                      intt % 0::INTEGER UNSIGNED AS un_intt
+                      FROM numeric_un_tbl"""
+        self.expected_error = (
+            "attempt to calculate the remainder with a divisor of zero"
+        )
