Changeset: b17bf8709e38 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b17bf8709e38
Modified Files:
sql/test/SQLancer/Tests/sqlancer20.SQL.py
Branch: Jan2022
Log Message:
Attempting to truncate a global temp table on a new connection is giving a
crash. Looking into it
diffs (18 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
@@ -45,3 +45,14 @@ with SQLTestCase() as cli:
DROP TABLE mct21;
DROP TABLE mt2;
COMMIT;""").assertSucceeded()
+
+# testing temporary tables
+with SQLTestCase() as mdb1:
+ mdb1.connect(username="monetdb", password="monetdb")
+ mdb1.execute("CREATE GLOBAL TEMPORARY TABLE tt2(c0 JSON, c1 DATE) ON
COMMIT PRESERVE ROWS;").assertSucceeded()
+ mdb1.execute("INSERT INTO tmp.tt2(c1, c0) VALUES(DATE '2010-10-10', JSON
'true');").assertSucceeded()
+
+with SQLTestCase() as mdb2:
+ mdb2.connect(username="monetdb", password="monetdb")
+ mdb2.execute("TRUNCATE TABLE tmp.tt2;").assertSucceeded()
+ mdb2.execute("DROP TABLE tmp.tt2;").assertSucceeded()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
