Changeset: f37a7a2b911d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f37a7a2b911d Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message:
Queries with wrong results diffs (23 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 @@ -623,6 +623,19 @@ select 1 where (2,3) in ((values (2, 3), ---- 1 +query I nosort +SELECT 1 FROM (values (1, 4), (3, (select 2))) x(x,y) WHERE greatest(FALSE, FALSE) +---- + +query I nosort +SELECT 1 FROM (values (1, 4), (3, (select 2 where true))) x(x,y) WHERE greatest(FALSE, FALSE) +---- + +# this one is right +query I nosort +SELECT 1 FROM (values (1, 4), (3, 2)) x(x,y) WHERE greatest(FALSE, FALSE) +---- + statement ok ROLLBACK _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
