Changeset: cb8338836354 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cb8338836354
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_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: Jun2020
Log Message:

exceptional big change on release(d) branch

This fixes issues with conditional execution (think division by zero)

Important cleanup
        moved all this into the rel2bin layer, ie no hacks needed for
        null handing, or strange complex tree walks in the optimizer

one implication is that the ifthenelse no handles condition bit_nil as false, ie
        is merges the input based on the condition being true or (false/nil).


diffs (truncated from 24680 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