Changeset: 1ee232c5a54b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1ee232c5a54b
Modified Files:
sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: default
Log Message:
Move test queries outside the transaction, so rt3 table will be empty as well
during the test
diffs (30 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
@@ -373,12 +373,6 @@ with SQLTestCase() as cli:
.assertSucceeded().assertDataResultMatch([(1,)])
cli.execute("SELECT 1 FROM rt3 LEFT OUTER JOIN (SELECT 1) x(x) ON 1 <>
ALL(VALUES (rt3.c0)) where rt3.c0 = 1;") \
.assertSucceeded().assertDataResultMatch([(1,)])
- cli.execute('TRUNCATE t3;') \
- .assertSucceeded().assertRowCount(6)
- cli.execute("SELECT 1 FROM t3 CROSS JOIN LATERAL (SELECT 1 FROM (SELECT 1)
z(z) JOIN (VALUES (1, t3.c0), (2, t3.c0)) x(x,y) ON x.x = 1) y(y);") \
- .assertSucceeded().assertDataResultMatch([])
- cli.execute("SELECT 1 FROM rt3 CROSS JOIN LATERAL (SELECT 1 FROM (SELECT
1) z(z) JOIN (VALUES (1, rt3.c0), (2, rt3.c0)) x(x,y) ON x.x = 1) y(y);") \
- .assertSucceeded().assertDataResultMatch([])
cli.execute("ROLLBACK;")
cli.execute("SELECT CASE 1 WHEN 5 THEN ((SELECT t3.c0) INTERSECT (SELECT
9)) ELSE (VALUES (t3.c0), (1)) END FROM t3;") \
@@ -387,6 +381,13 @@ with SQLTestCase() as cli:
cli.execute("SELECT CASE 1 WHEN 5 THEN ((SELECT rt3.c0) INTERSECT (SELECT
9)) ELSE (VALUES (rt3.c0), (1)) END FROM rt3;") \
.assertFailed() # GDK reported error: hashjoin: more than one match
+ cli.execute('TRUNCATE t3;') \
+ .assertSucceeded().assertRowCount(6)
+ cli.execute("SELECT 1 FROM t3 CROSS JOIN LATERAL (SELECT 1 FROM (SELECT 1)
z(z) JOIN (VALUES (1, t3.c0), (2, t3.c0)) x(x,y) ON x.x = 1) y(y);") \
+ .assertSucceeded().assertDataResultMatch([])
+ cli.execute("SELECT 1 FROM rt3 CROSS JOIN LATERAL (SELECT 1 FROM (SELECT
1) z(z) JOIN (VALUES (1, rt3.c0), (2, rt3.c0)) x(x,y) ON x.x = 1) y(y);") \
+ .assertSucceeded().assertDataResultMatch([])
+
cli.execute("""
START TRANSACTION;
DROP TABLE rt1;
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
