Changeset: 558de659db8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/558de659db8e Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
Some more corner error cases (Also important) diffs (22 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 @@ -757,6 +757,18 @@ SELECT y.y FROM (SELECT 1) x(x), (SELECT statement error 42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function SELECT ntile(y.y) over () FROM (SELECT 1) x(x), (SELECT 1) y(y) order by min(x.x) +statement error 42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function +SELECT x.y, EXISTS (SELECT MIN(x.x)) FROM (SELECT 1, 2) x(x,y) + +statement error 42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function +SELECT x.y, (SELECT MIN(x.x)) FROM (SELECT 1, 2) x(x,y) + +statement error 42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function +SELECT (SELECT MIN(x.x)) FROM (SELECT 1, 2) x(x,y) ORDER BY x.y + +statement error 42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function +SELECT x.y, MIN(x.x + x.y) FROM (SELECT 1, 2) x(x,y) + query I nosort SELECT ['1'] "like" [max(x.x), '', false] FROM (SELECT '1') x(x), (SELECT '1') y(y) ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
