Changeset: 125bb74b3322 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=125bb74b3322 Removed Files: monetdb5/mal/Tests/tst911.stable.out monetdb5/modules/mal/Tests/inspect05.stable.out monetdb5/modules/mal/Tests/inspect05.stable.out.int128 monetdb5/optimizer/Tests/CXexample.stable.out monetdb5/optimizer/Tests/dataflow.stable.out monetdb5/optimizer/Tests/inline08.stable.out monetdb5/optimizer/Tests/tst4000.stable.out monetdb5/optimizer/Tests/tst4003.stable.out sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out sql/benchmarks/nobench/Tests/nobench.stable.err sql/benchmarks/nobench/Tests/nobench.stable.out sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.sql sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.err 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.sql sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.err sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.stable.err sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.stable.out sql/test/BugTracker-2012/Tests/any_null.Bug-2594.stable.err sql/test/BugTracker-2012/Tests/any_null.Bug-2594.stable.out sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.sql sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.stable.err sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.stable.out sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.stable.err sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.stable.out sql/test/BugTracker-2012/Tests/bug_large-insert-Bug.2960.stable.err sql/test/BugTracker-2012/Tests/bug_large-insert-Bug.2960.stable.out sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.err sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.out sql/test/BugTracker-2012/Tests/cast-tinyint-Bug-3137.stable.err sql/test/BugTracker-2012/Tests/cast-tinyint-Bug-3137.stable.out sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.sql sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.stable.err sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.stable.out sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.stable.err sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.stable.out sql/test/BugTracker-2012/Tests/conditions_when_for_triggers_do_not_work.Bug-2073.sql sql/test/BugTracker-2012/Tests/conditions_when_for_triggers_do_not_work.Bug-2073.stable.err sql/test/BugTracker-2012/Tests/conditions_when_for_triggers_do_not_work.Bug-2073.stable.out sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.sql sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.stable.err sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.stable.out sql/test/BugTracker-2012/Tests/create_function.Bug-3172.sql sql/test/BugTracker-2012/Tests/create_function.Bug-3172.stable.err sql/test/BugTracker-2012/Tests/create_function.Bug-3172.stable.out sql/test/BugTracker-2012/Tests/create_index_update.Bug-3098.stable.err sql/test/BugTracker-2012/Tests/create_index_update.Bug-3098.stable.out sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.err sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.sql sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.stable.err sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.stable.out sql/test/BugTracker-2012/Tests/day-of-month-localization.Bug-2962.stable.err sql/test/BugTracker-2012/Tests/day-of-month-localization.Bug-2962.stable.out sql/test/BugTracker-2012/Tests/delete-with-constant-where.Bug-3065.stable.err sql/test/BugTracker-2012/Tests/delete-with-constant-where.Bug-3065.stable.out sql/test/BugTracker-2012/Tests/exp_bin_assertion.Bug-3209.stable.err sql/test/BugTracker-2012/Tests/exp_bin_assertion.Bug-3209.stable.out sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.sql sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.stable.err sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/BugTracker-2012/Tests/float-mod.Bug-3086.stable.err sql/test/BugTracker-2012/Tests/float-mod.Bug-3086.stable.out sql/test/BugTracker-2012/Tests/foreign_key.Bug-3114.stable.err sql/test/BugTracker-2012/Tests/foreign_key.Bug-3114.stable.out sql/test/BugTracker-2012/Tests/grant_on_qname.Bug-2958.stable.err sql/test/BugTracker-2012/Tests/grant_on_qname.Bug-2958.stable.out sql/test/BugTracker-2012/Tests/hash_join_crash.Bug-3089.stable.err sql/test/BugTracker-2012/Tests/hash_join_crash.Bug-3089.stable.out sql/test/BugTracker-2012/Tests/hash_select.Bug-2947.sql sql/test/BugTracker-2012/Tests/hash_select.Bug-2947.stable.err sql/test/BugTracker-2012/Tests/hash_select.Bug-2947.stable.out sql/test/BugTracker-2012/Tests/huge_insert.Bug-2803.sql sql/test/BugTracker-2012/Tests/huge_insert.Bug-2803.stable.out sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.stable.out sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.err sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out sql/test/BugTracker-2012/Tests/index_column_crash.Bug-3113.stable.err sql/test/BugTracker-2012/Tests/index_column_crash.Bug-3113.stable.out sql/test/BugTracker-2012/Tests/inet-casts.Bug-3205.sql sql/test/BugTracker-2012/Tests/inet-casts.Bug-3205.stable.err sql/test/BugTracker-2012/Tests/inet-casts.Bug-3205.stable.out sql/test/BugTracker-2012/Tests/innerjoin_subquery.Bug-3034.stable.err sql/test/BugTracker-2012/Tests/innerjoin_subquery.Bug-3034.stable.out sql/test/BugTracker-2012/Tests/insert_gives_39000_program_error.Bug-3097.stable.err sql/test/BugTracker-2012/Tests/insert_gives_39000_program_error.Bug-3097.stable.out sql/test/BugTracker-2012/Tests/insert_into_table_with_2_foreignkeys.Bug-3124.stable.err sql/test/BugTracker-2012/Tests/insert_into_table_with_2_foreignkeys.Bug-3124.stable.out sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.sql sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.stable.err sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.stable.out sql/test/BugTracker-2012/Tests/interval_timestamp.Bug-3002.stable.err sql/test/BugTracker-2012/Tests/interval_timestamp.Bug-3002.stable.out sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.sql sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.err sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.out sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out sql/test/BugTracker-2012/Tests/leftjoin-Bug.3041.stable.err sql/test/BugTracker-2012/Tests/leftjoin-Bug.3041.stable.out sql/test/BugTracker-2012/Tests/mal_syntax_error.Bug-2949.sql sql/test/BugTracker-2012/Tests/mal_syntax_error.Bug-2949.stable.err sql/test/BugTracker-2012/Tests/mal_syntax_error.Bug-2949.stable.out sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.sql sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.stable.err sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.stable.out sql/test/BugTracker-2012/Tests/multicolumn_join.Bug-2998.stable.err sql/test/BugTracker-2012/Tests/multicolumn_join.Bug-2998.stable.out sql/test/BugTracker-2012/Tests/multiple-arithmetic-operations.Bug-3048.stable.err sql/test/BugTracker-2012/Tests/multiple-arithmetic-operations.Bug-3048.stable.out sql/test/BugTracker-2012/Tests/name_resolution_in_proc.Bug-3074.sql sql/test/BugTracker-2012/Tests/name_resolution_in_proc.Bug-3074.stable.err sql/test/BugTracker-2012/Tests/name_resolution_in_proc.Bug-3074.stable.out sql/test/BugTracker-2012/Tests/nested-select-crash.Bug-3009.stable.err sql/test/BugTracker-2012/Tests/nested-select-crash.Bug-3009.stable.out sql/test/BugTracker-2012/Tests/non_keyword_no.Bug-3079.stable.err sql/test/BugTracker-2012/Tests/non_keyword_no.Bug-3079.stable.out sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.sql sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.err sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.sql sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.err 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.err 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.err sql/test/BugTracker-2012/Tests/order_by_on_column_exp.Bug-3193.stable.out sql/test/BugTracker-2012/Tests/outerjoin_predicate.Bug-2964.stable.err sql/test/BugTracker-2012/Tests/outerjoin_predicate.Bug-2964.stable.out sql/test/BugTracker-2012/Tests/outerjoin_select.Bug-2946.stable.err sql/test/BugTracker-2012/Tests/outerjoin_select.Bug-2946.stable.out sql/test/BugTracker-2012/Tests/overflow-in-list.Bug-3189.stable.err sql/test/BugTracker-2012/Tests/overflow-in-list.Bug-3189.stable.out sql/test/BugTracker-2012/Tests/parent-table-alias.Bug-3047.stable.err sql/test/BugTracker-2012/Tests/parent-table-alias.Bug-3047.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.err sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out sql/test/BugTracker-2012/Tests/querycache.Bug-3212.stable.err sql/test/BugTracker-2012/Tests/querycache.Bug-3212.stable.out sql/test/BugTracker-2012/Tests/rangejoin.Bug-3017.stable.err sql/test/BugTracker-2012/Tests/rangejoin.Bug-3017.stable.out sql/test/BugTracker-2012/Tests/recursive_optimizer.Bug-3191.stable.err sql/test/BugTracker-2012/Tests/recursive_optimizer.Bug-3191.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.sql sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.err sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2012/Tests/round-type-inference.Bug-2987.stable.err sql/test/BugTracker-2012/Tests/round-type-inference.Bug-2987.stable.out sql/test/BugTracker-2012/Tests/row-number-nyi.Bug-3087.stable.err sql/test/BugTracker-2012/Tests/row-number-nyi.Bug-3087.stable.out sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.err 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.sql sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.err sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.out sql/test/BugTracker-2012/Tests/segfault_incorrect_head.Bug-3028.stable.err sql/test/BugTracker-2012/Tests/segfault_incorrect_head.Bug-3028.stable.out sql/test/BugTracker-2012/Tests/server-crash.Bug-3046.stable.err sql/test/BugTracker-2012/Tests/server-crash.Bug-3046.stable.out sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.sql sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.err sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.out sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.err sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.out sql/test/BugTracker-2012/Tests/sticky-precision.Bug-2969.stable.err sql/test/BugTracker-2012/Tests/sticky-precision.Bug-2969.stable.out sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.stable.err sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.stable.out sql/test/BugTracker-2012/Tests/string-insert-default-null-crash.Bug-3168.sql sql/test/BugTracker-2012/Tests/string-insert-default-null-crash.Bug-3168.stable.err sql/test/BugTracker-2012/Tests/string-insert-default-null-crash.Bug-3168.stable.out sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.sql sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.stable.err sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.stable.out sql/test/BugTracker-2012/Tests/table_returning_func_returns_too_many_columns.Bug-3077.stable.err sql/test/BugTracker-2012/Tests/table_returning_func_returns_too_many_columns.Bug-3077.stable.out sql/test/BugTracker-2012/Tests/time-export-bug.Bug-2963.sql sql/test/BugTracker-2012/Tests/time-export-bug.Bug-2963.stable.err sql/test/BugTracker-2012/Tests/time-export-bug.Bug-2963.stable.out sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.stable.err sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.stable.out sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.stable.err sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.stable.out sql/test/BugTracker-2012/Tests/tuples_INTERSECT_vs_count_intersect_differs.Bug-2659.stable.err sql/test/BugTracker-2012/Tests/tuples_INTERSECT_vs_count_intersect_differs.Bug-2659.stable.out sql/test/BugTracker-2012/Tests/type_resolution_error_in_SQL_procedural_code.Bug-3143.stable.err sql/test/BugTracker-2012/Tests/type_resolution_error_in_SQL_procedural_code.Bug-3143.stable.out sql/test/BugTracker-2012/Tests/update_crash.Bug-2655.sql sql/test/BugTracker-2012/Tests/update_crash.Bug-2655.stable.err sql/test/BugTracker-2012/Tests/update_crash.Bug-2655.stable.out sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.err sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out sql/test/BugTracker-2012/Tests/user_defined_decimal_function.Bug-2992.stable.err sql/test/BugTracker-2012/Tests/user_defined_decimal_function.Bug-2992.stable.out sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.sql sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.stable.err sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.stable.out sql/test/BugTracker-2012/Tests/with_in_derived_table.Bug-3043.stable.err sql/test/BugTracker-2012/Tests/with_in_derived_table.Bug-3043.stable.out sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2015/Tests/readonly.Bug-3709.sql sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.err sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.out sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out sql/test/BugTracker-2016/Tests/storagemodel.stable.out sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.stable.out sql/test/BugTracker-2018/Tests/copy-into-doubled.Bug-6666.sql sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out sql/test/SQLancer/Tests/sqlancer01.stable.err sql/test/SQLancer/Tests/sqlancer01.stable.out sql/test/SQLancer/Tests/sqlancer05.stable.err sql/test/SQLancer/Tests/sqlancer06.stable.err sql/test/Tests/setoptimizer.stable.out sql/test/Triggers/Tests/trigger_projection.stable.err sql/test/Triggers/Tests/trigger_projection.stable.out sql/test/analytics/Tests/analytics14.stable.err sql/test/mapi/Tests/sql_int128.stable.out.int128 sql/test/mergetables/Tests/mergequery.stable.out sql/test/mergetables/Tests/part-elim.stable.out sql/test/miscellaneous/Tests/groupby_error.stable.out sql/test/orderidx/Tests/simpletable.stable.out sql/test/orderidx/Tests/smalltable.stable.out sql/test/pg_regress/Tests/alter_table.sql sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/inet.stable.err sql/test/pg_regress/Tests/mule_internal.sql sql/test/pg_regress/Tests/numeric.sql sql/test/pg_regress/Tests/numeric_big.sql sql/test/pg_regress/Tests/numeric_big.stable.err.int128 sql/test/pg_regress/Tests/sql_ascii.sql sql/test/pg_regress/Tests/without_oid.sql sql/test/remote/Tests/partition_elim.stable.out sql/test/subquery/Tests/correlated.stable.err sql/test/subquery/Tests/correlated.stable.out Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out gdk/gdk_align.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_calc.c gdk/gdk_group.c gdk/gdk_heap.c gdk/gdk_interprocess.c gdk/gdk_join.c gdk/gdk_logger.c gdk/gdk_logger.h gdk/gdk_logger_internals.h gdk/gdk_logger_old.c gdk/gdk_private.h gdk/gdk_storage.c monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/mal/mal.h monetdb5/mal/mal_atom.c monetdb5/mal/mal_authorize.c monetdb5/mal/mal_debugger.c monetdb5/mal/mal_parser.c monetdb5/mal/mal_prelude.c monetdb5/mal/mal_profiler.c monetdb5/mal/mel.h monetdb5/modules/atoms/json.c monetdb5/modules/kernel/algebra.c monetdb5/modules/kernel/bat5.c monetdb5/modules/kernel/batstr.c monetdb5/modules/kernel/group.c monetdb5/modules/kernel/status.c monetdb5/modules/mal/CMakeLists.txt monetdb5/modules/mal/manifold.c monetdb5/modules/mal/pcre.c monetdb5/modules/mal/querylog.c monetdb5/modules/mal/remote.c monetdb5/modules/mal/tokenizer.c monetdb5/optimizer/CMakeLists.txt monetdb5/optimizer/opt_emptybind.c monetdb5/optimizer/opt_mergetable.c monetdb5/optimizer/opt_pipes.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h monetdb5/optimizer/opt_pushselect.c monetdb5/optimizer/opt_remap.c monetdb5/optimizer/opt_support.c monetdb5/optimizer/opt_wrapper.c monetdb5/optimizer/optimizer.c sql/backends/monet5/CMakeLists.txt sql/backends/monet5/UDF/capi/capi.c sql/backends/monet5/UDF/pyapi3/pyapi3.c sql/backends/monet5/generator/generator.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql.h sql/backends/monet5/sql.mal sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_optimizer.c sql/backends/monet5/sql_result.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h sql/backends/monet5/sql_statistics.c sql/backends/monet5/sql_upgrades.c sql/backends/monet5/vaults/fits/fits.c sql/backends/monet5/vaults/netcdf/netcdf.c sql/backends/monet5/vaults/shp/shp.c sql/backends/monet5/wlr.c sql/common/sql_backend.c sql/common/sql_backend.h sql/common/sql_types.c sql/include/sql_catalog.h sql/include/sql_relation.h sql/scripts/CMakeLists.txt sql/server/rel_optimizer.c sql/server/rel_partition.c sql/server/rel_planner.c sql/server/rel_updates.c sql/server/sql_mvc.c sql/server/sql_mvc.h sql/server/sql_parser.y sql/server/sql_scan.c sql/storage/bat/bat_logger.c sql/storage/bat/bat_storage.c sql/storage/bat/bat_storage.h sql/storage/bat/bat_table.c sql/storage/bat/bat_utils.c sql/storage/bat/bat_utils.h sql/storage/sql_storage.h sql/storage/store.c sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test sql/test/BugTracker-2010/Tests/All sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test sql/test/BugTracker-2016/Tests/storagemodel.test sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test sql/test/BugTracker-2018/Tests/copy-into-doubled.Bug-6666.test sql/test/BugTracker/Tests/explain.SF-1739353.test sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/mapi/Tests/sql_int128.test sql/test/miscellaneous/Tests/groupby_error.test sql/test/orderidx/Tests/simpletable.test sql/test/orderidx/Tests/smalltable.test sql/test/pg_regress/Tests/alter_table.test sql/test/pg_regress/Tests/numeric.test sql/test/pg_regress/Tests/without_oid.test testing/Mtest.py.in tools/monetdbe/monetdbe.c Branch: unlock Log Message:
merged with default. Some more cleanup/fixing needed. diffs (truncated from 1824170 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -791,3 +791,8 @@ cb4b3f021774b60ffd84c3004d341ec04de736f3 bd91504a03736565fb2dff13cd4c94c738e81aa0 Oct2020_release ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_7 ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_SP1_release +929f5e280bc1532a2bfaab127ca7915dc3b69a33 Oct2020_9 +929f5e280bc1532a2bfaab127ca7915dc3b69a33 Oct2020_SP2_release +742b7847cfdcea39a6c19ab29eb35471d46bb2bb Oct2020_11 +929f5e280bc1532a2bfaab127ca7915dc3b69a33 Oct2020_SP2_release +742b7847cfdcea39a6c19ab29eb35471d46bb2bb Oct2020_SP2_release diff --git a/CMakeLists.txt b/CMakeLists.txt --- a/CMakeLists.txt +++ b/CMakeLists.txt @@ -69,8 +69,10 @@ monetdb_configure_defines() if(HAVE_NETDB_H) set(CMAKE_EXTRA_INCLUDE_FILES "netdb.h" "unistd.h") endif() -if(HAVE_WINSOCK_H) - set(CMAKE_EXTRA_INCLUDE_FILES "winsock.h") +if(NOT HAVE_SYS_SOCKET_H) + if(HAVE_WINSOCK_H) + set(CMAKE_EXTRA_INCLUDE_FILES "winsock.h") + endif() endif() set(CMAKE_REQUIRED_INCLUDES "/usr/include") diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -84,7 +84,7 @@ Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ BugURL: https://bugs.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Oct2020-SP1/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Oct2020-SP2/%{name}-%{version}.tar.bz2 # The Fedora packaging document says we need systemd-rpm-macros for # the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7 @@ -363,6 +363,7 @@ developer. %files client-tests %defattr(-,root,root) %{_bindir}/arraytest +%{_bindir}/bincopydata %{_bindir}/odbcsample1 %{_bindir}/sample0 %{_bindir}/sample1 @@ -681,7 +682,11 @@ developer, but if you do want to test, t %files testing-python %defattr(-,root,root) +%{_bindir}/Mconvert.py %{_bindir}/Mtest.py +%{_bindir}/Mz.py +%{_bindir}/mktest.py +%{_bindir}/sqllogictest.py %dir %{python3_sitelib}/MonetDBtesting %{python3_sitelib}/MonetDBtesting/* @@ -823,6 +828,39 @@ else fi %changelog +* Mon Jan 18 2021 Sjoerd Mullender <sjo...@acm.org> - 11.39.11-20210118 +- Rebuilt. +- GH#3772: Any user can grant a role. + +* Mon Jan 11 2021 Sjoerd Mullender <sjo...@acm.org> - 11.39.9-20210111 +- Rebuilt. +- GH#6862: mserver5: crashes under update_table() when calling lib_sql.so + ( max_clients = 2048) +- GH#7002: monetdb stop fails +- GH#7012: mclient enters an infinite loop when a file on the command line + does not exist +- GH#7013: Select * on grouped view: wrong error "cannot use non GROUP BY + column 'a1' in query results without an aggregate function" +- GH#7017: mal seems to leak in functions +- GH#7020: release an older savepoint causes "BATproject2: does not match + always" +- GH#7021: savepoints crash mserver5 +- GH#7022: transaction with an unreleased savepoint not properly persisted +- GH#7023: CREATE VIEW: SELECT: cannot use non GROUP BY column '%1' in + query results without an aggregate function +- GH#7024: DELETE FROM or TRUNCATE on freshly created table leads to + loosing all further inserts in same transaction +- GH#7030: DROP TABLE with AUTO_INCREMENT doesn't drop sequence causing + left-over dependency +- GH#7034: User with sysadmin role cannot create another user +- GH#7035: UPDATE and SELECT column privileges + +* Thu Dec 10 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.39.9-20210111 +- sql: CREATE [OR REPLACE] TRIGGER schema_name.trigger_name is now disallowed, + because the trigger will be stored on the same schema as the table it + refers to. Use a schema-qualified on the table reference (ie ON clause) + when necessary. + * Wed Nov 18 2020 Sjoerd Mullender <sjo...@acm.org> - 11.39.7-20201118 - Rebuilt. - BZ#6890: Add support of xz/lzma (de)compression on MS Windows @@ -1359,4278 +1397,3 @@ fi thereby avoiding the interaction with other queries, but loosing insight of competing queries. The stethoscope should be used for that. -* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.19-20200222 -- Rebuilt. -- BZ#6829: NTILE window function returns incorrect results - -* Fri Feb 21 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.17-20200221 -- Rebuilt. -- BZ#6827: CUME_DIST window function returns incorrect results - -* Mon Feb 17 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.15-20200217 -- Rebuilt. -- BZ#6817: running analyze on a schema which contains a stream table - stops with an error -- BZ#6819: functions do not persist - -* Wed Feb 12 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.13-20200212 -- Rebuilt. - -* Tue Feb 11 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.11-20200211 -- Rebuilt. -- BZ#6805: Using the cascade operator in a drop table statement ends in - an exit from the Monetdb shell. -- BZ#6807: Median_avg and quantile_avg ignore NULL values -- BZ#6815: query with ifthenelse() crashes mserver5 -- BZ#6816: Monetdb Crashes on INSERT statement after ALTER statement in - another connection - -* Wed Dec 18 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.9-20191218 -- Rebuilt. -- BZ#6804: DNS resolution of 0.0.0.0 fails on recent Ubuntus - -* Tue Dec 17 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.7-20191217 -- Rebuilt. - -* Thu Dec 12 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.5-20191212 -- Rebuilt. -- BZ#6723: columns aliases duplicates should not be allowed. automatic - aliasing required. -- BZ#6724: Prepare confuses types when more than one argument is used -- BZ#6726: Python aggregation does not create aggr_group when aggregating - over all rows -- BZ#6765: GRANT SELECT privilege on a subset of table columns results - in access denied error when selecting the same columns from the table -- BZ#6790: Count distinct giving wrong results -- BZ#6791: str_to_time('11:40', '%H:%M') creates wrong time value -- BZ#6792: JSON path compiler accepts invalid input -- BZ#6793: cast(interval second value to int or decimal) is wrong (by - a factor of 1000), cast(interval month value to decimal or floating - point) fails -- BZ#6794: external name fits.listdir not bound (sys.listdir) Fatal - error during initialization: -- BZ#6796: Incorrect crash time reported by monetdb tool after crash - of mserver5 -- BZ#6798: json.text off by one error - -* Mon Nov 25 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.3-20191125 -- Rebuilt. -- BZ#3533: SQL aggregate functions avg(), sum() and median() return an - error when used on a column with datatype interval second - -* Mon Nov 18 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- Rebuilt. -- BZ#6134: Query produces error: HEAPalloc: Insufficient space for HEAP - of 1168033427456 bytes. -- BZ#6613: LATERAL crash /.../rel_bin.c:1473: rel2bin_table: Assertion - `0' failed. -- BZ#6683: Bug in subselect -- BZ#6686: Bug in subselect (count function) -- BZ#6688: Bug in subselect (or condition) -- BZ#6689: Trying to improve the performance of SQL queries with a large - list of members in IN clause. -- BZ#6695: timestamp transformation -- BZ#6700: Monetdb Bugs in Subselect statements: -- BZ#6722: window functions issues -- BZ#6740: while upgrading the database from verison (MonetDB-11.27.13) - to (MonetDB-11.33.3) we are unable to bring up the database -- BZ#6754: in mclient a strang msg is reported after issueing command: - set schema sys; -- BZ#6755: Assertion failure in rel_bin.c -- BZ#6756: Error in optimizer garbageCollector on merge tables select -- BZ#6757: Double free or corruption (out) -- BZ#6758: SIGSEGV in __strcmp_sse2_unaligned() -- BZ#6759: Python JSON loader creates invalid data type for strings -- BZ#6761: Error: Program contains errors.:(NONE).multiplex -- BZ#6762: mserver5 crashes on (re-)start -- BZ#6764: mserver5 crashes with corruption, double free, invalid size - or invalid pointer -- BZ#6766: Missing bulk implementation for get_value and next_value calls -- BZ#6769: ProfilerStart is not threadsafe -- BZ#6771: R-devel -- BZ#6773: json.filter returns corrupted string when selecting JSON - null value -- BZ#6774: PROD aggregation gives wrong result -- BZ#6775: NOT IN with an AND containing an OR gives wrong result -- BZ#6776: Creating a table with a full outer join query gives type with - wrong digits on the joined key. -- BZ#6779: Using Windows Messages translation for errno error codes. -- BZ#6780: Wrong value of the rank function -- BZ#6781: Insert after index creation crash -- BZ#6783: AVG changes scale of its results -- BZ#6784: function sys.isauuid(string) should return false if string - value cannot be converted to a UUID - -* Mon Nov 4 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Removed functions json.text(string) returns string and json.text(int) - returns string. Their MAL implementation didn't exist, so they were - meaningless. - -* Thu Oct 17 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- merovingian: Added "vmmaxsize" and "memmaxsize" mserver5 options to the daemon in - order to set mserver5's maximum virtual and committed memory - respectively. - -* Wed Sep 25 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- sql: Strings are now limited to 1GB, double-quoted tokens are limited to 2kB. - These sizes are bytes of (UTF-8 encoded) input data. - -* Mon Sep 23 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- sql: There are new aggregate functions sys.median_avg and sys.quantile_avg - that return the interpolated value if the median/quantile doesn't fall - exactly on a particular row. These functions always return a value - of type DOUBLE and only work for numeric types (various width integers - and floating point). - -* Sun Sep 8 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- gdk: BATcalcbetween and all its variants now have an extra bool parameter - "anti" to invert the test. - -* Thu Sep 5 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: The server "console" has been removed, as has the --daemon option. - The server now doesn't read from standard input anymore. The way to - stop a server is by sending it a TERM signal (on Linux/Unix) or by - sending it an interrupt signal (usually control-C -- on all - systems). - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Added sys.deltas ("schema" string, "table" string, "column" string) - returns table ("values" bigint) system function which returns a single - column with 6 values: a flag indicating if the column's upper table is - cleared or not, the count of the RDONLY, RD_INS and RD_UPD_ID deltas - of the column itself, the number of deleted values of the column's - table, as well as the level of the current transaction in the - transaction level tree. It should be used for debugging purposes only. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: Implemented a function bat.diffcand to calculate difference of two - candidate lists. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: The mtime module was completely rewritten, the atom types date, - daytime, and timestamp were changed. Upgrade code for BATs - containing these types has been implemented. The old daytime type - used a 32 bit integer to record milliseconds since the start of the - day. The new daytime type uses a 64 bit integer to record - microseconds since the start of the day. The old date type recorded - days since or before the year 1. The new daytime type records the - day of the month and the number of months since the year -4712 - separately in a single 32 bit integer of which only 26 bits are - used. Dates now use the proleptic Gregorian calendar, meaning the - normal Gregorian callendar has been extended backward, and before - the year 1, we have the year 0. Both the old and new timestamp - types are a combination of a daytime and a date value, but since - those types have changed, the timestamp type has also changed. The - new date type has a smaller range than the old. The new date range - is from the year -4712 to the year 170049. During conversion of - date and timestamp columns, the dates are clamped to this range. -- monetdb5: The tzone and rule atom types have been removed. They were not used - by any code, and they were defined in a non-portable way. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Added "VALUES row_list" statement as a top SQL projection statement. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- merovingian: Added ipv6 property to monetdbd properties to force IPv6 addresses - binding only. By default this property is false to allow IPv4 - addresses as well. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- monetdb5: Added "mapi_ipv6" property to monet_options to force ipv6 address - binding only. This property is inherited while forking from - monetdbd if it is also set there. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- gdk: All forms of BATcalcbetween and VARcalcbetween have extra bool arguments - for low inclusive, high inclusive and nils false. The latter causes - the result to be false instead of nil if the value being checked is nil. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: Removed (bat)calc.between_symmetric and changed (bat)calc.between - by adding a number of extra arguments, all of type :bit: symmetric, - low inclusive, high inclusive, nils false. - -* Fri Aug 30 2019 Aris Koning <aris.kon...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: The implementation of in-expression now follows a join-based approach - instead of using iterative union/selects. This greatly improves - performance for large in-value-lists. Furthermore the old approach has - large in-value-lists generate large MAL plans. This is now no longer _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list