Changeset: 3fc0e1da4339 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3fc0e1da4339 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
Semijoin rewrite issue at rel_setjoins_2_joingroupby diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQLancer/Tests/sqlancer22.test --- a/sql/test/SQLancer/Tests/sqlancer22.test +++ b/sql/test/SQLancer/Tests/sqlancer22.test @@ -709,6 +709,12 @@ query I nosort SELECT 1 FROM t0 CROSS JOIN LATERAL (SELECT 1 FROM (SELECT t0.c0 FROM t0) y(y) CROSS JOIN LATERAL (SELECT 5) x(x)) z(z) ---- +query I nosort +SELECT EXISTS (SELECT 1 FROM (SELECT DISTINCT 1) y(y) WHERE x.x = ANY(VALUES (y.y))) FROM rt2 CROSS JOIN (SELECT 3) x(x) +---- +0 +0 + statement ok ROLLBACK _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
