Changeset: 0f8e3df095e0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0f8e3df095e0 Modified Files: sql/test/SQLancer/Tests/sqlancer17.test Branch: Jan2022 Log Message:
More global aggregate cardinality check issues diffs (19 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer17.test b/sql/test/SQLancer/Tests/sqlancer17.test --- a/sql/test/SQLancer/Tests/sqlancer17.test +++ b/sql/test/SQLancer/Tests/sqlancer17.test @@ -665,3 +665,15 @@ least(3, sub0.c1) FROM vx JOIN (SELECT 4 statement ok ROLLBACK + +statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +SELECT vx.vc0 BETWEEN 1 AND min(2) FROM (values (3)) vx(vc0) + +statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +SELECT vx.vc0 BETWEEN min(1) AND 2 FROM (SELECT 3) vx(vc0) + +statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +SELECT 1 BETWEEN vx.vc0 AND min(2) FROM (values (3)) vx(vc0) + +statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +SELECT MIN(1) BETWEEN vx.vc0 AND 2 FROM (SELECT 3) vx(vc0) _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
