Changeset: 1d0a3989d894 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1d0a3989d894 Modified Files: sql/test/mergetables/Tests/sqlsmith-exists2.sql Branch: Jun2020 Log Message:
New sqlsmith crash diffs (55 lines): diff --git a/sql/test/mergetables/Tests/sqlsmith-exists2.sql b/sql/test/mergetables/Tests/sqlsmith-exists2.sql --- a/sql/test/mergetables/Tests/sqlsmith-exists2.sql +++ b/sql/test/mergetables/Tests/sqlsmith-exists2.sql @@ -559,4 +559,51 @@ SELECT 1 FROM myitem WHERE i_current_pri SELECT 1 FROM tab0 WHERE col0 BETWEEN 64 AND 64 + 10 AND col0 BETWEEN 64 + 1 AND 64 + 15; +select + subq_0.c6 as c0, + subq_0.c5 as c1, + 38 as c2 from + (select + case when ref_0.i is not null then ref_0.i else ref_0.i end + as c0, + ref_0.i as c1, + ref_0.i as c2, + ref_0.i as c3, + ref_0.i as c4, + ref_0.i as c5, + ref_0.i as c6, + ref_0.i as c7, + ref_0.i as c8, + case when ref_0.i is not null then ref_0.i else ref_0.i end + as c9 + from + integers as ref_0 + where (exists ( + select + ref_1.col4 as c0, + 28 as c1, + ref_1.col2 as c2, + ref_1.col3 as c3, + 71 as c4 + from + tbl_productsales as ref_1 + where false)) + or ((ref_0.i is null) + or ((ref_0.i is not null) + or (exists ( + select + ref_2.col1 as c0 + from + tbl_productsales as ref_2 + where (((false) + and (true)) + and ((ref_2.col3 is null) + and ((false) + and (true)))) + and (ref_0.i is not null))))) + limit 77) as subq_0 where case when (subq_0.c5 is null) + or (subq_0.c9 is not null) then subq_0.c2 else subq_0.c2 end + is null limit 71; + -- NULL NULL 38 + ROLLBACK; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
