Changeset: fbdd46e009bb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fbdd46e009bb Modified Files: sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out sql/test/BugTracker-2010/Tests/between-timestamp.Bug-2718.stable.out sql/test/BugTracker-2010/Tests/cast-varchar.Bug-2682.stable.out sql/test/BugTracker-2010/Tests/concat_type_check_problem.Bug-2354.stable.out sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.out sql/test/BugTracker-2010/Tests/count-and-not.Bug-2663.stable.out sql/test/BugTracker-2010/Tests/crash-with-huge-query.Bug-2647.stable.out sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.stable.out sql/test/BugTracker-2010/Tests/crash_on_where_in.Bug-2333.stable.out sql/test/BugTracker-2010/Tests/decimal-function.BUG-2624.stable.out sql/test/BugTracker-2010/Tests/decimal_div_whole_nrs.Bug-2579.stable.out sql/test/BugTracker-2010/Tests/distinct-order-by-limit.Bug-2691.stable.out sql/test/BugTracker-2010/Tests/function_results_NULL.Bug-2626.stable.out sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.stable.out sql/test/BugTracker-2010/Tests/keycheck_crash.Bug-2583.stable.out sql/test/BugTracker-2010/Tests/not-in-union-except-union.Bug-2577.stable.out sql/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.out sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.stable.out sql/test/BugTracker-2010/Tests/shift_with_cast.Bug-2638.stable.out sql/test/BugTracker-2010/Tests/substring_display_width.Bug-2683.stable.out sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.stable.out sql/test/BugTracker-2010/Tests/update_statement_in_function_ignored.Bug-2614.stable.out sql/test/BugTracker-2010/Tests/values_type_cast.Bug-2735.stable.out sql/test/BugTracker-2010/Tests/with-between.Bug-2732.stable.out sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.stable.out sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.stable.out sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.stable.out sql/test/BugTracker-2011/Tests/aggregate-in-subquery.Bug-2739.stable.out sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.stable.out sql/test/BugTracker-2011/Tests/case-overflow.Bug-2239.stable.out.int128 sql/test/BugTracker-2011/Tests/case-when-alias.Bug-2848.stable.out sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.stable.out sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out sql/test/BugTracker-2011/Tests/crash_in_push_exp_down.Bug-2811.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out sql/test/BugTracker-2011/Tests/div_by_zero.Bug-2887.stable.out sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out sql/test/BugTracker-2011/Tests/extract_seconds.Bug-2793.stable.out sql/test/BugTracker-2011/Tests/jena-optional-1-test.Bug-2915.stable.out sql/test/BugTracker-2011/Tests/many-connects-cache.Bug-2904.stable.out sql/test/BugTracker-2011/Tests/multiple-joins.Bug-2879.stable.out sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out sql/test/BugTracker-2011/Tests/rand-with-seed.Bug-2900.stable.out sql/test/BugTracker-2011/Tests/recursive_case.Bug-2838.stable.out sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.stable.out sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.stable.out sql/test/BugTracker-2011/Tests/supertype.Bug-2830.stable.out sql/test/BugTracker-2011/Tests/time_precision.Bug-2873.stable.out sql/test/BugTracker-2011/Tests/view_avg_incorrect_result.Bug-2790.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.out sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.stable.out sql/test/BugTracker-2012/Tests/any_null.Bug-2594.stable.out sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.stable.out sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.out sql/test/BugTracker-2012/Tests/cast-tinyint-Bug-3137.stable.out sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.stable.out sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.stable.out sql/test/BugTracker-2012/Tests/day-of-month-localization.Bug-2962.stable.out sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/BugTracker-2012/Tests/float-mod.Bug-3086.stable.out sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out.int128 sql/test/BugTracker-2012/Tests/mal_syntax_error.Bug-2949.stable.out sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.stable.out sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.out sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.stable.out sql/test/BugTracker-2012/Tests/order_by_on_column_exp.Bug-3193.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2012/Tests/querycache.Bug-3212.stable.out sql/test/BugTracker-2012/Tests/round-type-inference.Bug-2987.stable.out sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.out sql/test/BugTracker-2012/Tests/server-crash.Bug-3046.stable.out sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.out sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.out sql/test/BugTracker-2012/Tests/sticky-precision.Bug-2969.stable.out sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.stable.out sql/test/BugTracker-2012/Tests/tuples_INTERSECT_vs_count_intersect_differs.Bug-2659.stable.out sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out sql/test/BugTracker-2012/Tests/user_defined_decimal_function.Bug-2992.stable.out sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.stable.out sql/test/BugTracker-2012/Tests/with_in_derived_table.Bug-3043.stable.out Branch: sq2default Log Message:
approved output diffs (truncated from 3246 to 300 lines): diff --git a/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out --- a/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out +++ b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out @@ -70,19 +70,19 @@ project ( | | | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT | | | | | ) [ "t2606a"."a" ] | | | | ) [ "t2606a"."a" ] [ "t2606a"."a" ] -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | group by ( | | | | | project ( | | | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT | | | | | ) [ "t2606b"."a" ] | | | | ) [ "t2606b"."a" ] [ "t2606b"."a" ] -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #select * from t2606a union select * from t2606b order by a; -% .L7 # table_name +% .%7 # table_name % a # name % int # type % 2 # length @@ -109,19 +109,19 @@ project ( | | | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT | | | | | ) [ "t2606a"."a" ] | | | | ) [ "t2606a"."a" ] [ "t2606a"."a" ] -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | group by ( | | | | | project ( | | | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT | | | | | ) [ "t2606b"."a" ] | | | | ) [ "t2606b"."a" ] [ "t2606b"."a" ] -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a union select * from t2606b ) order by a; -% .L7 # table_name +% .%7 # table_name % a # name % int # type % 2 # length @@ -148,19 +148,19 @@ project ( | | | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT | | | | | ) [ "t2606a"."a" ] | | | | ) [ "t2606a"."a" ] [ "t2606a"."a" ] -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | group by ( | | | | | project ( | | | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT | | | | | ) [ "t2606b"."a" ] | | | | ) [ "t2606b"."a" ] [ "t2606b"."a" ] -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a ) union ( select * from t2606b ) order by a; -% .L7 # table_name +% .%7 # table_name % a # name % int # type % 2 # length @@ -183,15 +183,15 @@ project ( | | distinct except ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #select * from t2606a except select * from t2606b order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -208,15 +208,15 @@ project ( | | distinct except ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a except select * from t2606b ) order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -233,15 +233,15 @@ project ( | | distinct except ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a ) except ( select * from t2606b ) order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -258,15 +258,15 @@ project ( | | distinct intersect ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #select * from t2606a intersect select * from t2606b order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -283,15 +283,15 @@ project ( | | distinct intersect ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a intersect select * from t2606b ) order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -308,15 +308,15 @@ project ( | | distinct intersect ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" ] -) [ "L7"."a" ] [ "L7"."a" ASC ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" ] +) [ "%7"."a" ] [ "%7"."a" ASC ] #( select * from t2606a ) intersect ( select * from t2606b ) order by a; -% sys.L7 # table_name +% sys.%7 # table_name % a # name % int # type % 2 # length @@ -337,16 +337,16 @@ project ( | | | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT | | | | | ) [ "t2606a"."a" ] | | | | ) [ "t2606a"."a" ] [ "t2606a"."a" ] -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | group by ( | | | | | project ( | | | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT | | | | | ) [ "t2606b"."a" ] | | | | ) [ "t2606b"."a" ] [ "t2606b"."a" ] -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" as "t"."a" ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" as "t"."a" ] ) [ "t"."a" ] [ "t"."a" ASC ] #select * from (select * from t2606a union select * from t2606b) as t order by a; % .t # table_name @@ -372,12 +372,12 @@ project ( | | distinct except ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" as "t"."a" ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" as "t"."a" ] ) [ "t"."a" ] [ "t"."a" ASC ] #select * from (select * from t2606a except select * from t2606b) as t order by a; % sys.t # table_name @@ -397,12 +397,12 @@ project ( | | distinct intersect ( | | | project ( | | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT -| | | ) [ "t2606a"."a" as "L3"."a" ], +| | | ) [ "t2606a"."a" as "%3"."a" ], | | | project ( | | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT -| | | ) [ "t2606b"."a" as "L4"."a" ] -| | ) [ "L3"."a" as "L7"."a" ] -| ) [ "L7"."a" as "t"."a" ] +| | | ) [ "t2606b"."a" as "%4"."a" ] +| | ) [ "%3"."a" as "%7"."a" ] +| ) [ "%7"."a" as "t"."a" ] ) [ "t"."a" ] [ "t"."a" ASC ] #select * from (select * from t2606a intersect select * from t2606b) as t order by a; % sys.t # table_name diff --git a/sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out b/sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out --- a/sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out +++ b/sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out @@ -33,14 +33,14 @@ stdout of test 'TypeException_with_missi # RETURN (left_shift(nx1 - 1.0,2)); #END; #select f2674(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % double # type % 24 # length [ 0 ] #select f2674(); -% .L2 # table_name -% L2 # name +% .%1 # table_name +% %1 # name % double # type % 24 # length [ 0 ] diff --git a/sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out b/sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out --- a/sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out +++ b/sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out @@ -23,12 +23,12 @@ stdout of test 'and_not_broken.Bug-2602` [ 1 ] #SELECT (1) as "a" FROM tbl1 WHERE id1 = 2; -% .L2 # table_name +% . # table_name % a # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
