Changeset: 01e36114c9d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/01e36114c9d1 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
More missing cardinality checks diffs (28 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 @@ -691,6 +691,11 @@ SELECT 1 FROM t0 LEFT JOIN (SELECT 2) AS ---- query I nosort +SELECT min((SELECT t0.c0 + t0.c0)) FROM t0 +---- +NULL + +query I nosort SELECT min((SELECT CASE t0.c0 WHEN t0.c0 THEN t0.c0 END)) FROM t0 ---- NULL @@ -698,6 +703,12 @@ NULL statement ok ROLLBACK +statement error 42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function +SELECT y.y BETWEEN 1 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 BETWEEN max(x.x) AND 1 FROM (SELECT 1) x(x), (SELECT 1) y(y) + 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
