Changeset: f382b251586c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f382b251586c Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
Two more missing cases. Enough for now diffs (16 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 @@ -751,6 +751,12 @@ SELECT case x.x when 2 then min(y.y) end statement error 42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function SELECT case 1 when 2 then x.x when max(y.y) then 3 end FROM (SELECT 1) x(x), (SELECT 1) y(y) +statement error 42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function +SELECT y.y FROM (SELECT 1) x(x), (SELECT 1) y(y) order by min(x.x) + +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) + 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
