Changeset: 6fb265ce0d2a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6fb265ce0d2a Modified Files: sql/test/mergetables/Tests/sqlsmith-exists.sql Branch: default Log Message:
New sqlsmith crash diffs (93 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 @@ -782,4 +782,89 @@ where exists ( is not null) limit 99; --empty on PostgreSQL +select + subq_1.c0 as c0 +from + (select + case when ((false) + or (subq_0.c3 is not null)) + and (true) then subq_0.c11 else subq_0.c11 end + as c0, + case when subq_0.c0 is null then subq_0.c5 else subq_0.c5 end + as c1, + subq_0.c6 as c2, + case when true then subq_0.c3 else subq_0.c3 end + as c3, + subq_0.c3 as c4, + subq_0.c0 as c5, + subq_0.c6 as c6, + subq_0.c3 as c7, + subq_0.c8 as c8, + 42 as c9, + subq_0.c6 as c10 + from + (select + ref_0.col0 as c0, + 85 as c1, + ref_0.col1 as c2, + ref_0.col2 as c3, + ref_0.col1 as c4, + ref_0.col0 as c5, + ref_0.col2 as c6, + ref_0.col0 as c7, + ref_0.col0 as c8, + ref_0.col2 as c9, + ref_0.col1 as c10, + ref_0.col2 as c11 + from + tab1 as ref_0 + where ref_0.col0 is not null + limit 153) as subq_0 + where (exists ( + select + ref_1.col2 as c0, + subq_0.c3 as c1, + subq_0.c10 as c2, + ref_1.col3 as c3 + from + longtable as ref_1 + where false)) + or ((false) + or (subq_0.c10 is null))) as subq_1 +where (subq_1.c9 is not null) + and (exists ( + select + subq_2.c4 as c0 + from + (select + subq_1.c3 as c0, + subq_1.c10 as c1, + ref_3.col0 as c2, + subq_1.c9 as c3, + ref_2.col2 as c4 + from + tab1 as ref_2 + right join tab1 as ref_3 + on ((ref_2.col1 is null) + and (true)) + where ((false) + and (ref_2.col0 is not null)) + or ((ref_3.col1 is not null) + and (false))) as subq_2 + right join longtable as ref_4 + inner join tbl_productsales as ref_5 + right join longtable as ref_6 + on (ref_5.col4 = ref_6.col1 ) + left join tab0 as ref_7 + on (true) + on (ref_7.col0 is null) + on ((subq_2.c4 is null) + or (ref_4.col2 is null)) + where ((true) + and (ref_6.col7 is not null)) + or ((false) + or ((ref_4.col5 is null) + or (ref_7.col1 is null))))) +limit 111; --empty on PostgreSQL + ROLLBACK; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
