Changeset: 63a3d8dfb01a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/63a3d8dfb01a
Added Files:
sql/test/dict/Tests/dict02.SQL.py
Modified Files:
sql/test/dict/Tests/All
Branch: Jan2022
Log Message:
optict optimizer issue on function's return value. Enough issues for now
diffs (42 lines):
diff --git a/sql/test/dict/Tests/All b/sql/test/dict/Tests/All
--- a/sql/test/dict/Tests/All
+++ b/sql/test/dict/Tests/All
@@ -1,1 +1,2 @@
dict01
+dict02
diff --git a/sql/test/dict/Tests/dict02.SQL.py
b/sql/test/dict/Tests/dict02.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/dict/Tests/dict02.SQL.py
@@ -0,0 +1,31 @@
+import os
+
+from MonetDBtesting.sqltest import SQLTestCase
+
+port = os.environ['MAPIPORT']
+db = os.environ['TSTDB']
+
+with SQLTestCase() as cli:
+ cli.connect(username="monetdb", password="monetdb")
+ cli.execute("""
+ START TRANSACTION;
+ CREATE TABLE "mct00" ("c0" TINYINT,"c1" BOOLEAN);
+ INSERT INTO "mct00" VALUES (4, true), (NULL, false);
+ create procedure "sys"."dict_compress"(sname string, tname string, cname
string, ordered_values bool) external name "dict"."compress";
+ COMMIT;
+
+ CALL "sys"."dict_compress"('sys','mct00','c1',true);
+ CREATE REMOTE TABLE "rmct00" ("c0" TINYINT,"c1" BOOLEAN) ON
'mapi:monetdb://localhost:%s/%s/sys/mct00';
+ """ % (port, db)).assertSucceeded()
+
+ cli.execute('SELECT mct00.c1 FROM mct00;') \
+ .assertSucceeded().assertDataResultMatch([(True,),(False,)])
+ cli.execute('SELECT rmct00.c1 FROM rmct00') \
+ .assertSucceeded().assertDataResultMatch([(True,),(False,)])
+
+ cli.execute("""
+ START TRANSACTION;
+ DROP TABLE rmct00;
+ DROP TABLE mct00;
+ DROP PROCEDURE "sys"."dict_compress";
+ COMMIT;""").assertSucceeded()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
