Changeset: d6ce5a232021 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d6ce5a232021 Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Tricky one. The cardinality shouln't increase diffs (26 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 @@ -106,6 +106,22 @@ SELECT 1 FROM (SELECT DISTINCT 1) y(y) W statement ok ROLLBACK +query I nosort +SELECT x.x FROM (SELECT DISTINCT 1) x(x) WHERE EXISTS (VALUES (41), (x.x)) +---- +1 + +# these are right +query I nosort +SELECT x.x FROM (SELECT 1) x(x) WHERE EXISTS (VALUES (41), (x.x)) +---- +1 + +query I nosort +SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(EXISTS (VALUES (41), (x.x)) AS INT) as count FROM (SELECT DISTINCT 1) x(x)) as res +---- +1 + statement error 21000!Cardinality violation, scalar value expected SELECT 1 FROM (SELECT DISTINCT 3) vx(vx) WHERE 1 <> (VALUES (2), (vx.vx)) _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
