Changeset: e6284d922f04 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e6284d922f04
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/mclient-uri.stable.out
        clients/Tests/mclient-uri.stable.out.Windows
        gdk/gdk_calc.c
        geom/sql/pg_regression/Tests/dump.stable.out
        monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
        monetdb5/mal/Tests/tst1506.stable.out
        monetdb5/modules/mal/calc.c
        monetdb5/optimizer/opt_remap.c
        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/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.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_round_impl.h
        sql/backends/monet5/sql_statement.c
        sql/backends/monet5/sql_statement.h
        sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
        sql/server/rel_optimizer.c
        sql/server/rel_select.c
        sql/server/rel_unnest.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-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.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/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/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-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/statistics_nils_not_eq_zero.Bug-6331.stable.out
        sql/test/BugTracker-2017/Tests/str2decimal.Bug-6206.stable.out
        
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/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/prepare-types.Bug-6724.stable.out
        
sql/test/BugTracker-2019/Tests/set-schema-mclient-msg.Bug-6754.stable.out
        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/Skyserver/Tests/Skyserver.stable.out
        sql/test/Tests/50ways.stable.out
        sql/test/Tests/decimal2.stable.out
        sql/test/Tests/ifexists.stable.out
        sql/test/Tests/keys.stable.out
        sql/test/Tests/session_vars.stable.out
        sql/test/Tests/setoptimizer.stable.out
        sql/test/Tests/timezone.stable.out
        sql/test/Tests/trace.stable.out
        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/analytics/Tests/analytics11.stable.out
        sql/test/bugs/Tests/arith-bug-sf-949228.stable.out
        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.stable.out
        sql/test/bugs/Tests/cast_bool2int-bug-sf-951800.stable.out
        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_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.stable.out
        sql/test/bugs/Tests/default_with_cast.SF-1334486.stable.out
        sql/test/bugs/Tests/escape_quote-bug-sf-1006469.stable.out
        sql/test/bugs/Tests/extract_interval_bug-sf-1274088.stable.out
        sql/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.stable.out
        sql/test/bugs/Tests/floor-bug-sf-967066.stable.out
        sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out
        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/interval_convert_bugs-sf-1274077-1274085.stable.out
        
sql/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.stable.out
        sql/test/bugs/Tests/interval_parse_bug-sf-1263967.stable.out
        sql/test/bugs/Tests/not.stable.out
        sql/test/bugs/Tests/polymorphism.stable.out
        sql/test/bugs/Tests/seconds2timestamp.stable.out
        
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/subselect_single_value-bug-sf-962099.stable.out
        sql/test/bugs/Tests/trimtest-bug-sf-1023588.stable.out
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out
        sql/test/bugs/Tests/zero_or_one_bug.stable.out
        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/mapi/Tests/perl_dbi.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.stable.out
        sql/test/miscellaneous/Tests/deallocate.stable.out
        sql/test/miscellaneous/Tests/declared_tables.stable.out
        sql/test/miscellaneous/Tests/groupby_error.stable.out
        sql/test/miscellaneous/Tests/groupby_expressions.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.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.stable.out
        sql/test/subquery/Tests/subquery5.stable.out
        sql/test/subquery/Tests/subquery6.stable.err
        sql/test/subquery/Tests/subquery6.stable.out
        sql/test/sys-schema/Tests/utilities.stable.out
        sql/test/wlcr/Tests/wlr01.stable.out
Branch: default
Log Message:

Merged with Jun2020


