Changeset: 6f63bd231339 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6f63bd231339
Modified Files:
sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: default
Log Message:
There are still issues with MAL dataflow and query queue
diffs (18 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
@@ -353,6 +353,14 @@ with SQLTestCase() as cli:
UNION ALL (SELECT 1 FROM rt3 RIGHT OUTER JOIN (SELECT 4) AS
sub1n0(subc1n0) ON TRUE
CROSS JOIN (SELECT FALSE FROM rt3) AS sub1n1(subc1n0))) FROM rt3;
""").assertSucceeded().assertDataResultMatch([(True,),(True,),(True,),(True,),(True,),(True,)])
+ cli.execute("""
+ select (values (t3.c0)) from t3, (select 2 from t3 where
+ ((select t3.c0) intersect (select 3)) > 0) vx(vc0) where (values
(t3.c0)) > 0;
+ """).assertSucceeded().assertDataResultMatch([])
+ cli.execute("""
+ select (values (rt3.c0)) from rt3, (select 2 from rt3 where
+ ((select rt3.c0) intersect (select 3)) > 0) vx(vc0) where (values
(rt3.c0)) > 0;
+ """).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;") \
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
