Changeset: c3aaea598a9f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c3aaea598a9f
Added Files:
        .bumpversion.cfg
        sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.sql
        sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.err
        sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.out
        sql/test/Tests/hot-snapshot-bz2.py
        sql/test/Tests/hot-snapshot-bz2.stable.err
        sql/test/Tests/hot-snapshot-bz2.stable.out
        sql/test/Tests/hot-snapshot-gz.py
        sql/test/Tests/hot-snapshot-gz.stable.err
        sql/test/Tests/hot-snapshot-gz.stable.out
        sql/test/Tests/hot-snapshot-lz4.py
        sql/test/Tests/hot-snapshot-lz4.stable.err
        sql/test/Tests/hot-snapshot-lz4.stable.out
        sql/test/Tests/hot-snapshot-xz.py
        sql/test/Tests/hot-snapshot-xz.stable.err
        sql/test/Tests/hot-snapshot-xz.stable.out
        sql/test/Tests/hot_snapshot_compression.py
Removed Files:
        vertoo.config
        vertoo.data
Modified Files:
        .hgtags
        MonetDB.spec
        NT/monetdb_config.h.in
        NT/rules.msc
        buildtools/conf/Maddlog
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
        clients/Tests/mclient-uri.stable.out
        clients/Tests/mclient-uri.stable.out.Windows
        clients/examples/perl/sqlsample.pl
        clients/examples/python/sqlsample.py
        clients/mapiclient/mclient.c
        clients/mapilib/mapi.rc
        clients/odbc/driver/driver.rc
        clients/odbc/winsetup/setup.rc
        common/stream/stream.c
        configure.ag
        debian/changelog
        debian/monetdb5-sql.postinst
        gdk/gdk_aggr.c
        gdk/gdk_batop.c
        gdk/gdk_bbp.c
        gdk/gdk_calc.c
        gdk/gdk_calc.h
        gdk/gdk_cross.c
        gdk/gdk_hash.c
        gdk/gdk_join.c
        gdk/gdk_logger.c
        gdk/gdk_posix.c
        gdk/gdk_storage.c
        gdk/gdk_string.c
        gdk/gdk_system.c
        gdk/gdk_tracer.c
        gdk/gdk_utils.c
        gdk/gdk_value.c
        gdk/libbat.rc
        geom/lib/libgeom.h
        geom/monetdb5/geom.c
        geom/sql/pg_regression/Tests/dump.stable.out
        libversions
        monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
        monetdb5/extras/rapi/rapi.c
        monetdb5/mal/Tests/tst1506.stable.out
        monetdb5/mal/mal_client.c
        monetdb5/mal/mal_errors.h
        monetdb5/mal/mal_exception.c
        monetdb5/modules/atoms/mtime.c
        monetdb5/modules/mal/batcalc.c
        monetdb5/modules/mal/batmtime.mal
        monetdb5/modules/mal/calc.c
        monetdb5/modules/mal/mal_mapi.c
        monetdb5/modules/mal/pcre.c
        monetdb5/optimizer/opt_mergetable.c
        monetdb5/optimizer/opt_mitosis.c
        monetdb5/optimizer/opt_remap.c
        monetdb5/tools/libmonetdb5.rc
        sql/ChangeLog-Archive
        sql/backends/monet5/Tests/optimizers.stable.out
        sql/backends/monet5/Tests/rapi09.stable.out
        sql/backends/monet5/Tests/simpleSQL.stable.out
        sql/backends/monet5/UDF/pyapi3/connection3.c
        sql/backends/monet5/UDF/pyapi3/convert_loops.h
        sql/backends/monet5/UDF/pyapi3/formatinput3.c
        sql/backends/monet5/UDF/pyapi3/pyapi3.c
        sql/backends/monet5/UDF/pyapi3/pyheader.h
        sql/backends/monet5/UDF/pyapi3/pytypes3.c
        sql/backends/monet5/UDF/pyapi3/type_conversion.h
        sql/backends/monet5/UDF/pyapi3/type_conversion3.c
        sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
        sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
        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_bat2time.c
        sql/backends/monet5/sql_cast.c
        sql/backends/monet5/sql_cast.h
        sql/backends/monet5/sql_cast_impl_down_from_flt.h
        sql/backends/monet5/sql_cast_impl_int.h
        sql/backends/monet5/sql_cast_impl_up_to_flt.h
        sql/backends/monet5/sql_decimal.mal
        sql/backends/monet5/sql_decimal.mal.sh
        sql/backends/monet5/sql_decimal_hge.mal
        sql/backends/monet5/sql_decimal_hge.mal.sh
        sql/backends/monet5/sql_hge.mal
        sql/backends/monet5/sql_rank.c
        sql/backends/monet5/sql_round_impl.h
        sql/backends/monet5/sql_statement.c
        sql/backends/monet5/sql_statement.h
        sql/backends/monet5/sql_user.c
        sql/common/sql_types.c
        sql/jdbc/tests/Tests/JdbcClient_create_tables.sql
        sql/jdbc/tests/Tests/JdbcClient_inserts_selects.sql
        sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
        sql/server/rel_exp.c
        sql/server/rel_exp.h
        sql/server/rel_optimizer.c
        sql/server/rel_outer_join_optimizer.h
        sql/server/rel_rel.c
        sql/server/rel_rel.h
        sql/server/rel_rewriter.c
        sql/server/rel_rewriter.h
        sql/server/rel_select.c
        sql/server/rel_unnest.c
        sql/server/sql_atom.c
        sql/server/sql_mvc.c
        sql/server/sql_mvc.h
        sql/server/sql_parser.y
        sql/server/sql_partition.c
        sql/server/sql_query.c
        sql/server/sql_semantic.c
        sql/storage/bat/bat_storage.c
        sql/storage/bat/bat_table.c
        sql/storage/sql_storage.h
        sql/storage/store.c
        sql/test/BugDay_2005-10-06_2.8/Tests/select_null.stable.out
        sql/test/BugDay_2005-10-06_2.8/Tests/string_quotes.SF-919539.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/basic_arithmetics.SF-922252.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/select_not_true.SF-1314945.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/set_types.SF-932360.stable.out
        
sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
        
sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out
        sql/test/BugTracker-2009/Tests/AVG_of_SQRT.SF-2757642.stable.out
        sql/test/BugTracker-2009/Tests/BOM.SF-2787813.stable.out
        
sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
        
sql/test/BugTracker-2009/Tests/Floating_point_exception.SF-2791356.stable.out
        sql/test/BugTracker-2009/Tests/addmonths_missing.SF-2854949.stable.out
        
sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out
        sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out.int128
        sql/test/BugTracker-2009/Tests/coercion.stable.out
        sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out
        sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out
        
sql/test/BugTracker-2009/Tests/function_call_not_handled.SF-2864179.stable.out
        sql/test/BugTracker-2009/Tests/pow_operator.SF-2812721.stable.out
        
sql/test/BugTracker-2009/Tests/restart_with_large_int.SF-2846238.stable.out
        
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
        sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.stable.out
        sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.out
        sql/test/BugTracker-2010/Tests/crash_on_where_in.Bug-2333.stable.out
        sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.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-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
        sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out
        sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.out
        
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/correlated_select.Bug-3250.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/iso8601_weekofyear.Bug-3232.stable.out
        sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out
        sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.out
        sql/test/BugTracker-2013/Tests/recursion.stable.out
        sql/test/BugTracker-2013/Tests/subtract-one-year.Bug-3215.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/hexadecimal_literals.Bug-3621.stable.out
        
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out.int128
        sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
        sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out
        sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out
        sql/test/BugTracker-2015/Tests/apply_merge_distinct.Bug-3760.stable.out
        sql/test/BugTracker-2015/Tests/assertHead.Bug-3706.stable.out
        sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out
        sql/test/BugTracker-2015/Tests/case_type.Bug-3821.stable.out
        sql/test/BugTracker-2015/Tests/cast_to_num.Bug-3744.stable.out
        sql/test/BugTracker-2015/Tests/coalesce.Bug-3830.stable.out
        
sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.stable.out
        
sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.stable.out.Darwin
        sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.stable.out
        sql/test/BugTracker-2015/Tests/epoch_now.Bug-3740.stable.out
        sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out
        sql/test/BugTracker-2015/Tests/inet-funcs.Bug-3645.stable.out
        sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.stable.out
        sql/test/BugTracker-2015/Tests/many_union_all.Bug-3879.stable.out
        sql/test/BugTracker-2015/Tests/nil_cast.Bug-3787.stable.out
        sql/test/BugTracker-2015/Tests/null.Bug-3833.stable.out
        sql/test/BugTracker-2015/Tests/null_is_null.Bug-3739.stable.out
        sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
        sql/test/BugTracker-2015/Tests/select-push-crash.Bug-3829.stable.out
        sql/test/BugTracker-2015/Tests/select-tilde-arg.Bug-3814.stable.out
        sql/test/BugTracker-2015/Tests/set_default_role.Bug-3364.stable.out
        sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.stable.out
        sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.out
        
sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.sql
        
sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.stable.out
        
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.single
        
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
        
sql/test/BugTracker-2016/Tests/outer_constant_predicate.Bug-4070.stable.out
        
sql/test/BugTracker-2016/Tests/prepare_without_querycache.Bug-4047.stable.out
        sql/test/BugTracker-2016/Tests/union.Bug-6069.stable.out
        
sql/test/BugTracker-2017/Tests/cast-with-many-decimals.Bug-6195.stable.out.int128
        sql/test/BugTracker-2017/Tests/check_system_schema.Bug-6437.stable.out
        sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.stable.out
        sql/test/BugTracker-2017/Tests/complicated_logic.Bug-105.stable.out
        
sql/test/BugTracker-2017/Tests/crash-select_after_MAL_error.Bug-6332.stable.out
        sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.stable.out
        sql/test/BugTracker-2017/Tests/date_to_str.Bug-6467.stable.out
        sql/test/BugTracker-2017/Tests/drop_system_schema.Bug-6437.stable.out
        sql/test/BugTracker-2017/Tests/error-clean-cache.Bug-6351.stable.out
        sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
        sql/test/BugTracker-2017/Tests/heapextend.Bug-6134.stable.out
        
sql/test/BugTracker-2017/Tests/integer_addition_overflow.Bug-6205.stable.out
        sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
        sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
        sql/test/BugTracker-2017/Tests/modulo.Bug-6225.stable.out
        sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.out
        sql/test/BugTracker-2017/Tests/not_plus.Bug-6294.stable.out
        sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out
        sql/test/BugTracker-2017/Tests/real-power.Bug-6228.stable.out
        sql/test/BugTracker-2017/Tests/round-or-truncate.Bug-6193.stable.out
        
sql/test/BugTracker-2017/Tests/select-in-returns-null.Bug-6491.stable.out
        sql/test/BugTracker-2017/Tests/splitpart.Bug-6194.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.stable.out
        
sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in-column.Bug-6490.stable.out
        sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.out
        sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.stable.out
        
sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out
        sql/test/BugTracker-2017/Tests/str2decimal.Bug-6206.stable.out
        
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err.int128
        
sql/test/BugTracker-2018/Tests/alter-sequence-subquery.Bug-6657.stable.out
        sql/test/BugTracker-2018/Tests/concat-str-int.Bug-6583.stable.out
        sql/test/BugTracker-2018/Tests/negative-sequences.Bug-6665.stable.out
        
sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.stable.out
        sql/test/BugTracker-2018/Tests/pyUDF-crash.Bug-6508.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-case-not-in-count.Bug-6587.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-add.Bug-6630.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-extra-columns.Bug-6555.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6552.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-count-coalesce-nullif.Bug-6586.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in-cast.Bug-6561.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-not-null-not-in.Bug-6562.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-having-not-null-not-in.Bug-6557.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-mal-calc-undefined.Bug-6566.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-missing-bulk-implementation.Bug-6575.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-nested-case.Bug-6554.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-not-in-wrong-results.Bug-6530.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-overflow-in-conversion.Bug-6517.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-select-not-in-wrong.Bug-6602.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-select-nullif-case.Bug-6579.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-mal-function-generation.Bug-6513.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.stable.out
        sql/test/BugTracker-2018/Tests/timestamp-roundtrip.Bug-6640.stable.out
        sql/test/BugTracker-2019/Tests/All
        
sql/test/BugTracker-2019/Tests/disallow_duplicate_column_aliases.Bug-6723.stable.out
        
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
        
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
        sql/test/BugTracker-2019/Tests/next-get-value-bulk.Bug-6766.stable.out
        sql/test/BugTracker-2019/Tests/prepare-types.Bug-6724.stable.out
        
