Changeset: 0d0ff8b09e8f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0d0ff8b09e8f
Modified Files:
sql/test/SQLancer/Tests/sqlancer20.SQL.py
Branch: Jan2022
Log Message:
Backported test change from default to Jan2020 (needs to cleanup)
diffs (37 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
@@ -66,6 +66,33 @@ with SQLTestCase() as cli:
DROP TABLE rt0;
COMMIT;""").assertSucceeded()
+ cli.execute("""
+ START TRANSACTION;
+ CREATE TABLE t0(c0 INT);
+ INSERT INTO t0 VALUES (1),(2),(3);
+ CREATE MERGE TABLE mt2 (c0 INT);
+ CREATE TABLE mct20 (c0 INT);
+ CREATE TABLE rmct21 (c0 INT);
+ CREATE REMOTE TABLE rrmct21 (c0 INT) ON
'mapi:monetdb://localhost:%s/%s/sys/rmct21';
+ ALTER TABLE mt2 ADD TABLE mct20;
+ ALTER TABLE mt2 ADD TABLE rrmct21;
+ COMMIT;""" % (port, db)).assertSucceeded()
+
+ cli.execute("""SELECT 1 FROM (SELECT 1 FROM t0, mt2) vx(vc0) LEFT OUTER
JOIN
+ (SELECT 2 FROM t0) AS sub0(c0) ON CASE 5 WHEN 2 THEN sub0.c0 <>
ALL(VALUES (3), (4)) END;""") \
+ .assertSucceeded().assertDataResultMatch([])
+
+ cli.execute("""
+ START TRANSACTION;
+ DROP TABLE t0;
+ ALTER TABLE mt2 DROP TABLE rrmct21;
+ ALTER TABLE mt2 DROP TABLE mct20;
+ DROP TABLE mt2;
+ DROP TABLE mct20;
+ DROP TABLE rmct21;
+ DROP TABLE rrmct21;
+ COMMIT;""").assertSucceeded()
+
# testing temporary tables
with SQLTestCase() as mdb1:
mdb1.connect(username="monetdb", password="monetdb")
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
