Changeset: 36bcf558ad4c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36bcf558ad4c Modified Files: sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/BugTracker-2013/Tests/bogus_aggregation_casts.Bug-3342.stable.out sql/test/BugTracker-2013/Tests/case-orderby.Bug-3388.stable.out sql/test/BugTracker-2013/Tests/case_when.Bug-3395.stable.out sql/test/BugTracker-2013/Tests/correlated_select.Bug-3250.stable.out sql/test/BugTracker-2013/Tests/correlated_subquery.Bug-3317.stable.out sql/test/BugTracker-2013/Tests/decimal-cast.Bug-3310.stable.out sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.out sql/test/BugTracker-2013/Tests/groupby_on_value_view.Bug-3264.stable.out sql/test/BugTracker-2013/Tests/hashed_exp.Bug-3313.stable.out sql/test/BugTracker-2013/Tests/iso8601_weekofyear.Bug-3232.stable.out sql/test/BugTracker-2013/Tests/median-null.Bug-3280.stable.out sql/test/BugTracker-2013/Tests/median.Bug-3352.stable.out sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.stable.out sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out sql/test/BugTracker-2013/Tests/nestedcalls.stable.out sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.out sql/test/BugTracker-2013/Tests/pivot.Bug-3339.stable.out sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out sql/test/BugTracker-2013/Tests/recursion.stable.out sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.stable.out sql/test/BugTracker-2013/Tests/singleton-median.Bug-3389.stable.out sql/test/BugTracker-2013/Tests/sort_void_crash.Bug-3341.stable.out sql/test/BugTracker-2013/Tests/stddev-group.Bug-3257.stable.out sql/test/BugTracker-2013/Tests/subtract-one-year.Bug-3215.stable.out sql/test/BugTracker-2013/Tests/syntaxerror.Bug-3399.stable.out sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.stable.out sql/test/BugTracker-2013/Tests/unop_vs_aggr.Bug-3885.stable.out sql/test/BugTracker-2014/Tests/BOM-in-string.Bug-3641.stable.out sql/test/BugTracker-2014/Tests/aggr-with-limit.Bug-3498.stable.out sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out sql/test/BugTracker-2014/Tests/bug_in_cse.Bug-3511.stable.out sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out sql/test/BugTracker-2014/Tests/column-with-comma.Bug-3616.stable.out sql/test/BugTracker-2014/Tests/crash_on_groupby_distinct_serial.Bug-3463.stable.out sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.out sql/test/BugTracker-2014/Tests/div_by_zero_in_return.Bug-3555.stable.out sql/test/BugTracker-2014/Tests/empty_intermediate_quantile.Bug-3611.stable.out sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out sql/test/BugTracker-2014/Tests/groupby_distict.Bug-3423.stable.out sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out.int128 sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3629.stable.out sql/test/BugTracker-2014/Tests/incorrect_floating_point_cast.Bug-3633.stable.out sql/test/BugTracker-2014/Tests/indices.Bug-3435.stable.out sql/test/BugTracker-2014/Tests/locate-offset.Bug-3563.stable.out sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2014/Tests/missing_alias.Bug-3626.stable.out sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out sql/test/BugTracker-2014/Tests/orderby_count.Bug-3526.stable.out sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out sql/test/BugTracker-2014/Tests/outer_join_using_diff_types_using.Bug-3536.stable.out sql/test/BugTracker-2014/Tests/queueError.Bug-3604.stable.out sql/test/BugTracker-2014/Tests/round-properties.Bug-3515.stable.out sql/test/BugTracker-2014/Tests/round-sorted.Bug-3562.stable.out sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128 sql/test/BugTracker-2014/Tests/select-having.Bug-3458.stable.out sql/test/BugTracker-2014/Tests/select_in_crash.Bug-3491.stable.out sql/test/BugTracker-2014/Tests/sign-sorted.Bug-3594.stable.out sql/test/BugTracker-2014/Tests/stddev-empty.Bug-3628.stable.out sql/test/BugTracker-2014/Tests/two-column-aggr-with-null.Bug-3428.stable.out sql/test/BugTracker-2014/Tests/type_resolution.Bug-3622.stable.out sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out sql/test/BugTracker-2014/Tests/unsafe_project_push_down.Bug-3523.stable.out Branch: sq2default Log Message:
approved output diffs (truncated from 3426 to 300 lines): diff --git a/sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out b/sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out --- a/sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out +++ b/sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out @@ -63,8 +63,8 @@ stdout of test 'Cannot_Find_Column_Type. # return true; #end; #select tmp1(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % boolean # type % 5 # length [ true ] @@ -78,8 +78,8 @@ stdout of test 'Cannot_Find_Column_Type. # return true; #end; #select tmp2(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % boolean # type % 5 # length [ true ] @@ -93,8 +93,8 @@ stdout of test 'Cannot_Find_Column_Type. # return true; #end; #select tmp3(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % boolean # type % 5 # length [ true ] @@ -108,8 +108,8 @@ stdout of test 'Cannot_Find_Column_Type. # return true; #end; #select tmp4(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % boolean # type % 5 # length [ true ] diff --git a/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out b/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out --- a/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out +++ b/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out @@ -77,32 +77,32 @@ stdout of test 'aggregates-typing-issues [ 6, 0 ] [ 8, 0 ] #select median( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % bigint # type % 1 # length [ 3 ] #select cast (prod( prob1 ) as bigint) from mtcars2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 1 # length [ 0 ] #select stddev_pop( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.337497399 ] #select stddev_samp( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.656045222 ] #select sign( prob1 ) from mtcars2; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] @@ -125,32 +125,32 @@ stdout of test 'aggregates-typing-issues [ 6, 0 ] [ 8, 0 ] #select median( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 3 ] #select cast (prod( prob1 ) as bigint) from mtcars2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 1 # length [ 0 ] #select stddev_pop( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.337497399 ] #select stddev_samp( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.656045222 ] #select sign( prob1 ) from mtcars2; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] @@ -173,32 +173,32 @@ stdout of test 'aggregates-typing-issues [ 6, 0 ] [ 8, 0 ] #select median( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % smallint # type % 1 # length [ 3 ] #select cast (prod( prob1 ) as bigint) from mtcars2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 1 # length [ 0 ] #select stddev_pop( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.337497399 ] #select stddev_samp( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.656045222 ] #select sign( prob1 ) from mtcars2; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] @@ -221,32 +221,32 @@ stdout of test 'aggregates-typing-issues [ 6, 0 ] [ 8, 0 ] #select median( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % int # type % 1 # length [ 3 ] #select cast (prod( prob1 ) as bigint) from mtcars2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 1 # length [ 0 ] #select stddev_pop( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.337497399 ] #select stddev_samp( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.656045222 ] #select sign( prob1 ) from mtcars2; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] @@ -269,32 +269,32 @@ stdout of test 'aggregates-typing-issues [ 6, 0 ] [ 8, 0 ] #select median( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % bigint # type % 1 # length [ 3 ] #select cast (prod( prob1 ) as bigint) from mtcars2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 1 # length [ 0 ] #select stddev_pop( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.337497399 ] #select stddev_samp( prob1 ) from mtcars2; -% sys.L3 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % double # type % 24 # length [ 3.656045222 ] #select sign( prob1 ) from mtcars2; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] diff --git a/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out b/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out --- a/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out +++ b/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out @@ -29,15 +29,15 @@ stdout of test 'alter_resets_readonly.Bu [ 3 ] #alter table x set read only; #select (access = 1) from sys.tables where name='x'; -% .L40 # table_name -% L40 # name +% .%10 # table_name +% %10 # name % boolean # type % 5 # length [ true ] #alter table x add primary key (a); #select (access = 1) from sys.tables where name='x'; -% .L40 # table_name -% L40 # name +% .%10 # table_name +% %10 # name % boolean # type % 5 # length [ true ] diff --git a/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out b/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out --- a/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out +++ b/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out @@ -42,7 +42,7 @@ stdout of test 'between.Bug-3259` in dir #SELECT t1.subject as id1, t2.subject as id2 #FROM treeitems t1, treeitems t2 #WHERE t2.pre between t1.pre and t1.pre + t1.size; -% sys.L2, sys.L4 # table_name +% sys.t1, sys.t2 # table_name % id1, id2 # name % int, int # type % 1, 1 # length _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