sql/test/BugTracker-2019/Tests/set-schema-mclient-msg.Bug-6754.stable.out
        sql/test/BugTracker-2020/Tests/All
        sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out
        sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out.int128
        sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out
        sql/test/BugTracker/Tests/connect_crash.SF-1436626.stable.out
        
sql/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.stable.out
        sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.stable.out
        sql/test/BugTracker/Tests/crash_on_delete.SF-1639108.stable.out
        sql/test/BugTracker/Tests/crash_on_delete.SF-1651567.stable.out
        sql/test/BugTracker/Tests/crash_on_insert.SF-1639113.stable.out
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
        sql/test/BugTracker/Tests/like_for_time_values.SF-1715659.stable.out
        
sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out
        sql/test/BugTracker/Tests/ms_round.SF-1907063.stable.out
        sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out
        
sql/test/BugTracker/Tests/select_crashes_in_the_optimization.SF-1848553.stable.out
        sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
        sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.out
        sql/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.stable.out
        sql/test/BugTracker/Tests/variable_names.SF-1838816.stable.out
        sql/test/BugTracker/Tests/variables.SF-1508160.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/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.stable.out
        sql/test/Skyserver/Tests/Skyserver.stable.out
        sql/test/Tests/50ways.sql
        sql/test/Tests/50ways.stable.out
        sql/test/Tests/All
        sql/test/Tests/add_column_with_seq.sql
        sql/test/Tests/alter-sequence.sql
        sql/test/Tests/antiselect.sql
        sql/test/Tests/cast_str2num.sql
        sql/test/Tests/coalesce.sql
        sql/test/Tests/count.sql
        sql/test/Tests/crashme.sql
        sql/test/Tests/create_in_schema.sql
        sql/test/Tests/decimal.sql
        sql/test/Tests/decimal.stable.err
        sql/test/Tests/decimal2.sql
        sql/test/Tests/decimal2.stable.out
        sql/test/Tests/default.sql
        sql/test/Tests/example-delete1.sql
        sql/test/Tests/example-delete2.sql
        sql/test/Tests/example-delete3.sql
        sql/test/Tests/example-drop.sql
        sql/test/Tests/example-queries.sql
        sql/test/Tests/example-rangeselect.sql
        sql/test/Tests/example-transaction.sql
        sql/test/Tests/example-update-view.sql
        sql/test/Tests/example-update1.sql
        sql/test/Tests/example-update2.sql
        sql/test/Tests/example-update3.sql
        sql/test/Tests/example.sql
        sql/test/Tests/function_syntax.sql
        sql/test/Tests/identifiers.sql
        sql/test/Tests/ifexists.stable.out
        sql/test/Tests/joins.sql
        sql/test/Tests/keys.sql
        sql/test/Tests/keys.stable.out
        sql/test/Tests/marcin1.sql
        sql/test/Tests/marcin2.sql
        sql/test/Tests/null.sql
        sql/test/Tests/order_by_simple_exp.sql
        sql/test/Tests/orderby_limit.sql
        sql/test/Tests/orderby_non_selection_column.sql
        sql/test/Tests/procedure_syntax.sql
        sql/test/Tests/psm.sql
        sql/test/Tests/restart-sequence.sql
        sql/test/Tests/round.sql
        sql/test/Tests/session_vars.stable.out
        sql/test/Tests/setoptimizer.sql
        sql/test/Tests/setoptimizer.stable.out
        sql/test/Tests/string.sql
        sql/test/Tests/table_function.sql
        sql/test/Tests/timezone.sql
        sql/test/Tests/timezone.stable.out
        sql/test/Tests/trace.stable.out
        sql/test/Tests/zones2.sql
        sql/test/Users/Tests/changePasswordUser.stable.out
        sql/test/Users/Tests/createUserRollback.stable.out
        sql/test/Users/Tests/metadataConsistency.stable.out
        sql/test/Users/Tests/test_privs2_p1.stable.out
        sql/test/VOC/Tests/median.Bug-3096.stable.out
        sql/test/VOC/VOCcreate_user.sql
        sql/test/VOC/VOCdrop.sql
        sql/test/VOC/VOCdrop_user.sql
        sql/test/VOC/VOCinsert.sql
        sql/test/VOC/VOCmanual_examples.sql
        sql/test/VOC/VOCquery.sql
        sql/test/analytics/Tests/analytics11.stable.out
        sql/test/analytics/Tests/analytics16.stable.err
        sql/test/bugs/Tests/arith-bug-sf-949228.sql
        sql/test/bugs/Tests/arith-bug-sf-949228.stable.out
        sql/test/bugs/Tests/autocommit_illegal_statements-bug-sf-953545.sql
        sql/test/bugs/Tests/case_cast-bug-sf-1019506.sql
        sql/test/bugs/Tests/case_parenthesis-bug-sf-1023056.sql
        sql/test/bugs/Tests/case_parenthesis-bug-sf-1023056.stable.out
        sql/test/bugs/Tests/case_substring.stable.out
        sql/test/bugs/Tests/cast_bool2int-bug-sf-1000576.sql
        sql/test/bugs/Tests/cast_bool2int-bug-sf-1000576.stable.out
        sql/test/bugs/Tests/cast_bool2int-bug-sf-951800.sql
        sql/test/bugs/Tests/cast_bool2int-bug-sf-951800.stable.out
        sql/test/bugs/Tests/cast_varchar2int-bug-sf-964165.sql
        sql/test/bugs/Tests/cast_varchar2int-bug-sf-964165.stable.out
        sql/test/bugs/Tests/crash_order_by.stable.out
        sql/test/bugs/Tests/create_insert_select-bug-sf-900198.sql
        sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.sql
        sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out
        sql/test/bugs/Tests/cur_date_crash-JIRA-42.stable.out
        sql/test/bugs/Tests/date_parsing-bug-sf-960166.sql
        sql/test/bugs/Tests/date_parsing-bug-sf-960166.stable.out
        sql/test/bugs/Tests/default_with_cast.SF-1334486.stable.out
        sql/test/bugs/Tests/drop_foreignkey_selfreferencing.sql
        sql/test/bugs/Tests/escape_quote-bug-sf-1006469.stable.out
        sql/test/bugs/Tests/except-union-intersect-bug-sf-1146079.sql
        sql/test/bugs/Tests/extract_interval_bug-sf-1274088.sql
        sql/test/bugs/Tests/extract_interval_bug-sf-1274088.stable.out
        sql/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.sql
        sql/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.stable.out
        sql/test/bugs/Tests/floor-bug-sf-967066.sql
        sql/test/bugs/Tests/floor-bug-sf-967066.stable.out
        sql/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.sql
        sql/test/bugs/Tests/groupby_having-bug-sf-947600.sql
        sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out
        sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.sql
        sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
        sql/test/bugs/Tests/in.stable.out
        sql/test/bugs/Tests/in_or_bug.stable.out
        sql/test/bugs/Tests/innerjoin_between-bug-sf-960672.sql
        sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.sql
        sql/test/bugs/Tests/insert_into_groupby-bug-sf-949135.sql
        sql/test/bugs/Tests/insert_into_select-bug-sf-978043.sql
        sql/test/bugs/Tests/insert_update_arith-bug-sf-900206.sql
        sql/test/bugs/Tests/interval_convert_bugs-sf-1274077-1274085.sql
        sql/test/bugs/Tests/interval_convert_bugs-sf-1274077-1274085.stable.out
        sql/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.sql
        
