Changeset: f9e419d368c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f9e419d368c5 Modified Files: sql/test/mergetables/Tests/sqlsmith-exists.sql sql/test/mergetables/Tests/sqlsmith-exists.stable.out Branch: default Log Message:
Added similar failing query diffs (70 lines): diff --git a/sql/test/mergetables/Tests/sqlsmith-exists.sql b/sql/test/mergetables/Tests/sqlsmith-exists.sql --- a/sql/test/mergetables/Tests/sqlsmith-exists.sql +++ b/sql/test/mergetables/Tests/sqlsmith-exists.sql @@ -211,6 +211,36 @@ FROM (SELECT ref_0.col0 AS c0 WHERE subq_0.c0 IS NOT NULL; --empty on PostgreSQL select + 1 + from + tab1 as ref_0 + right join analytics as ref_1 + on (exists ( + select + 1 + from + tbl_ProductSales as ref_3 + where ref_1.aa is null)) + right join tab2 as ref_2 + on (ref_0.col1 = ref_2.col0 ); +-- 3 rows with 1 + +select + 1 + from + tab1 as ref_0 + right join analytics as ref_1 + right join tab2 as ref_2 + on (exists ( + select + 1 + from + tbl_ProductSales as ref_3 + where ref_1.aa is null)) + on (ref_0.col1 = ref_2.col0 ); +-- 6 rows with 1 + +select subq_0.c0 as c0, subq_0.c0 as c1, cast(coalesce(4, diff --git a/sql/test/mergetables/Tests/sqlsmith-exists.stable.out b/sql/test/mergetables/Tests/sqlsmith-exists.stable.out --- a/sql/test/mergetables/Tests/sqlsmith-exists.stable.out +++ b/sql/test/mergetables/Tests/sqlsmith-exists.stable.out @@ -128,6 +128,26 @@ stdout of test 'sqlsmith-exists` in dire % int, int, int, int, int, int # type % 1, 1, 1, 1, 1, 1 # length #select +# 1 +# from +# tab1 as ref_0 +# right join analytics as ref_1 +# on (exists ( +# select +# 1 +# from +# tbl_ProductSales as ref_3 +# where ref_1.aa is null)) +# right join tab2 as ref_2 +# on (ref_0.col1 = ref_2.col0 ); +% . # table_name +% single_value # name +% tinyint # type +% 1 # length +[ 1 ] +[ 1 ] +[ 1 ] +#select # subq_0.c0 as c0, # subq_0.c0 as c1, # cast(coalesce(4, _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
