Changeset: e430e0ca7c26 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e430e0ca7c26 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message:
Push up group by under semijoin issue. Enough bugs for now diffs (13 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 @@ -270,5 +270,9 @@ query I nosort SELECT 1 FROM vx WHERE vx.vc1 <> ALL(SELECT vx.vc1 FROM t0) AND (SELECT FALSE FROM t0) ---- +query I nosort +SELECT 1 FROM (SELECT DISTINCT c0 FROM rt0) vt(vc1) WHERE (1) IN (SELECT 2 FROM rt0 GROUP BY rt0.c0, vt.vc1) +---- + statement ok ROLLBACK _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
