Changeset: d10c9e35a11c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d10c9e35a11c Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Next crash, missing error message diffs (27 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLancer/Tests/sqlancer23.test --- a/sql/test/SQLancer/Tests/sqlancer23.test +++ b/sql/test/SQLancer/Tests/sqlancer23.test @@ -133,7 +133,6 @@ SELECT 1 FROM (SELECT TRUE) v0(c0) WHERE ---- 1 -# this one is right query I nosort SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(NOT EXISTS (SELECT v0.c0 FROM (SELECT 1 WHERE FALSE) x(x)) = TRUE AS INT) as count FROM (SELECT TRUE) v0(c0)) as res @@ -202,3 +201,15 @@ SELECT 1 FROM (SELECT 1) x(x) JOIN (SELE statement error 42000!SELECT: aggregate functions not allowed in JOIN conditions SELECT 1 FROM (SELECT 1) x(x) JOIN (SELECT 1) y(y) ON (SELECT 1 WHERE EXISTS (SELECT max(x.x))) + +statement error 42000!MIN: aggregate functions cannot be nested +SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min((SELECT 1 HAVING min(x.x + y.y) > 0))) FROM (SELECT 1) y(y) + +statement error 42000!MIN: aggregate functions cannot be nested +SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min((SELECT min(x.x + y.y)))) FROM (SELECT 1) y(y) + +statement error 42000!MIN: aggregate functions cannot be nested +SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min(min(x.x + y.y))) FROM (SELECT 1) y(y) + +statement error 42000!MIN: aggregate functions cannot be nested +SELECT (SELECT min(min(x.x + y.y)) FROM (SELECT 1) x(x)) FROM (SELECT 1) y(y) _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org