sql/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.stable.out
        sql/test/bugs/Tests/interval_parse_bug-sf-1263967.sql
        sql/test/bugs/Tests/interval_parse_bug-sf-1263967.stable.out
        sql/test/bugs/Tests/like-bug-sf-1031435.sql
        sql/test/bugs/Tests/like-bug-sf-1043521.sql
        sql/test/bugs/Tests/not.stable.out
        sql/test/bugs/Tests/numeric-bug-sf-952758.sql
        sql/test/bugs/Tests/object_name-bug-sf-985242.sql
        sql/test/bugs/Tests/polymorphism.stable.out
        sql/test/bugs/Tests/primary_key-bug-sf-975308.sql
        sql/test/bugs/Tests/savepoint_release-bug-sf-953560.sql
        sql/test/bugs/Tests/savepoint_rollback-bug-sf-1023652.sql
        sql/test/bugs/Tests/savepoint_rollback-bug-sf-953553.sql
        sql/test/bugs/Tests/seconds2timestamp.stable.out
        sql/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.sql
        
sql/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.stable.out
        sql/test/bugs/Tests/select_into.stable.out
        sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.sql
        sql/test/bugs/Tests/selectlist_subquery-sf-1208599.sql
        sql/test/bugs/Tests/start_transaction-bug-sf-952755.sql
        sql/test/bugs/Tests/subselect_ambigious_columns-bug-sf-949071.sql
        sql/test/bugs/Tests/subselect_column-bug-sf-951206.sql
        
sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.sql
        sql/test/bugs/Tests/subselect_single_value-bug-sf-941791.sql
        sql/test/bugs/Tests/subselect_single_value-bug-sf-962099.sql
        sql/test/bugs/Tests/subselect_single_value-bug-sf-962099.stable.out
        sql/test/bugs/Tests/subselect_union-bug-sf-941826.sql
        sql/test/bugs/Tests/timestamp_comparison-bug-sf-1158581.sql
        sql/test/bugs/Tests/trimtest-bug-sf-1023588.sql
        sql/test/bugs/Tests/trimtest-bug-sf-1023588.stable.out
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324.sql
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out
        
sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out.Windows
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out
        sql/test/bugs/Tests/union-bug-sf-978045.sql
        sql/test/bugs/Tests/union_all-bug-sf-941788.sql
        sql/test/bugs/Tests/union_all_where_1=1-bug-sf-936386.sql
        sql/test/bugs/Tests/unique-bug-sf-1043512.sql
        sql/test/bugs/Tests/update_where-bug-sf-976963.sql
        sql/test/bugs/Tests/view_join-bug-sf-990096.sql
        sql/test/bugs/Tests/view_selfjoin-bug-sf-937835.sql
        sql/test/bugs/Tests/zero_or_one_bug.stable.out
        sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
        sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
        sql/test/emptydb/Tests/check.SQL.py
        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/emptydb/Tests/load.stable.out
        sql/test/json/Tests/All
        sql/test/mapi/Tests/perl_dbi.stable.out
        sql/test/mapi/Tests/python3_dbapi.stable.out
        sql/test/mapi/Tests/smack01.stable.out
        sql/test/mapi/Tests/sql_int128.stable.out.int128
        sql/test/mergetables/Tests/sqlsmith-exists.stable.out
        sql/test/mergetables/Tests/sqlsmith-exists2.sql
        sql/test/mergetables/Tests/sqlsmith-exists2.stable.out
        sql/test/miscellaneous/Tests/deallocate.stable.out
        sql/test/miscellaneous/Tests/declared_tables.stable.out
        sql/test/miscellaneous/Tests/groupby_error.sql
        sql/test/miscellaneous/Tests/groupby_error.stable.out
        sql/test/miscellaneous/Tests/groupby_expressions.stable.out
        sql/test/miscellaneous/Tests/simple_plans.sql
        sql/test/miscellaneous/Tests/simple_plans.stable.out
        sql/test/miscellaneous/Tests/simple_selects.stable.out
        sql/test/miscellaneous/Tests/table_udf_missing_var.stable.out
        sql/test/miscellaneous/Tests/trace_test.stable.out
        sql/test/miscellaneous/Tests/values.stable.err
        sql/test/miscellaneous/Tests/values.stable.out
        sql/test/pg_regress/Tests/alter_table.stable.out
        sql/test/pg_regress/Tests/case.stable.out
        sql/test/pg_regress/Tests/date.stable.out
        sql/test/pg_regress/Tests/float4.stable.out
        sql/test/pg_regress/Tests/float8.stable.out
        sql/test/pg_regress/Tests/float8.stable.out.Windows
        sql/test/pg_regress/Tests/horology.stable.out
        sql/test/pg_regress/Tests/inet.stable.out
        sql/test/pg_regress/Tests/numeric.stable.out.int128
        sql/test/pg_regress/Tests/path.stable.out
        sql/test/pg_regress/Tests/polygon.stable.out
        sql/test/pg_regress/Tests/strings.stable.out
        sql/test/pg_regress/Tests/time.stable.out
        sql/test/pg_regress/Tests/timestamp.stable.out
        sql/test/pg_regress/Tests/timestamptz.stable.out
        sql/test/pg_regress/Tests/timetz.stable.out
        sql/test/scanner/Tests/mserver_with_raw_strings.stable.out
        sql/test/scanner/Tests/mserver_without_raw_strings.stable.out
        sql/test/scanner/Tests/raw_strings.stable.out
        sql/test/scripts/Tests/alastair_udf_mergetable_bug.stable.out
        sql/test/snodgrass/Tests/cast_select.stable.out
        sql/test/snodgrass/Tests/date_parsing.stable.out
        sql/test/snodgrass/Tests/date_select.stable.out
        sql/test/snodgrass/Tests/extract_select.stable.out
        sql/test/snodgrass/Tests/interval_parsing.stable.out
        sql/test/snodgrass/Tests/interval_select.stable.out
        sql/test/ssqq/Tests/insert_query.stable.out
        sql/test/ssqq/Tests/insert_queue.stable.out
        sql/test/ssqq/Tests/insert_quser.stable.out
        sql/test/subquery/Tests/any_all.stable.out
        sql/test/subquery/Tests/exists.stable.out
        sql/test/subquery/Tests/scalar.stable.out
        sql/test/subquery/Tests/subquery.stable.out
        sql/test/subquery/Tests/subquery2.stable.out
        sql/test/subquery/Tests/subquery3.stable.out
        sql/test/subquery/Tests/subquery4.sql
        sql/test/subquery/Tests/subquery4.stable.out
        sql/test/subquery/Tests/subquery5.stable.out
        sql/test/subquery/Tests/subquery6.sql
        sql/test/subquery/Tests/subquery6.stable.err
        sql/test/subquery/Tests/subquery6.stable.out
        sql/test/sys-schema/Tests/utilities.stable.out
        sql/test/testdb/Tests/dump-nogeom.sql
        sql/test/testdb/Tests/dump-nogeom.stable.out
        sql/test/testdb/Tests/dump.sql
        sql/test/testdb/Tests/dump.timeout
        sql/test/testdb/Tests/load.timeout
        sql/test/wlcr/Tests/wlr01.stable.out
        sql/test/wlcr/Tests/wlr110.py
        sql/test/wlcr/Tests/wlr35.py
        testing/Mfilter.py
        testing/Mtest.py.in
        testing/malcheck.py
        testing/process.py
        tools/merovingian/client/Tests/All
        tools/merovingian/daemon/handlers.c
