Changeset: 98620b56c7c3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/98620b56c7c3 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
More missing cardinality checks diffs (35 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 @@ -709,6 +709,31 @@ SELECT y.y BETWEEN 1 AND max(x.x) FROM ( statement error 42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function SELECT y.y BETWEEN max(x.x) AND 1 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 1 BETWEEN y.y AND max(x.x) 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 LIKE max(x.x) FROM (SELECT '1') x(x), (SELECT '1') y(y) + +statement error 42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function +SELECT max(y.y) LIKE x.x 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] "like" [max(x.x), '', false] FROM (SELECT '1') x(x), (SELECT '1') y(y) + +statement error 42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function +SELECT [max(y.y)] "like" [x.x, '', false] FROM (SELECT '1') x(x), (SELECT '1') y(y) + +query I nosort +SELECT ['1'] "like" [max(x.x), '', false] FROM (SELECT '1') x(x), (SELECT '1') y(y) +---- +1 + +query I nosort +SELECT [max(y.y)] "like" ['1', '', false] FROM (SELECT '1') x(x), (SELECT '1') y(y) +---- +1 + statement error Subquery has too many columns select 1 where (2,3) in (select x,y,2 from (values (2, 3), (4, 5)) x(x,y)) _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
