Changeset: e3939ab7cbc5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e3939ab7cbc5
Modified Files:
sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: default
Log Message:
The concurrency issue with the query queue is still there
diffs (24 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
@@ -348,7 +348,6 @@ with SQLTestCase() as cli:
UNION ALL (SELECT 1 FROM t3 RIGHT OUTER JOIN (SELECT 4) AS
sub1n0(subc1n0) ON TRUE
CROSS JOIN (SELECT FALSE FROM t3) AS sub1n1(subc1n0))) FROM t3;
""").assertSucceeded().assertDataResultMatch([(True,),(True,),(True,),(True,),(True,),(True,)])
- # this query triggers a lot MAL user function calls at the moment. It
allows to test concurrency issues with the query queue
cli.execute("""
SELECT 5 <> ALL((SELECT 2 FROM rt3 FULL OUTER JOIN (SELECT 1) AS
sub1n0(subc1n0) ON 2 < ANY(SELECT 1))
UNION ALL (SELECT 1 FROM rt3 RIGHT OUTER JOIN (SELECT 4) AS
sub1n0(subc1n0) ON TRUE
@@ -356,6 +355,12 @@ with SQLTestCase() as cli:
""").assertSucceeded().assertDataResultMatch([(True,),(True,),(True,),(True,),(True,),(True,)])
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;") \
+ .assertFailed() # GDK reported error: hashjoin: more than one match
+ # this query triggers a lot MAL user function calls at the moment. It
allows to test concurrency issues with the query queue
+ 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("""
START TRANSACTION;
DROP TABLE rt1;
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
