Changeset: 803c0bc6e70c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/803c0bc6e70c Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Query with wrong result diffs (22 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 @@ -19,4 +19,18 @@ ON (SELECT y.y WHERE x.x) ---- statement ok +create view vx(vx) as (select distinct 2) + +query I nosort +SELECT 1 FROM vx WHERE 1 <> ALL(VALUES (10), (vx.vx)) +---- +1 + +# this one is right +query I nosort +SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(1 <> ALL(VALUES (10), (vx.vx)) AS INT) as count FROM vx) as res +---- +1 + +statement ok ROLLBACK _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
