Changeset: 85c3e3857797 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/85c3e3857797 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message:
Correlated grouping on any subquery crashing. Looking into it diffs (30 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 @@ -29,3 +29,26 @@ 1 statement ok ROLLBACK + +statement ok +START TRANSACTION + +statement ok +CREATE TABLE t0 (c0 INT) + +statement ok +INSERT INTO t0 VALUES (1) + +statement ok +CREATE TABLE t1 (c0 INT) + +statement ok +INSERT INTO t1 VALUES (1) + +query I nosort +SELECT 1 = ANY(SELECT 1 FROM t1 JOIN (SELECT count(*) GROUP BY t0.c0) AS x(x) ON TRUE) FROM t0 +---- +1 + +statement ok +ROLLBACK _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
