Changeset: 0768335463bb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0768335463bb Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message:
Queries giving wrong result and crash on default. Attribute join related diffs (19 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 @@ -252,4 +252,15 @@ SELECT 1 FROM t0 WHERE 5 <= ALL(SELECT 2 ---- statement ok +create or replace view vx(vc0, vc1) as (select 10, 2) + +query I nosort +SELECT vx.vc1 <> ALL(SELECT x.x) FROM vx JOIN (SELECT 1) AS x(x) ON vx.vc1 <> ALL(SELECT vx.vc1 FROM t0) AND (SELECT FALSE FROM t0) +---- + +query I nosort +SELECT vx.vc1 <> ALL(SELECT x.x FROM t0) FROM vx JOIN (SELECT 1) AS x(x) ON vx.vc1 <> ALL(SELECT vx.vc1 FROM t0) AND (SELECT FALSE FROM t0) +---- + +statement ok ROLLBACK _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
