Changeset: bc00d1fe3349 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bc00d1fe3349 Modified Files: sql/test/mergetables/Tests/sqlsmith-exists2.stable.out Branch: default Log Message:
Approved output diffs (59 lines): diff --git a/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out --- a/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out +++ b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out @@ -114,6 +114,55 @@ stdout of test 'sqlsmith-exists2` in dir % c0, c1, c2, c3, c4 # name % int, tinyint, int, int, real # type % 1, 1, 1, 1, 15 # length +#select +# subq_0.c4 as c0, +# subq_0.c8 as c1, +# subq_0.c2 as c2, +# 1 as c3, +# subq_0.c0 as c4, +# subq_0.c9 as c5, +# subq_0.c9 as c6, +# subq_0.c6 as c7 +#from +# (select +# ref_4.i as c0, +# case when (false) +# or (ref_7.col3 is not null) then ref_2.col2 else ref_2.col2 end +# as c1, +# ref_7.col6 as c2, +# ref_7.col1 as c3, +# ref_4.i as c4, +# ref_2.col0 as c5, +# ref_3.col3 as c6, +# ref_0.col1 as c7, +# ref_2.col2 as c8, +# ref_3.col2 as c9, +# ref_7.col1 as c10, +# ref_1.aa as c11, +# ref_2.col1 as c12, +# ref_1.cc as c13, +% sys., sys., sys., ., sys., sys., sys., sys. # table_name +% c0, c1, c2, c3, c4, c5, c6, c7 # name +% int, int, date, tinyint, int, int, int, int # type +% 1, 1, 10, 1, 1, 1, 1, 1 # length +#select +# 1 +# from +# tab0 +# inner join analytics as ref_1 +# inner join integers as ref_4 +# on (exists ( +# select +# 1 +# where (exists ( +# select +# 1) +# and (ref_4.i is not null)))) +# on (ref_1.bb is null); +% . # table_name +% single_value # name +% tinyint # type +% 1 # length #ROLLBACK; # 22:12:15 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list