Changeset: 8216a72ad981 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8216a72ad981 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message:
Fix test by adding rows to table diffs (44 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 @@ -80,18 +80,6 @@ select 1 from mct20 inner join (select x on true and greatest(((select nort0.norc0) intersect (select true)), true) ---- -statement error GDK reported error: BATsubcross: more than one match -select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) -on true and greatest(((select nort0.norc0) union all (select true)), true) - -statement error GDK reported error: BATsubcross: more than one match -select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) -on ((select nort0.norc0) union all (select true)) - -statement error GDK reported error: BATsubcross: more than one match -select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) -on true where ((select nort0.norc0) union all (select true)) - # these are right query I nosort select rank() over (order by ((select mct20.c0) union all (select interval '1' day))) from mct20 @@ -112,6 +100,21 @@ select max(((select mct20.c0) union all statement ok rowcount 1 INSERT INTO mct20 VALUES (INTERVAL '1' DAY, DATE '2010-01-01') +statement error GDK reported error: BATsubcross: more than one match +select 1 from mct20 where ((select true) union all (select true)) + +statement error GDK reported error: mergejoin: more than one match +select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) +on true and greatest(((select nort0.norc0) union all (select true)), true) + +statement error GDK reported error: mergejoin: more than one match +select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) +on ((select nort0.norc0) union all (select true)) + +statement error GDK reported error: mergejoin: more than one match +select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) +on true where ((select nort0.norc0) union all (select true)) + statement error GDK reported error: mergejoin: more than one match select rank() over (order by ((select mct20.c0) union all (select interval '1' day))) from mct20 ---- _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
