Changeset: 435b63ec78d2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/435b63ec78d2 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message:
More queries with wrong results diffs (69 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 @@ -73,10 +73,7 @@ statement ok ROLLBACK statement ok -START TRANSACTION - -statement ok -CREATE TABLE mct20 (c0 INTERVAL DAY,c1 DATE) +CREATE TABLE mct20 (c0 INTERVAL DAY, c1 DATE) query I nosort select 1 from mct20 inner join (select x.x from (values (true)) x(x)) as nort0(norc0) @@ -87,8 +84,52 @@ statement error GDK reported error: BATs 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 +---- + +query I nosort +select sum(((select mct20.c0) union all (select interval '1' day))) over () from mct20 +---- + +query I nosort +select sum(((select interval '2' day) union all (select interval '1' day))) over () from mct20 +---- + +query I nosort +select max(((select mct20.c0) union all (select interval '1' day))) over () from mct20 +---- + +statement ok rowcount 1 +INSERT INTO mct20 VALUES (INTERVAL '1' DAY, DATE '2010-01-01') + +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 +---- + +statement error GDK reported error: mergejoin: more than one match +select sum(((select mct20.c0) union all (select interval '1' day))) over () from mct20 +---- + +statement error GDK reported error: BATsubcross: more than one match +select sum(((select interval '2' day) union all (select interval '1' day))) over () from mct20 +---- + +statement error GDK reported error: mergejoin: more than one match +select max(((select mct20.c0) union all (select interval '1' day))) over () from mct20 +---- + statement ok -ROLLBACK +DROP TABLE mct20 statement ok START TRANSACTION _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
