MonetDB: groupjoin - simplify output (hugeint->bigint)

[Niels Nes via checkin-list]

Changeset: e460d2349c8e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e460d2349c8e
Added Files:
        testing/plan.py
Modified Files:
        sql/test/rel-optimizers/Tests/split-select.test
        testing/CMakeLists.txt
Branch: groupjoin
Log Message:

simplify output (hugeint->bigint)


diffs (53 lines):

diff --git a/sql/test/rel-optimizers/Tests/split-select.test 
b/sql/test/rel-optimizers/Tests/split-select.test
--- a/sql/test/rel-optimizers/Tests/split-select.test
+++ b/sql/test/rel-optimizers/Tests/split-select.test
@@ -5,14 +5,14 @@ statement ok
 insert into integers values(1),(2),(3),(NULL)
 
 # split case into project under select
-query T nosort
+query T python .plan.filter
 plan select i from integers where case i when i*i then i else i end > 1
 ----
 project (
 | select (
 | | project (
 | | | table("sys"."integers") [ "integers"."i" ]
-| | ) [ "integers"."i", "sys"."casewhen"(hugeint(64)["integers"."i"], 
"sys"."sql_mul"("integers"."i", "integers"."i"), "integers"."i", 
"integers"."i") as "%1"."%1" ]
+| | ) [ "integers"."i", "sys"."casewhen"(bigint(63)["integers"."i"], 
"sys"."sql_mul"("integers"."i", "integers"."i"), "integers"."i", 
"integers"."i") as "%1"."%1" ]
 | ) [ ("%1"."%1") > (int(32) "1") ]
 ) [ "integers"."i" ]
 
diff --git a/testing/CMakeLists.txt b/testing/CMakeLists.txt
--- a/testing/CMakeLists.txt
+++ b/testing/CMakeLists.txt
@@ -139,6 +139,7 @@ if(PYTHON3_LIBDIR)
     melcheck.py
     sqllogictest.py
     explain.py
+    plan.py
     mapicursor.py
     malmapi.py
     helpers.py
diff --git a/testing/plan.py b/testing/plan.py
new file mode 100644
--- /dev/null
+++ b/testing/plan.py
@@ -0,0 +1,17 @@
+# SPDX-License-Identifier: MPL-2.0
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0.  If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+# Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
+
+import re
+
+def filter(tab):
+    res = []
+    for row in tab:
+        if row[0].find('usec') < 0:
+            s = re.sub(r'hugeint\(64\)', r'bigint(63)', row[0])
+            res.append([s])
+    return res
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org