Branch: out2in
Log Message:

Merge with default.


diffs (truncated from 47464 to 300 lines):

diff --git a/.bumpversion.cfg b/.bumpversion.cfg
new file mode 100644
--- /dev/null
+++ b/.bumpversion.cfg
@@ -0,0 +1,34 @@
+[bumpversion]
+current_version = 11.38.0
+commit = False
+tag = False
+
+[bumpversion:file:configure.ag]
+
+[bumpversion:file:MonetDB.spec]
+search = %global version {current_version}
+replace = %global version {new_version}
+
+[bumpversion:file:NT/rules.msc]
+
+[bumpversion:file:NT/monetdb_config.h.in]
+
+[bumpversion:file:gdk/libbat.rc]
+parse = (?P<major>\d+),(?P<minor>\d+),(?P<patch>\d+)
+serialize = {major},{minor},{patch}
+
+[bumpversion:file:clients/odbc/winsetup/setup.rc]
+parse = (?P<major>\d+),(?P<minor>\d+),(?P<patch>\d+)
+serialize = {major},{minor},{patch}
+
+[bumpversion:file:clients/odbc/driver/driver.rc]
+parse = (?P<major>\d+),(?P<minor>\d+),(?P<patch>\d+)
+serialize = {major},{minor},{patch}
+
+[bumpversion:file:clients/mapilib/mapi.rc]
+parse = (?P<major>\d+),(?P<minor>\d+),(?P<patch>\d+)
+serialize = {major},{minor},{patch}
+
+[bumpversion:file:monetdb5/tools/libmonetdb5.rc]
+parse = (?P<major>\d+),(?P<minor>\d+),(?P<patch>\d+)
+serialize = {major},{minor},{patch}
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -766,3 +766,12 @@ 179977ed07cd8095f99a6a07968b8e9d1affa753
 6b76e1fa9b32421197acf26f63948c858e487d6a Jun2020_root
 03ea637c10b5217782acf5db261b4cd71a9afb25 Jun2020_1
 03ea637c10b5217782acf5db261b4cd71a9afb25 Jun2020_release
+0d51d6758f2b1f3f1804415545f8551a38da1848 Jun2020_3
+03ea637c10b5217782acf5db261b4cd71a9afb25 Jun2020_release
+0d51d6758f2b1f3f1804415545f8551a38da1848 Jun2020_release
+28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_5
+0d51d6758f2b1f3f1804415545f8551a38da1848 Jun2020_release
+28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_release
+80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_7
+28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_release
+80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_release
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -984,6 +984,17 @@ fi
 %postun -p /sbin/ldconfig
 
 %changelog
+* Fri May 29 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.7-20200529
+- Rebuilt.
+
+* Tue May 26 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.5-20200526
+- Rebuilt.
+- BZ#6864: (I)LIKE with multiple % doen't find matches
+
+* Mon May 18 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.3-20200518
+- Rebuilt.
+- BZ#6863: thash files not released upon drop table
+
 * Mon May 11 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511
 - Rebuilt.
 - BZ#6298: unexpectedly slow execution of SELECT length(fieldname)
@@ -1236,7 +1247,7 @@ fi
   column version.
 
 * Sat Feb 22 2020 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 
11.37.1-20200511
-- sql: Added SQL function sys.hot_snapshot() which can be used to write
+- sql: Added SQL procedure sys.hot_snapshot() which can be used to write
   a snapshot of the database to a tar file. For example,
   sys.hot_snapshot('/tmp/snapshot.tar'). If compression support is
   compiled in, snapshots can also be compressed ('/tmp/snapshot.tar.gz').
diff --git a/NT/rules.msc b/NT/rules.msc
--- a/NT/rules.msc
+++ b/NT/rules.msc
@@ -7,9 +7,6 @@
 # Copyright 1997 - July 2008 CWI, August 2008 - 2020 MonetDB B.V.
 
 VERSION=11.38.0