diffs (truncated from 24923 to 300 lines):

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"   ]
@@ -8119,13 +8120,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"        ]
@@ -10625,6 +10627,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "str",  "pattern batcalc.str(b:bat[:any], 
s:bat[:oid]):bat[:str] ",     "CMDconvertsignal_str;",        "cast from any to 
str with candidates list, signal error on overflow"   ]
 [ "batcalc",   "str",  "pattern batcalc.str(b:bat[:any], s:bat[:oid], 
r:bat[:bit]):bat[:str] ",        "CMDconvertsignal_str;",        "cast from any 
to str with candidates list, signal error on overflow"   ]
 [ "batcalc",   "str",  "pattern batcalc.str(eclass:int, d1:int, s1:int, 
has_tz:int, v:bat[:any_1], digits:int):bat[:str] ",    "SQLbatstr_cast;",      
"cast to string and check for overflow" ]
+[ "batcalc",   "str",  "pattern batcalc.str(eclass:int, d1:int, s1:int, 
has_tz:int, v:bat[:any_1], digits:int, r:bat[:bit]):bat[:str] ",       
"SQLbatstr_cast;",      "cast to string and check for overflow" ]
 [ "batcalc",   "str_noerror",  "pattern 
batcalc.str_noerror(b:bat[:any]):bat[:str] ",  "CMDconvert_str;",      "cast 
from any to str"  ]
 [ "batcalc",   "str_noerror",  "pattern batcalc.str_noerror(b:bat[:any], 
r:bat[:bit]):bat[:str] ",     "CMDconvert_str;",      "cast from any to str"  ]
 [ "batcalc",   "str_noerror",  "pattern batcalc.str_noerror(b:bat[:any], 
s:bat[:oid]):bat[:str] ",     "CMDconvert_str;",      "cast from any to str 
with candidates list"     ]
@@ -10849,9 +10852,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "timestamp",    "command 
batcalc.timestamp(d:bat[:date]):bat[:timestamp] ",     
"MTIMEtimestamp_fromdate_bulk;",        ""      ]
 [ "batcalc",   "timestamp",    "command 
batcalc.timestamp(msecs:bat[:lng]):bat[:timestamp] ",  
"MTIMEtimestamp_frommsec_bulk;",        ""      ]
 [ "batcalc",   "timestamp",    "command 
batcalc.timestamp(secs:bat[:int]):bat[:timestamp] ",   
"MTIMEtimestamp_fromsecond_bulk;",      ""      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(v:bat[:oid]):bat[:timestamp] ",      "batnil_2_timestamp;",  
"Cast to timestamp"     ]
 [ "batcalc",   "timestamp",    "command batcalc.timestamp(v:bat[:oid], 
digits:int):bat[:timestamp] ",  "batnil_2time_timestamp;",      "cast to 
timestamp and check for overflow"      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(v:bat[:str]):bat[:timestamp] ",      "batstr_2_timestamp;",  
"Cast to timestamp"     ]
+[ "batcalc",   "timestamp",    "command batcalc.timestamp(v:bat[:oid], 
digits:int, r:bat[:BAT]):bat[:timestamp] ",     "batnil_ce_2time_timestamp;",   
"cast to timestamp and check for overflow"      ]
 [ "batcalc",   "timestamp",    "command batcalc.timestamp(v:bat[:str], 
digits:int):bat[:timestamp] ",  "batstr_2time_timestamp;",      "cast to 
timestamp and check for overflow"      ]
 [ "batcalc",   "timestamp",    "command batcalc.timestamp(v:bat[:str], 
digits:int, has_tz:int):bat[:timestamp] ",      "batstr_2time_timestamptz;",    
"cast to timestamp and check for overflow"      ]
 [ "batcalc",   "timestamp",    "command batcalc.timestamp(v:bat[:timestamp], 
digits:int):bat[:timestamp] ",    "battimestamp_2time_timestamp;",        "cast 
timestamp to timestamp and check for overflow"    ]
@@ -12517,12 +12519,10 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "bte",  "command calc.bte(s1:int, v:lng, d2:int, s2:int):bte ", 
"lng_dec2dec_bte;",     "cast decimal(lng) to decimal(bte) and check for 
overflow"      ]
 [ "calc",      "bte",  "command calc.bte(v:lng, digits:int, scale:int):bte ",  
"lng_num2dec_bte;",     "cast number to decimal(bte) and check for overflow"    
]
 [ "calc",      "bte",  "command calc.bte(v:void, digits:int, scale:int):bte ", 
"nil_2dec_bte;",        "cast to dec(bte) and check for overflow"       ]
-[ "calc",      "bte",  "command calc.bte(v:void, digits:int):bte ",    
"nil_2num_bte;",        "cast to bte and check for overflow"    ]
 [ "calc",      "bte",  "command calc.bte(s1:int, v:sht):bte ", 
"sht_dec2_bte;",        "cast decimal(sht) to bte and check for overflow"       
]
 [ "calc",      "bte",  "command calc.bte(s1:int, v:sht, d2:int, s2:int):bte ", 
"sht_dec2dec_bte;",     "cast decimal(sht) to decimal(bte) and check for 
overflow"      ]
 [ "calc",      "bte",  "command calc.bte(v:sht, digits:int, scale:int):bte ",  
"sht_num2dec_bte;",     "cast number to decimal(bte) and check for overflow"    
]
 [ "calc",      "bte",  "command calc.bte(v:str, digits:int, scale:int):bte ",  
"str_2dec_bte;",        "cast to dec(bte) and check for overflow"       ]
-[ "calc",      "bte",  "command calc.bte(v:str, digits:int):bte ",     
"str_2num_bte;",        "cast to bte and check for overflow"    ]
 [ "calc",      "cmp",  "pattern calc.cmp(v1:bit, v2:bit):bte ",        
"CMDvarCMP;",   "Return -1/0/1 if V1 </==/> V2" ]
 [ "calc",      "cmp",  "pattern calc.cmp(v1:bte, v2:bte):bte ",        
"CMDvarCMP;",   "Return -1/0/1 if V1 </==/> V2" ]
 [ "calc",      "cmp",  "pattern calc.cmp(v1:bte, v2:dbl):bte ",        
"CMDvarCMP;",   "Return -1/0/1 if V1 </==/> V2" ]
@@ -12572,10 +12572,8 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "daytime",      "command calc.daytime(s:str):daytime ", 
"MTIMEdaytime_fromstr;",        ""      ]
 [ "calc",      "daytime",      "command calc.daytime(t:timestamp):daytime ",   
"MTIMEtimestamp_extract_daytime;",      ""      ]
 [ "calc",      "daytime",      "command calc.daytime(v:daytime, 
digits:int):daytime ", "daytime_2time_daytime;",       "cast daytime to daytime 
and check for overflow"        ]
-[ "calc",      "daytime",      "command calc.daytime(v:void):daytime ",        
"nil_2_daytime;",       "Cast to daytime"       ]
 [ "calc",      "daytime",      "command calc.daytime(v:void, 
digits:int):daytime ",    "nil_2time_daytime;",   "cast to daytime and check 
for overflow"        ]
 [ "calc",      "daytime",      "command calc.daytime(v:lng, d:int):daytime ",  
"second_interval_2_daytime;",   "cast second_interval to a daytime and check 
for overflow"      ]
-[ "calc",      "daytime",      "command calc.daytime(v:str):daytime ", 
"str_2_daytime;",       "Cast to daytime"       ]
 [ "calc",      "daytime",      "command calc.daytime(v:str, 
digits:int):daytime ",     "str_2time_daytime;",   "cast to daytime and check 
for overflow"        ]
 [ "calc",      "daytime",      "command calc.daytime(v:str, digits:int, 
has_tz:int):daytime ", "str_2time_daytimetz;", "cast to daytime and check for 
overflow"        ]
 [ "calc",      "daytime",      "command calc.daytime(v:timestamp, 
d:int):daytime ",    "timestamp_2_daytime;", "cast timestamp to a daytime and 
check for overflow"    ]
@@ -12787,12 +12785,10 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "int",  "command calc.int(s1:int, v:lng, d2:int, s2:int):int ", 
"lng_dec2dec_int;",     "cast decimal(lng) to decimal(int) and check for 
overflow"      ]
 [ "calc",      "int",  "command calc.int(v:lng, digits:int, scale:int):int ",  
"lng_num2dec_int;",     "cast number to decimal(int) and check for overflow"    
]
 [ "calc",      "int",  "command calc.int(v:void, digits:int, scale:int):int ", 
"nil_2dec_int;",        "cast to dec(int) and check for overflow"       ]
-[ "calc",      "int",  "command calc.int(v:void, digits:int):int ",    
"nil_2num_int;",        "cast to int and check for overflow"    ]
 [ "calc",      "int",  "command calc.int(s1:int, v:sht):int ", 
"sht_dec2_int;",        "cast decimal(sht) to int and check for overflow"       
]
 [ "calc",      "int",  "command calc.int(s1:int, v:sht, d2:int, s2:int):int ", 
"sht_dec2dec_int;",     "cast decimal(sht) to decimal(int) and check for 
overflow"      ]
 [ "calc",      "int",  "command calc.int(v:sht, digits:int, scale:int):int ",  
"sht_num2dec_int;",     "cast number to decimal(int) and check for overflow"    
]
 [ "calc",      "int",  "command calc.int(v:str, digits:int, scale:int):int ",  
"str_2dec_int;",        "cast to dec(int) and check for overflow"       ]
-[ "calc",      "int",  "command calc.int(v:str, digits:int):int ",     
"str_2num_int;",        "cast to int and check for overflow"    ]
 [ "calc",      "isnil",        "pattern calc.isnil(v:any):bit ",       
"CMDvarISNIL;", "Unary check for nil of V"      ]
 [ "calc",      "isnotnil",     "pattern calc.isnotnil(v:any):bit ",    
"CMDvarISNOTNIL;",      "Unary check for notnil of V"   ]
 [ "calc",      "iszero",       "pattern calc.iszero(v:bte):bit ",      
"CMDvarISZERO;",        "Unary check for zero of V"     ]
@@ -12826,12 +12822,10 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "lng",  "command calc.lng(s1:int, v:lng, d2:int, s2:int):lng ", 
"lng_dec2dec_lng;",     "cast decimal(lng) to decimal(lng) and check for 
overflow"      ]
 [ "calc",      "lng",  "command calc.lng(v:lng, digits:int, scale:int):lng ",  
"lng_num2dec_lng;",     "cast number to decimal(lng) and check for overflow"    
]
 [ "calc",      "lng",  "command calc.lng(v:void, digits:int, scale:int):lng ", 
"nil_2dec_lng;",        "cast to dec(lng) and check for overflow"       ]
-[ "calc",      "lng",  "command calc.lng(v:void, digits:int):lng ",    
"nil_2num_lng;",        "cast to lng and check for overflow"    ]
 [ "calc",      "lng",  "command calc.lng(s1:int, v:sht):lng ", 
"sht_dec2_lng;",        "cast decimal(sht) to lng and check for overflow"       
]
 [ "calc",      "lng",  "command calc.lng(s1:int, v:sht, d2:int, s2:int):lng ", 
"sht_dec2dec_lng;",     "cast decimal(sht) to decimal(lng) and check for 
overflow"      ]
 [ "calc",      "lng",  "command calc.lng(v:sht, digits:int, scale:int):lng ",  
"sht_num2dec_lng;",     "cast number to decimal(lng) and check for overflow"    
]
 [ "calc",      "lng",  "command calc.lng(v:str, digits:int, scale:int):lng ",  
"str_2dec_lng;",        "cast to dec(lng) and check for overflow"       ]
-[ "calc",      "lng",  "command calc.lng(v:str, digits:int):lng ",     
"str_2num_lng;",        "cast to lng and check for overflow"    ]
 [ "calc",      "lsh_noerror",  "pattern calc.lsh_noerror(v1:bte, v2:bte):bte 
",        "CMDvarLSH;",   "Return V1 << V2, out of range second operand results 
in NIL value"     ]
 [ "calc",      "lsh_noerror",  "pattern calc.lsh_noerror(v1:bte, v2:int):bte 
",        "CMDvarLSH;",   "Return V1 << V2, out of range second operand results 
in NIL value"     ]
 [ "calc",      "lsh_noerror",  "pattern calc.lsh_noerror(v1:bte, v2:lng):bte 
",        "CMDvarLSH;",   "Return V1 << V2, out of range second operand results 
in NIL value"     ]
@@ -13036,12 +13030,10 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "sht",  "command calc.sht(s1:int, v:lng, d2:int, s2:int):sht ", 
"lng_dec2dec_sht;",     "cast decimal(lng) to decimal(sht) and check for 
overflow"      ]
 [ "calc",      "sht",  "command calc.sht(v:lng, digits:int, scale:int):sht ",  
"lng_num2dec_sht;",     "cast number to decimal(sht) and check for overflow"    
]
 [ "calc",      "sht",  "command calc.sht(v:void, digits:int, scale:int):sht ", 
"nil_2dec_sht;",        "cast to dec(sht) and check for overflow"       ]
-[ "calc",      "sht",  "command calc.sht(v:void, digits:int):sht ",    
"nil_2num_sht;",        "cast to sht and check for overflow"    ]
 [ "calc",      "sht",  "command calc.sht(s1:int, v:sht):sht ", 
"sht_dec2_sht;",        "cast decimal(sht) to sht and check for overflow"       
]
 [ "calc",      "sht",  "command calc.sht(s1:int, v:sht, d2:int, s2:int):sht ", 
"sht_dec2dec_sht;",     "cast decimal(sht) to decimal(sht) and check for 
overflow"      ]
 [ "calc",      "sht",  "command calc.sht(v:sht, digits:int, scale:int):sht ",  
"sht_num2dec_sht;",     "cast number to decimal(sht) and check for overflow"    
]
 [ "calc",      "sht",  "command calc.sht(v:str, digits:int, scale:int):sht ",  
"str_2dec_sht;",        "cast to dec(sht) and check for overflow"       ]
-[ "calc",      "sht",  "command calc.sht(v:str, digits:int):sht ",     
"str_2num_sht;",        "cast to sht and check for overflow"    ]
 [ "calc",      "sign", "pattern calc.sign(v:bte):bte ",        "CMDvarSIGN;",  
"Unary sign (-1,0,1) of V"      ]
 [ "calc",      "sign", "pattern calc.sign(v:dbl):bte ",        "CMDvarSIGN;",  
"Unary sign (-1,0,1) of V"      ]
 [ "calc",      "sign", "pattern calc.sign(v:flt):bte ",        "CMDvarSIGN;",  
"Unary sign (-1,0,1) of V"      ]
@@ -13098,9 +13090,7 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "timestamp",    "command calc.timestamp(s:str):timestamp ",     
"MTIMEtimestamp_fromstr;",      ""      ]
 [ "calc",      "timestamp",    "command calc.timestamp(t:timestamp):timestamp 
",       "MTIMEtimestamp_timestamp;",    ""      ]
 [ "calc",      "timestamp",    "command calc.timestamp(v:date, 
d:int):timestamp ",     "date_2_timestamp;",    "cast date to a timestamp and 
check for overflow"       ]
-[ "calc",      "timestamp",    "command calc.timestamp(v:void):timestamp ",    
"nil_2_timestamp;",     "Cast to timestamp"     ]
 [ "calc",      "timestamp",    "command calc.timestamp(v:void, 
digits:int):timestamp ",        "nil_2time_timestamp;", "cast to timestamp and 
check for overflow"      ]
-[ "calc",      "timestamp",    "command calc.timestamp(v:str):timestamp ",     
"str_2_timestamp;",     "Cast to timestamp"     ]
 [ "calc",      "timestamp",    "command calc.timestamp(v:str, 
digits:int):timestamp ", "str_2time_timestamp;", "cast to timestamp and check 
for overflow"      ]
 [ "calc",      "timestamp",    "command calc.timestamp(v:str, digits:int, 
has_tz:int):timestamp ",     "str_2time_timestamptz;",       "cast to timestamp 
and check for overflow"      ]
 [ "calc",      "timestamp",    "command calc.timestamp(v:timestamp, 
digits:int):timestamp ",   "timestamp_2time_timestamp;",   "cast timestamp to 
timestamp and check for overflow"    ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -10860,6 +10860,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"   ]
@@ -10900,27 +10901,44 @@ 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[:hge], 
r:bat[:bit]):bat[:bte] ",     "bathge_ce_dec2_bte;",  "cast decimal(hge) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:hge], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "bathge_ce_dec2dec_bte;",       "cast 
decimal(hge) to decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:hge]):bat[:bte] ",  
"bathge_dec2_bte;",     "cast decimal(hge) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:hge], d2:int, 
s2:int):bat[:bte] ",  "bathge_dec2dec_bte;",  "cast decimal(hge) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:hge], digits:int, 
scale:int):bat[:bte] ",   "bathge_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:hge], digits:int, 
scale:int):bat[:bte] ",   "bathge_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"     ]
@@ -11587,13 +11605,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"        ]
@@ -11636,18 +11655,33 @@ 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[:hge], 
r:bat[:bit]):bat[:dbl] ",     "bathge_ce_dec2_dbl;",  "cast decimal(hge) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:hge], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "bathge_ce_dec2dec_dbl;",       "cast 
decimal(hge) to decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:hge]):bat[:dbl] ",  
"bathge_dec2_dbl;",     "cast decimal(hge) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:hge], d2:int, 
s2:int):bat[:dbl] ",  "bathge_dec2dec_dbl;",  "cast decimal(hge) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:hge], digits:int, 
scale:int):bat[:dbl] ",   "bathge_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:hge], digits:int, 
scale:int):bat[:dbl] ",   "bathge_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"    ]
@@ -12907,18 +12941,33 @@ 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[:hge], 
r:bat[:bit]):bat[:flt] ",     "bathge_ce_dec2_flt;",  "cast decimal(hge) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:hge], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "bathge_ce_dec2dec_flt;",       "cast 
decimal(hge) to decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:hge]):bat[:flt] ",  
"bathge_dec2_flt;",     "cast decimal(hge) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:hge], d2:int, 
s2:int):bat[:flt] ",  "bathge_dec2dec_flt;",  "cast decimal(hge) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:hge], digits:int, 
scale:int):bat[:flt] ",   "bathge_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:hge], digits:int, 
scale:int):bat[:flt] ",   "bathge_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"    ]
@@ -13012,27 +13061,44 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "hge",  "pattern batcalc.hge(b:bat[:str], 
r:bat[:bit]):bat[:hge] ",     "CMDconvertsignal_hge;",        "cast from str to 
hge, signal error on overflow"        ]
 [ "batcalc",   "hge",  "pattern batcalc.hge(b:bat[:str], 
s:bat[:oid]):bat[:hge] ",     "CMDconvertsignal_hge;",        "cast from str to 
hge with candidates list, signal error on overflow"   ]
 [ "batcalc",   "hge",  "pattern batcalc.hge(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:hge] ",        "CMDconvertsignal_hge;",        "cast from str 
to hge with candidates list, signal error on overflow"   ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:hge] ",     "batbte_ce_dec2_hge;",  "cast decimal(bte) to hge 
and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:hge] ",     "batbte_ce_dec2dec_hge;",       "cast 
decimal(bte) to decimal(hge) and check for overflow"      ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "batbte_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:bte]):bat[:hge] ",  
"batbte_dec2_hge;",     "cast decimal(bte) to hge and check for overflow"       
]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:hge] ",  "batbte_dec2dec_hge;",  "cast decimal(bte) to 
decimal(hge) and check for overflow"      ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:bte], digits:int, 
scale:int):bat[:hge] ",   "batbte_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "batdbl_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:dbl], digits:int, 
scale:int):bat[:hge] ",   "batdbl_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "batflt_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:flt], digits:int, 
scale:int):bat[:hge] ",   "batflt_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:hge], 
r:bat[:bit]):bat[:hge] ",     "bathge_ce_dec2_hge;",  "cast decimal(hge) to hge 
and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:hge], d2:int, 
s2:int, r:bat[:bit]):bat[:hge] ",     "bathge_ce_dec2dec_hge;",       "cast 
decimal(hge) to decimal(hge) and check for overflow"      ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:hge], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "bathge_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:hge]):bat[:hge] ",  
"bathge_dec2_hge;",     "cast decimal(hge) to hge and check for overflow"       
]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:hge], d2:int, 
s2:int):bat[:hge] ",  "bathge_dec2dec_hge;",  "cast decimal(hge) to 
decimal(hge) and check for overflow"      ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:hge], digits:int, 
scale:int):bat[:hge] ",   "bathge_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:hge] ",     "batint_ce_dec2_hge;",  "cast decimal(int) to hge 
and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:hge] ",     "batint_ce_dec2dec_hge;",       "cast 
decimal(int) to decimal(hge) and check for overflow"      ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "batint_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:int]):bat[:hge] ",  
"batint_dec2_hge;",     "cast decimal(int) to hge and check for overflow"       
]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:hge] ",  "batint_dec2dec_hge;",  "cast decimal(int) to 
decimal(hge) and check for overflow"      ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:int], digits:int, 
scale:int):bat[:hge] ",   "batint_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:hge] ",     "batlng_ce_dec2_hge;",  "cast decimal(lng) to hge 
and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:hge] ",     "batlng_ce_dec2dec_hge;",       "cast 
decimal(lng) to decimal(hge) and check for overflow"      ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",      "batlng_ce_num2dec_hge;",       "cast 
number to decimal(hge) and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:lng]):bat[:hge] ",  
"batlng_dec2_hge;",     "cast decimal(lng) to hge and check for overflow"       
]
 [ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:hge] ",  "batlng_dec2dec_hge;",  "cast decimal(lng) to 
decimal(hge) and check for overflow"      ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:lng], digits:int, 
scale:int):bat[:hge] ",   "batlng_num2dec_hge;",  "cast number to decimal(hge) 
and check for overflow"    ]
 [ "batcalc",   "hge",  "command batcalc.hge(v:bat[:void], digits:int, 
scale:int):bat[:hge] ",  "batnil_2dec_hge;",     "cast to dec(hge) and check 
for overflow"       ]
-[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:void], 
digits:int):bat[:hge] ",     "batnil_2num_hge;",     "cast to hge and check for 
overflow"    ]
+[ "batcalc",   "hge",  "command batcalc.hge(v:bat[:void], digits:int, 
scale:int, r:bat[:bit]):bat[:hge] ",     "batnil_ce_2dec_hge;",  "cast to 
dec(hge) and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:hge] ",     "batsht_ce_dec2_hge;",  "cast decimal(sht) to hge 
and check for overflow"       ]
+[ "batcalc",   "hge",  "command batcalc.hge(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:hge] ",     "batsht_ce_dec2dec_hge;",       "cast 
decimal(sht) to decimal(hge) and check for overflow"      ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to