-#       ^^^^^^
-# Maintained via vertoo. Please don't modify by hand!
-# Contact monetdb-develop...@lists.sourceforge.net for details and/or 
assistance.
 
 !IFDEF MAKE_INCLUDEFILE
 !INCLUDE $(MAKE_INCLUDEFILE)
@@ -306,6 +303,11 @@ create_winconfig_conds_new_py:
 !ELSE
        $(ECHO) HAVE_LIBBZ2_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
 !ENDIF
+!IFDEF HAVE_LIBLZ4
+       $(ECHO) HAVE_LIBLZ4_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
+!ELSE
+       $(ECHO) HAVE_LIBLZ4_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
+!ENDIF
 !IFDEF HAVE_LIBLZMA
        $(ECHO) HAVE_LIBLZMA_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
 !ELSE
diff --git a/buildtools/conf/Maddlog b/buildtools/conf/Maddlog
--- a/buildtools/conf/Maddlog
+++ b/buildtools/conf/Maddlog
@@ -123,7 +123,7 @@ fi
 case "$CL" in
 '')
     d=.
-    while [ ! -f $d/vertoo.data -a ! -f $d/ChangeLog -a ! -f $d/ChangeLog.$tag 
]; do
+    while [ ! -f $d/.bumpversion.cfg -a ! -f $d/ChangeLog -a ! -f 
$d/ChangeLog.$tag ]; do
        if [ $d -ef / ]; then
            echo "$0: cannot find top directory of package" >&2
            exit 1
diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -7559,6 +7559,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "bit_noerror",  "pattern batcalc.bit_noerror(b:bat[:str], 
s:bat[:oid]):bat[:bit] ",     "CMDconvert_bit;",      "cast from str to bit 
with candidates list"     ]
 [ "batcalc",   "bit_noerror",  "pattern batcalc.bit_noerror(b:bat[:str], 
s:bat[:oid], r:bat[:bit]):bat[:bit] ",        "CMDconvert_bit;",      "cast 
from str to bit with candidates list"     ]
 [ "batcalc",   "blob", "command batcalc.blob(v:bat[:str]):bat[:blob] ",        
"batstr_2_blob;",       "cast to blob"  ]
+[ "batcalc",   "blob", "command batcalc.blob(v:bat[:str], 
r:bat[:bit]):bat[:blob] ",   "batstr_ce_2_blob;",    "cast to blob"  ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:bit]):bat[:bte] ",  
"CMDconvertsignal_bte;",        "cast from bit to bte, signal error on 
overflow"        ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:bit], 
r:bat[:bit]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from bit to 
bte, signal error on overflow"        ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:bit], 
s:bat[:oid]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from bit to 
bte with candidates list, signal error on overflow"   ]
@@ -7595,24 +7596,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], 
r:bat[:bit]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from str to 
bte, signal error on overflow"        ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], 
s:bat[:oid]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from str to 
bte with candidates list, signal error on overflow"   ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:bte] ",        "CMDconvertsignal_bte;",        "cast from str 
to bte with candidates list, signal error on overflow"   ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:bte] ",     "batbte_ce_dec2_bte;",  "cast decimal(bte) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batbte_ce_dec2dec_bte;",       "cast 
decimal(bte) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batbte_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte]):bat[:bte] ",  
"batbte_dec2_bte;",     "cast decimal(bte) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:bte] ",  "batbte_dec2dec_bte;",  "cast decimal(bte) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:bte], digits:int, 
scale:int):bat[:bte] ",   "batbte_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batdbl_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:dbl], digits:int, 
scale:int):bat[:bte] ",   "batdbl_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batflt_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:flt], digits:int, 
scale:int):bat[:bte] ",   "batflt_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:bte] ",     "batint_ce_dec2_bte;",  "cast decimal(int) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batint_ce_dec2dec_bte;",       "cast 
decimal(int) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batint_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int]):bat[:bte] ",  
"batint_dec2_bte;",     "cast decimal(int) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:bte] ",  "batint_dec2dec_bte;",  "cast decimal(int) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:int], digits:int, 
scale:int):bat[:bte] ",   "batint_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:bte] ",     "batlng_ce_dec2_bte;",  "cast decimal(lng) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batlng_ce_dec2dec_bte;",       "cast 
decimal(lng) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batlng_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng]):bat[:bte] ",  
"batlng_dec2_bte;",     "cast decimal(lng) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:bte] ",  "batlng_dec2dec_bte;",  "cast decimal(lng) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:lng], digits:int, 
scale:int):bat[:bte] ",   "batlng_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int, 
scale:int):bat[:bte] ",   "batnil_2dec_bte;",     "cast to dec(bte) and check 
for overflow"       ]
-[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int):bat[:bte] 
",      "batnil_2num_bte;",     "cast to bte and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batnil_ce_2dec_bte;",  "cast to 
dec(bte) and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:bte] ",     "batsht_ce_dec2_bte;",  "cast decimal(sht) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batsht_ce_dec2dec_bte;",       "cast 
decimal(sht) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batsht_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht]):bat[:bte] ",  
"batsht_dec2_bte;",     "cast decimal(sht) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:bte] ",  "batsht_dec2dec_bte;",  "cast decimal(sht) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:sht], digits:int, 
scale:int):bat[:bte] ",   "batsht_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int, 
scale:int):bat[:bte] ",   "batstr_2dec_bte;",     "cast to dec(bte) and check 
for overflow"       ]
-[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int):bat[:bte] 
",      "batstr_2num_bte;",     "cast to bte and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batstr_ce_2dec_bte;",  "cast to 
dec(bte) and check for overflow"       ]
 [ "batcalc",   "bte_noerror",  "pattern 
batcalc.bte_noerror(b:bat[:bit]):bat[:bte] ",  "CMDconvert_bte;",      "cast 
from bit to bte"  ]
 [ "batcalc",   "bte_noerror",  "pattern batcalc.bte_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:bte] ",     "CMDconvert_bte;",      "cast from bit to bte"  ]
 [ "batcalc",   "bte_noerror",  "pattern batcalc.bte_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:bte] ",     "CMDconvert_bte;",      "cast from bit to bte 
with candidates list"     ]
@@ -8119,13 +8134,14 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(v:str, b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:bte] ", "CMDbatCMP;",   "Return -1/0/1 if V </==/> B with 
candidates list"      ]
 [ "batcalc",   "date", "command batcalc.date(t:bat[:timestamp]):bat[:date] ",  
"MTIMEtimestamp_extract_date_bulk;",    ""      ]
 [ "batcalc",   "date", "command batcalc.date(v:bat[:oid]):bat[:date] ",        
"batnil_2_date;",       "cast to date"  ]
+[ "batcalc",   "date", "command batcalc.date(v:bat[:oid], 
r:bat[:bit]):bat[:date] ",   "batnil_ce_2_date;",    "cast to date"  ]
 [ "batcalc",   "date", "command batcalc.date(v:bat[:str]):bat[:date] ",        
"batstr_2_date;",       "cast to date"  ]
+[ "batcalc",   "date", "command batcalc.date(v:bat[:str], 
r:bat[:bit]):bat[:date] ",   "batstr_ce_2_date;",    "cast to date"  ]
 [ "batcalc",   "daytime",      "command 
batcalc.daytime(s:bat[:lng]):bat[:daytime] ",  
"MTIMEdaytime_fromseconds_bulk;",       ""      ]
 [ "batcalc",   "daytime",      "command 
batcalc.daytime(t:bat[:timestamp]):bat[:daytime] ",    
"MTIMEtimestamp_extract_daytime_bulk;", ""      ]
 [ "batcalc",   "daytime",      "command batcalc.daytime(v:bat[:daytime], 
digits:int):bat[:daytime] ",  "batdaytime_2time_daytime;",    "cast daytime to 
daytime and check for overflow"        ]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(v:bat[:oid]):bat[:daytime] ",  "batnil_2_daytime;",    "Cast to 
daytime"       ]
 [ "batcalc",   "daytime",      "command batcalc.daytime(v:bat[:oid], 
digits:int):bat[:daytime] ",      "batnil_2time_daytime;",        "cast to 
daytime and check for overflow"        ]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(v:bat[:str]):bat[:daytime] ",  "batstr_2_daytime;",    "Cast to 
daytime"       ]
+[ "batcalc",   "daytime",      "command batcalc.daytime(v:bat[:oid], 
digits:int, r:bat[:bit]):bat[:daytime] ", "batnil_ce_2time_daytime;",     "cast 
to daytime and check for overflow"        ]
 [ "batcalc",   "daytime",      "command batcalc.daytime(v:bat[:str], 
digits:int):bat[:daytime] ",      "batstr_2time_daytime;",        "cast to 
daytime and check for overflow"        ]
 [ "batcalc",   "daytime",      "command batcalc.daytime(v:bat[:str], 
digits:int, has_tz:int):bat[:daytime] ",  "batstr_2time_daytimetz;",      "cast 
to daytime and check for overflow"        ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:bit]):bat[:dbl] ",  
"CMDconvertsignal_dbl;",        "cast from bit to dbl, signal error on 
overflow"        ]
@@ -8164,15 +8180,27 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], 
r:bat[:bit]):bat[:dbl] ",     "CMDconvertsignal_dbl;",        "cast from str to 
dbl, signal error on overflow"        ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], 
s:bat[:oid]):bat[:dbl] ",     "CMDconvertsignal_dbl;",        "cast from str to 
dbl with candidates list, signal error on overflow"   ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:dbl] ",        "CMDconvertsignal_dbl;",        "cast from str 
to dbl with candidates list, signal error on overflow"   ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:dbl] ",     "batbte_ce_dec2_dbl;",  "cast decimal(bte) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batbte_ce_dec2dec_dbl;",       "cast 
decimal(bte) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batbte_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte]):bat[:dbl] ",  
"batbte_dec2_dbl;",     "cast decimal(bte) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:dbl] ",  "batbte_dec2dec_dbl;",  "cast decimal(bte) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:bte], digits:int, 
scale:int):bat[:dbl] ",   "batbte_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:dbl] ",     "batint_ce_dec2_dbl;",  "cast decimal(int) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batint_ce_dec2dec_dbl;",       "cast 
decimal(int) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batint_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int]):bat[:dbl] ",  
"batint_dec2_dbl;",     "cast decimal(int) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:dbl] ",  "batint_dec2dec_dbl;",  "cast decimal(int) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:int], digits:int, 
scale:int):bat[:dbl] ",   "batint_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:dbl] ",     "batlng_ce_dec2_dbl;",  "cast decimal(lng) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batlng_ce_dec2dec_dbl;",       "cast 
decimal(lng) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batlng_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng]):bat[:dbl] ",  
"batlng_dec2_dbl;",     "cast decimal(lng) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:dbl] ",  "batlng_dec2dec_dbl;",  "cast decimal(lng) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:lng], digits:int, 
scale:int):bat[:dbl] ",   "batlng_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:dbl] ",     "batsht_ce_dec2_dbl;",  "cast decimal(sht) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batsht_ce_dec2dec_dbl;",       "cast 
decimal(sht) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batsht_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht]):bat[:dbl] ",  
"batsht_dec2_dbl;",     "cast decimal(sht) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:dbl] ",  "batsht_dec2dec_dbl;",  "cast decimal(sht) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:sht], digits:int, 
scale:int):bat[:dbl] ",   "batsht_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
@@ -9004,15 +9032,27 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], 
r:bat[:bit]):bat[:flt] ",     "CMDconvertsignal_flt;",        "cast from str to 
flt, signal error on overflow"        ]
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], 
s:bat[:oid]):bat[:flt] ",     "CMDconvertsignal_flt;",        "cast from str to 
flt with candidates list, signal error on overflow"   ]
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:flt] ",        "CMDconvertsignal_flt;",        "cast from str 
to flt with candidates list, signal error on overflow"   ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:flt] ",     "batbte_ce_dec2_flt;",  "cast decimal(bte) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batbte_ce_dec2dec_flt;",       "cast 
decimal(bte) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batbte_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte]):bat[:flt] ",  
"batbte_dec2_flt;",     "cast decimal(bte) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:flt] ",  "batbte_dec2dec_flt;",  "cast decimal(bte) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:bte], digits:int, 
scale:int):bat[:flt] ",   "batbte_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:flt] ",     "batint_ce_dec2_flt;",  "cast decimal(int) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batint_ce_dec2dec_flt;",       "cast 
decimal(int) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batint_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int]):bat[:flt] ",  
"batint_dec2_flt;",     "cast decimal(int) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:flt] ",  "batint_dec2dec_flt;",  "cast decimal(int) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:int], digits:int, 
scale:int):bat[:flt] ",   "batint_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:flt] ",     "batlng_ce_dec2_flt;",  "cast decimal(lng) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batlng_ce_dec2dec_flt;",       "cast 
decimal(lng) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batlng_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng]):bat[:flt] ",  
"batlng_dec2_flt;",     "cast decimal(lng) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:flt] ",  "batlng_dec2dec_flt;",  "cast decimal(lng) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:lng], digits:int, 
scale:int):bat[:flt] ",   "batlng_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:flt] ",     "batsht_ce_dec2_flt;",  "cast decimal(sht) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batsht_ce_dec2dec_flt;",       "cast 
decimal(sht) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batsht_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht]):bat[:flt] ",  
"batsht_dec2_flt;",     "cast decimal(sht) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:flt] ",  "batsht_dec2dec_flt;",  "cast decimal(sht) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:sht], digits:int, 
scale:int):bat[:flt] ",   "batsht_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
@@ -9061,8 +9101,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "hash", "command batcalc.hash(b:bat[:lng]):bat[:lng] ", 
"MKEYbathash;", ""      ]
 [ "batcalc",   "hash", "command batcalc.hash(b:bat[:oid]):bat[:lng] ", 
"MKEYbathash;", ""      ]
 [ "batcalc",   "hash", "command batcalc.hash(b:bat[:sht]):bat[:lng] ", 
"MKEYbathash;", ""      ]
-[ "batcalc",   "identity",     "command 
batcalc.identity(b:bat[:any_2]):bat[:oid] ",   "BATSQLidentity;",      "Returns 
the unique row identitfiers."  ]
-[ "batcalc",   "identity",     "pattern batcalc.identity(b:bat[:any_2], s:oid) 
(resb:bat[:oid], ns:oid) ",     "PBATSQLidentity;",     "Returns the unique row 
identitfiers."  ]
+[ "batcalc",   "identity",     "command 
batcalc.identity(b:bat[:any]):bat[:oid] ",     "BATSQLidentity;",      "Returns 
the unique row identitfiers."  ]
+[ "batcalc",   "identity",     "pattern batcalc.identity(b:bat[:any], s:oid) 
(resb:bat[:oid], ns:oid) ",       "PBATSQLidentity;",     "Returns the unique 
row identitfiers."  ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(b:bat[:bit], 
b1:bat[:any_1], b2:bat[:any_1]):bat[:any_1] ", "CMDifthen;",   "If-then-else 
operation to assemble a conditional result"       ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(b:bat[:bit], 
b1:bat[:any_1], v2:any_1):bat[:any_1] ",       "CMDifthen;",   "If-then-else 
operation to assemble a conditional result"       ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(b:bat[:bit], 
v1:any_1, b2:bat[:any_1]):bat[:any_1] ",       "CMDifthen;",   "If-then-else 
operation to assemble a conditional result"       ]
@@ -9109,24 +9149,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], 
r:bat[:bit]):bat[:int] ",     "CMDconvertsignal_int;",        "cast from str to 
int, signal error on overflow"        ]
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], 
s:bat[:oid]):bat[:int] ",     "CMDconvertsignal_int;",        "cast from str to 
int with candidates list, signal error on overflow"   ]
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:int] ",        "CMDconvertsignal_int;",        "cast from str 
to int with candidates list, signal error on overflow"   ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:int] ",     "batbte_ce_dec2_int;",  "cast decimal(bte) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batbte_ce_dec2dec_int;",       "cast 
decimal(bte) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batbte_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte]):bat[:int] ",  
"batbte_dec2_int;",     "cast decimal(bte) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:int] ",  "batbte_dec2dec_int;",  "cast decimal(bte) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:bte], digits:int, 
scale:int):bat[:int] ",   "batbte_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batdbl_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:dbl], digits:int, 
scale:int):bat[:int] ",   "batdbl_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batflt_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:flt], digits:int, 
scale:int):bat[:int] ",   "batflt_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:int] ",     "batint_ce_dec2_int;",  "cast decimal(int) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batint_ce_dec2dec_int;",       "cast 
decimal(int) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batint_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int]):bat[:int] ",  
"batint_dec2_int;",     "cast decimal(int) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:int] ",  "batint_dec2dec_int;",  "cast decimal(int) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:int], digits:int, 
scale:int):bat[:int] ",   "batint_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:int] ",     "batlng_ce_dec2_int;",  "cast decimal(lng) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batlng_ce_dec2dec_int;",       "cast 
decimal(lng) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batlng_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng]):bat[:int] ",  
"batlng_dec2_int;",     "cast decimal(lng) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:int] ",  "batlng_dec2dec_int;",  "cast decimal(lng) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:lng], digits:int, 
scale:int):bat[:int] ",   "batlng_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int, 
scale:int):bat[:int] ",   "batnil_2dec_int;",     "cast to dec(int) and check 
for overflow"       ]
-[ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int):bat[:int] 
",      "batnil_2num_int;",     "cast to int and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batnil_ce_2dec_int;",  "cast to 
dec(int) and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:int] ",     "batsht_ce_dec2_int;",  "cast decimal(sht) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batsht_ce_dec2dec_int;",       "cast 
decimal(sht) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batsht_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht]):bat[:int] ",  
"batsht_dec2_int;",     "cast decimal(sht) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:int] ",  "batsht_dec2dec_int;",  "cast decimal(sht) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:sht], digits:int, 
scale:int):bat[:int] ",   "batsht_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int, 
scale:int):bat[:int] ",   "batstr_2dec_int;",     "cast to dec(int) and check 
for overflow"       ]
-[ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int):bat[:int] 
",      "batstr_2num_int;",     "cast to int and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batstr_ce_2dec_int;",  "cast to 
dec(int) and check for overflow"       ]
 [ "batcalc",   "int_noerror",  "pattern 
batcalc.int_noerror(b:bat[:bit]):bat[:int] ",  "CMDconvert_int;",      "cast 
from bit to int"  ]
 [ "batcalc",   "int_noerror",  "pattern batcalc.int_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:int] ",     "CMDconvert_int;",      "cast from bit to int"  ]
 [ "batcalc",   "int_noerror",  "pattern batcalc.int_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:int] ",     "CMDconvert_int;",      "cast from bit to int 
with candidates list"     ]
@@ -9231,24 +9285,38 @@ stdout of test 'MAL-signatures` in direc
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to