Changeset: 76a08453400a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76a08453400a
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
        
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
        sql/test/SQLancer/Tests/sqlancer01.stable.out
        sql/test/miscellaneous/Tests/groupby_error.stable.out
Branch: unlock
Log Message:

approved output


diffs (truncated from 3274 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
@@ -257,15 +257,15 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "str_group_concat",     "pattern 
aggr.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:bat[:cnd], X_4:bit):str 
",     "CMDBATstr_group_concat;",      ""      ]
 [ "aggr",      "str_group_concat",     "pattern 
aggr.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:bit):str ",    
"CMDBATstr_group_concat;",      ""      ]
 [ "aggr",      "str_group_concat",     "pattern 
aggr.str_group_concat(X_1:bat[:str], X_2:bit):str ",   
"CMDBATstr_group_concat;",      ""      ]
-[ "aggr",      "suball",       "pattern aggr.suball(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:cnd], X_5:bit):bat[:any_1] ",      
"SQLall_grp;",  ""      ]
+[ "aggr",      "suball",       "pattern aggr.suball(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:any_1] ",      
"SQLall_grp;",  ""      ]
 [ "aggr",      "suball",       "pattern aggr.suball(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:any_1] ",     "SQLall_grp;",  ""    
  ]
-[ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:cnd], X_7:bit):bat[:bit] ",        
"SQLallnotequal_grp2;", ""      ]
+[ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:oid], X_7:bit):bat[:bit] ",        
"SQLallnotequal_grp2;", ""      ]
 [ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ",       
"SQLallnotequal_grp2;", ""      ]
-[ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bat[:cnd], X_6:bit):bat[:bit] ",       
"SQLallnotequal_grp;",  ""      ]
+[ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ",       
"SQLallnotequal_grp;",  ""      ]
 [ "aggr",      "suballnotequal",       "pattern 
aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid], X_5:bit):bat[:bit] ",      "SQLallnotequal_grp;",  ""      ]
-[ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:cnd], 
X_7:bit):bat[:bit] ",   "SQLanyequal_grp2;",    ""      ]
+[ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:oid], 
X_7:bit):bat[:bit] ",   "SQLanyequal_grp2;",    ""      ]
 [ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], 
X_6:bit):bat[:bit] ",  "SQLanyequal_grp2;",    ""      ]
-[ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:cnd], 
X_6:bit):bat[:bit] ",  "SQLanyequal_grp;",     ""      ]
+[ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], 
X_6:bit):bat[:bit] ",  "SQLanyequal_grp;",     ""      ]
 [ "aggr",      "subanyequal",  "pattern aggr.subanyequal(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", 
"SQLanyequal_grp;",     ""      ]
 [ "aggr",      "subavg",       "command aggr.subavg(X_3:bat[:bte], 
X_4:bat[:oid], X_5:bat[:any_1], X_6:bat[:cnd], X_7:bit) (X_0:bat[:bte], 
X_1:bat[:lng], X_2:bat[:lng]) ",    "AGGRavg3;",    ""      ]
 [ "aggr",      "subavg",       "command aggr.subavg(X_3:bat[:int], 
X_4:bat[:oid], X_5:bat[:any_1], X_6:bat[:cnd], X_7:bit) (X_0:bat[:int], 
X_1:bat[:lng], X_2:bat[:lng]) ",    "AGGRavg3;",    ""      ]
@@ -361,7 +361,7 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "subcovariancep",       "command 
aggr.subcovariancep(X_1:bat[:int], X_2:bat[:int], X_3:bat[:oid], 
X_4:bat[:any_1], X_5:bat[:cnd], X_6:bit, X_7:bit):bat[:dbl] ",        
"AGGRsubcovariancepcand;",      ""      ]
 [ "aggr",      "subcovariancep",       "command 
aggr.subcovariancep(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:oid], 
X_4:bat[:any_1], X_5:bat[:cnd], X_6:bit, X_7:bit):bat[:dbl] ",        
"AGGRsubcovariancepcand;",      ""      ]
 [ "aggr",      "subcovariancep",       "command 
aggr.subcovariancep(X_1:bat[:sht], X_2:bat[:sht], X_3:bat[:oid], 
X_4:bat[:any_1], X_5:bat[:cnd], X_6:bit, X_7:bit):bat[:dbl] ",        
"AGGRsubcovariancepcand;",      ""      ]
-[ "aggr",      "subexist",     "pattern aggr.subexist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:cnd], X_5:bit):bat[:bit] ",        
"SQLsubexist;", ""      ]
+[ "aggr",      "subexist",     "pattern aggr.subexist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ",        
"SQLsubexist;", ""      ]
 [ "aggr",      "subexist",     "pattern aggr.subexist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ",       "SQLsubexist;", ""    
  ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(X_1:bat[:dbl], 
X_2:bat[:oid], X_3:bat[:any_1], X_4:bit):bat[:str] ",  "JSONsubjson;", ""      ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(X_1:bat[:str], 
X_2:bat[:oid], X_3:bat[:any_1], X_4:bit):bat[:str] ",  "JSONsubjson;", ""      ]
@@ -379,9 +379,9 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "submin",       "command aggr.submin(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:any_2], X_4:bit):bat[:any_1] ",   "AGGRsubmin_val;",    
  ""      ]
 [ "aggr",      "submin",       "command aggr.submin(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:any_2], X_4:bat[:cnd], X_5:bit):bat[:oid] ",      
"AGGRsubmincand;",      ""      ]
 [ "aggr",      "submin",       "command aggr.submin(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:any_2], X_4:bat[:cnd], X_5:bit):bat[:any_1] ",    
"AGGRsubmincand_val;",  ""      ]
-[ "aggr",      "subnot_exist", "pattern aggr.subnot_exist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:cnd], X_5:bit):bat[:bit] ",    
"SQLsubnot_exist;",     ""      ]
+[ "aggr",      "subnot_exist", "pattern aggr.subnot_exist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ",    
"SQLsubnot_exist;",     ""      ]
 [ "aggr",      "subnot_exist", "pattern aggr.subnot_exist(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ",   "SQLsubnot_exist;",     
""      ]
-[ "aggr",      "subnull",      "pattern aggr.subnull(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:cnd], X_5:bit):bat[:bit] ",       
"SQLnil_grp;",  ""      ]
+[ "aggr",      "subnull",      "pattern aggr.subnull(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ",       
"SQLnil_grp;",  ""      ]
 [ "aggr",      "subnull",      "pattern aggr.subnull(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ",      "SQLnil_grp;",  ""     
 ]
 [ "aggr",      "subprod",      "command aggr.subprod(X_1:bat[:bte], 
X_2:bat[:oid], X_3:bat[:any_1], X_4:bit, X_5:bit):bat[:bte] ",     
"AGGRsubprod_bte;",     ""      ]
 [ "aggr",      "subprod",      "command aggr.subprod(X_1:bat[:dbl], 
X_2:bat[:oid], X_3:bat[:any_1], X_4:bit, X_5:bit):bat[:dbl] ",     
"AGGRsubprod_dbl;",     ""      ]
@@ -4194,8 +4194,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "bit_noerror",  "pattern batcalc.bit_noerror(X_1:bat[:sht], 
X_2:bat[:cnd]):bat[:bit] ", "CMDconvert_bit;",      ""      ]
 [ "batcalc",   "bit_noerror",  "pattern 
batcalc.bit_noerror(X_1:bat[:str]):bat[:bit] ",        "CMDconvert_bit;",      
""      ]
 [ "batcalc",   "bit_noerror",  "pattern batcalc.bit_noerror(X_1:bat[:str], 
X_2:bat[:cnd]):bat[:bit] ", "CMDconvert_bit;",      ""      ]
-[ "batcalc",   "blob", "command batcalc.blob(X_1:bat[:str]):bat[:blob] ",      
"batstr_2_blob;",       ""      ]
-[ "batcalc",   "blob", "command batcalc.blob(X_1:bat[:str], 
X_2:bat[:cnd]):bat[:blob] ",       "batstr_2_blob_cand;",  ""      ]
+[ "batcalc",   "blob", "command batcalc.blob(X_1:bat[:str], 
X_2:bat[:oid]):bat[:blob] ",       "batstr_2_blob;",       ""      ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(X_1:bat[:bit]):bat[:bte] ",        
"CMDconvertsignal_bte;",        ""      ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(X_1:bat[:bit], 
X_2:bat[:cnd]):bat[:bte] ", "CMDconvertsignal_bte;",        ""      ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(X_1:bat[:bte]):bat[:bte] ",        
"CMDconvertsignal_bte;",        ""      ]
@@ -4497,34 +4496,21 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(X_1:sht, X_2:bat[:sht], 
X_3:bat[:cnd]):bat[:bte] ",        "CMDbatCMP;",   ""      ]
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(X_1:str, X_2:bat[:str]):bat[:bte] 
",       "CMDbatCMP;",   ""      ]
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(X_1:str, X_2:bat[:str], 
X_3:bat[:cnd]):bat[:bte] ",        "CMDbatCMP;",   ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:date]):bat[:date] ",     
"MTIMEdate_date_bulk;", ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:date], 
X_2:bat[:oid]):bat[:date] ",      "MTIMEdate_date_bulk_cand;",    ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",      
"MTIMEdate_fromstr_bulk;",      ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",       "MTIMEdate_fromstr_bulk_cand;", ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:timestamp]):bat[:date] 
",        "MTIMEtimestamp_extract_date_bulk;",    ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:date] ", "MTIMEtimestamp_extract_date_bulk_cand;",       "" 
     ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",      
"batstr_2_date;",       ""      ]
-[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:cnd]):bat[:date] ",       "batstr_2_date_cand;",  ""      ]
+[ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:date], 
X_2:bat[:oid]):bat[:date] ",      "MTIMEdate_date_bulk;", ""      ]
+[ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",       "MTIMEdate_fromstr_bulk;",      ""      ]
+[ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:date] ", "MTIMEtimestamp_extract_date_bulk;",    ""      ]
+[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",       "batstr_2_date;",       ""      ]
 [ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:oid]):bat[:date] ",      
"nil_2_date;",  ""      ]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(X_1:bat[:daytime]):bat[:daytime] ",    
"MTIMEdaytime_daytime_bulk;",   ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:oid]):bat[:daytime] ",     "MTIMEdaytime_daytime_bulk_cand;",      ""  
    ]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(X_1:bat[:lng]):bat[:daytime] ",        
"MTIMEdaytime_fromseconds_bulk;",       ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromseconds_bulk_cand;",  ""      
]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(X_1:bat[:str]):bat[:daytime] ",        
"MTIMEdaytime_fromstr_bulk;",   ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromstr_bulk_cand;",      ""      
]
-[ "batcalc",   "daytime",      "command 
batcalc.daytime(X_1:bat[:timestamp]):bat[:daytime] ",  
"MTIMEtimestamp_extract_daytime_bulk;", ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:daytime] ",   "MTIMEtimestamp_extract_daytime_bulk_cand;",  
  ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:str], 
X_2:int):bat[:daytime] ",       "batstr_2time_daytime;",        ""      ]
-[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:cnd], X_3:int):bat[:daytime] ",        "batstr_2time_daytime_cand;",   
""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:cnd], X_3:int):bat[:daytime] ",    "daytime_2time_daytime;",       ""  
    ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:int):bat[:daytime] ",   "daytime_2time_daytime;",       ""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:oid]):bat[:daytime] ",     "MTIMEdaytime_daytime_bulk;",   ""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromseconds_bulk;",       ""      
]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromstr_bulk;",   ""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:daytime] ",   "MTIMEtimestamp_extract_daytime_bulk;", ""    
  ]
+[ "batcalc",   "daytime",      "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid], X_3:int):bat[:daytime] ",        "batstr_2time_daytime;",        
""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:oid], X_3:int):bat[:daytime] ",    "daytime_2time_daytime;",       ""  
    ]
 [ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:oid], 
X_2:int):bat[:daytime] ",       "nil_2time_daytime;",   ""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:cnd], X_3:int):bat[:daytime] ",        "second_interval_2_daytime;",   
""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:lng], 
X_2:int):bat[:daytime] ",       "second_interval_2_daytime;",   ""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:str], 
X_2:bat[:cnd], X_3:int, X_4:int):bat[:daytime] ",       "str_2time_daytimetz;", 
""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:str], 
X_2:int, X_3:int):bat[:daytime] ",      "str_2time_daytimetz;", ""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:timestamp], 
X_2:bat[:cnd], X_3:int):bat[:daytime] ",  "timestamp_2_daytime;", ""      ]
-[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:timestamp], 
X_2:int):bat[:daytime] ", "timestamp_2_daytime;", ""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:oid], X_3:int):bat[:daytime] ",        "second_interval_2_daytime;",   
""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid], X_3:int, X_4:int):bat[:daytime] ",       "str_2time_daytimetz;", 
""      ]
+[ "batcalc",   "daytime",      "pattern batcalc.daytime(X_1:bat[:timestamp], 
X_2:bat[:oid], X_3:int):bat[:daytime] ",  "timestamp_2_daytime;", ""      ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(X_1:bat[:bit]):bat[:dbl] ",        
"CMDconvertsignal_dbl;",        ""      ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(X_1:bat[:bit], 
X_2:bat[:cnd]):bat[:dbl] ", "CMDconvertsignal_dbl;",        ""      ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(X_1:bat[:bte]):bat[:dbl] ",        
"CMDconvertsignal_dbl;",        ""      ]
@@ -4585,6 +4571,48 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "dbl_noerror",  "pattern batcalc.dbl_noerror(X_1:bat[:sht], 
X_2:bat[:cnd]):bat[:dbl] ", "CMDconvert_dbl;",      ""      ]
 [ "batcalc",   "dbl_noerror",  "pattern 
batcalc.dbl_noerror(X_1:bat[:str]):bat[:dbl] ",        "CMDconvert_dbl;",      
""      ]
 [ "batcalc",   "dbl_noerror",  "pattern batcalc.dbl_noerror(X_1:bat[:str], 
X_2:bat[:cnd]):bat[:dbl] ", "CMDconvert_dbl;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:bte], 
X_2:bte):bat[:bte] ", "bte_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:bte], 
X_2:bte, X_3:bat[:oid]):bat[:bte] ",  "bte_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bte, 
X_2:bat[:bte]):bat[:bte] ", "bte_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bte, 
X_2:bat[:bte], X_3:bat[:oid]):bat[:bte] ",  "bte_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:bte], 
X_2:bat[:bte]):bat[:bte] ",   "bte_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid]):bat[:bte] ",     
"bte_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:dbl], 
X_2:dbl):bat[:dbl] ", "dbl_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:dbl], 
X_2:dbl, X_3:bat[:oid]):bat[:dbl] ",  "dbl_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:dbl, 
X_2:bat[:dbl]):bat[:dbl] ", "dbl_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:dbl, 
X_2:bat[:dbl], X_3:bat[:oid]):bat[:dbl] ",  "dbl_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:dbl], 
X_2:bat[:dbl]):bat[:dbl] ",   "dbl_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:dbl], 
X_2:bat[:dbl], X_3:bat[:oid], X_4:bat[:oid]):bat[:dbl] ",     
"dbl_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:flt], 
X_2:flt):bat[:flt] ", "flt_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:flt], 
X_2:flt, X_3:bat[:oid]):bat[:flt] ",  "flt_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:flt, 
X_2:bat[:flt]):bat[:flt] ", "flt_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:flt, 
X_2:bat[:flt], X_3:bat[:oid]):bat[:flt] ",  "flt_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:flt], 
X_2:bat[:flt]):bat[:flt] ",   "flt_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:flt], 
X_2:bat[:flt], X_3:bat[:oid], X_4:bat[:oid]):bat[:flt] ",     
"flt_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:hge], 
X_2:hge):bat[:hge] ", "hge_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:hge], 
X_2:hge, X_3:bat[:oid]):bat[:hge] ",  "hge_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:hge, 
X_2:bat[:hge]):bat[:hge] ", "hge_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:hge, 
X_2:bat[:hge], X_3:bat[:oid]):bat[:hge] ",  "hge_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:hge], 
X_2:bat[:hge]):bat[:hge] ",   "hge_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:hge], 
X_2:bat[:hge], X_3:bat[:oid], X_4:bat[:oid]):bat[:hge] ",     
"hge_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:int], 
X_2:int):bat[:int] ", "int_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:int], 
X_2:int, X_3:bat[:oid]):bat[:int] ",  "int_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:int, 
X_2:bat[:int]):bat[:int] ", "int_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:int, 
X_2:bat[:int], X_3:bat[:oid]):bat[:int] ",  "int_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:int], 
X_2:bat[:int]):bat[:int] ",   "int_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:int], 
X_2:bat[:int], X_3:bat[:oid], X_4:bat[:oid]):bat[:int] ",     
"int_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:lng], 
X_2:lng):bat[:lng] ", "lng_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:lng], 
X_2:lng, X_3:bat[:oid]):bat[:lng] ",  "lng_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:lng, 
X_2:bat[:lng]):bat[:lng] ", "lng_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:lng, 
X_2:bat[:lng], X_3:bat[:oid]):bat[:lng] ",  "lng_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:lng], 
X_2:bat[:lng]):bat[:lng] ",   "lng_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:lng], 
X_2:bat[:lng], X_3:bat[:oid], X_4:bat[:oid]):bat[:lng] ",     
"lng_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:sht], 
X_2:sht):bat[:sht] ", "sht_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:sht], 
X_2:sht, X_3:bat[:oid]):bat[:sht] ",  "sht_bat_dec_round_wrap;",      ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:sht, 
X_2:bat[:sht]):bat[:sht] ", "sht_bat_dec_round_wrap_cst;",  ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:sht, 
X_2:bat[:sht], X_3:bat[:oid]):bat[:sht] ",  "sht_bat_dec_round_wrap_cst;",  ""  
    ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:sht], 
X_2:bat[:sht]):bat[:sht] ",   "sht_bat_dec_round_wrap_nocst;",        ""      ]
+[ "batcalc",   "dec_round",    "pattern batcalc.dec_round(X_1:bat[:sht], 
X_2:bat[:sht], X_3:bat[:oid], X_4:bat[:oid]):bat[:sht] ",     
"sht_bat_dec_round_wrap_nocst;",        ""      ]
 [ "batcalc",   "div_noerror",  "pattern batcalc.div_noerror(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:cnd], X_4:bat[:cnd]):bat[:bte] ",   "CMDbatDIV;",   ""  
    ]
 [ "batcalc",   "div_noerror",  "pattern batcalc.div_noerror(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:cnd], X_4:bat[:cnd]):bat[:dbl] ",   "CMDbatDIV;",   ""  
    ]
 [ "batcalc",   "div_noerror",  "pattern batcalc.div_noerror(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:cnd], X_4:bat[:cnd]):bat[:flt] ",   "CMDbatDIV;",   ""  
    ]
@@ -6342,6 +6370,48 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "or",   "pattern batcalc.or(X_1:sht, X_2:bat[:sht]):bat[:sht] 
",        "CMDbatOR;",    ""      ]
 [ "batcalc",   "or",   "pattern batcalc.or(X_1:sht, X_2:bat[:sht], 
X_3:bat[:cnd]):bat[:sht] ", "CMDbatOR;",    ""      ]
 [ "batcalc",   "rotate_xor_hash",      "command 
batcalc.rotate_xor_hash(X_1:bat[:lng], X_2:int, X_3:bat[:any_1]):bat[:int] ",  
"MKEYbulk_rotate_xor_hash;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:bte], X_2:bte, 
X_3:bat[:oid], X_4:int, X_5:int):bat[:bte] ",    "bte_bat_round_wrap;",  ""     
 ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:bte], X_2:bte, 
X_3:int, X_4:int):bat[:bte] ",   "bte_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bte, X_2:bat[:bte], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:bte] ",    "bte_bat_round_wrap_cst;",     
 ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bte, X_2:bat[:bte], 
X_3:int, X_4:int):bat[:bte] ",   "bte_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:int):bat[:bte] ",     
  "bte_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:bte], 
X_2:bat[:bte], X_3:int, X_4:int):bat[:bte] ",     "bte_bat_round_wrap_nocst;",  
  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:dbl], 
X_2:bte):bat[:dbl] ",     "dbl_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:dbl], X_2:bte, 
X_3:bat[:oid]):bat[:dbl] ",      "dbl_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:dbl, 
X_2:bat[:bte]):bat[:dbl] ",     "dbl_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:dbl, X_2:bat[:bte], 
X_3:bat[:oid]):bat[:dbl] ",      "dbl_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:dbl], 
X_2:bat[:bte]):bat[:dbl] ",       "dbl_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:dbl], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid]):bat[:dbl] ", 
"dbl_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:flt], 
X_2:bte):bat[:flt] ",     "flt_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:flt], X_2:bte, 
X_3:bat[:oid]):bat[:flt] ",      "flt_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:flt, 
X_2:bat[:bte]):bat[:flt] ",     "flt_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:flt, X_2:bat[:bte], 
X_3:bat[:oid]):bat[:flt] ",      "flt_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:flt], 
X_2:bat[:bte]):bat[:flt] ",       "flt_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:flt], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid]):bat[:flt] ", 
"flt_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:hge], X_2:bte, 
X_3:bat[:oid], X_4:int, X_5:int):bat[:hge] ",    "hge_bat_round_wrap;",  ""     
 ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:hge], X_2:bte, 
X_3:int, X_4:int):bat[:hge] ",   "hge_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:hge, X_2:bat[:bte], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:hge] ",    "hge_bat_round_wrap_cst;",     
 ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:hge, X_2:bat[:bte], 
X_3:int, X_4:int):bat[:hge] ",   "hge_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:hge], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:int):bat[:hge] ",     
  "hge_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:hge], 
X_2:bat[:bte], X_3:int, X_4:int):bat[:hge] ",     "hge_bat_round_wrap_nocst;",  
  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:int], X_2:bte, 
X_3:bat[:oid], X_4:int, X_5:int):bat[:int] ",    "int_bat_round_wrap;",  ""     
 ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:int], X_2:bte, 
X_3:int, X_4:int):bat[:int] ",   "int_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:int, X_2:bat[:bte], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:int] ",    "int_bat_round_wrap_cst;",     
 ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:int, X_2:bat[:bte], 
X_3:int, X_4:int):bat[:int] ",   "int_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:int], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:int):bat[:int] ",     
  "int_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:int], 
X_2:bat[:bte], X_3:int, X_4:int):bat[:int] ",     "int_bat_round_wrap_nocst;",  
  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:lng], X_2:bte, 
X_3:bat[:oid], X_4:int, X_5:int):bat[:lng] ",    "lng_bat_round_wrap;",  ""     
 ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:lng], X_2:bte, 
X_3:int, X_4:int):bat[:lng] ",   "lng_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:lng, X_2:bat[:bte], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:lng] ",    "lng_bat_round_wrap_cst;",     
 ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:lng, X_2:bat[:bte], 
X_3:int, X_4:int):bat[:lng] ",   "lng_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:lng], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:int):bat[:lng] ",     
  "lng_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:lng], 
X_2:bat[:bte], X_3:int, X_4:int):bat[:lng] ",     "lng_bat_round_wrap_nocst;",  
  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:sht], X_2:bte, 
X_3:bat[:oid], X_4:int, X_5:int):bat[:sht] ",    "sht_bat_round_wrap;",  ""     
 ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:sht], X_2:bte, 
X_3:int, X_4:int):bat[:sht] ",   "sht_bat_round_wrap;",  ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:sht, X_2:bat[:bte], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:sht] ",    "sht_bat_round_wrap_cst;",     
 ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:sht, X_2:bat[:bte], 
X_3:int, X_4:int):bat[:sht] ",   "sht_bat_round_wrap_cst;",      ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:sht], 
X_2:bat[:bte], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:int):bat[:sht] ",     
  "sht_bat_round_wrap_nocst;",    ""      ]
+[ "batcalc",   "round",        "pattern batcalc.round(X_1:bat[:sht], 
X_2:bat[:bte], X_3:int, X_4:int):bat[:sht] ",     "sht_bat_round_wrap_nocst;",  
  ""      ]
 [ "batcalc",   "rsh_noerror",  "pattern batcalc.rsh_noerror(X_1:bat[:bte], 
X_2:bat[:bte]):bat[:bte] ", "CMDbatRSH;",   ""      ]
 [ "batcalc",   "rsh_noerror",  "pattern batcalc.rsh_noerror(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:cnd], X_4:bat[:cnd]):bat[:bte] ",   "CMDbatRSH;",   ""  
    ]
 [ "batcalc",   "rsh_noerror",  "pattern batcalc.rsh_noerror(X_1:bat[:bte], 
X_2:bat[:int]):bat[:bte] ", "CMDbatRSH;",   ""      ]
@@ -6539,8 +6609,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "sign", "pattern batcalc.sign(X_1:bat[:sht], 
X_2:bat[:cnd]):bat[:bte] ",        "CMDbatSIGN;",  ""      ]
 [ "batcalc",   "str",  "pattern batcalc.str(X_1:bat[:any]):bat[:str] ",        
"CMDconvertsignal_str;",        ""      ]
 [ "batcalc",   "str",  "pattern batcalc.str(X_1:bat[:any], 
X_2:bat[:cnd]):bat[:str] ", "CMDconvertsignal_str;",        ""      ]
-[ "batcalc",   "str",  "pattern batcalc.str(X_1:int, X_2:int, X_3:int, 
X_4:int, X_5:bat[:any_1], X_6:bat[:cnd], X_7:int):bat[:str] ",  
"SQLbatstr_cast;",      ""      ]
-[ "batcalc",   "str",  "pattern batcalc.str(X_1:int, X_2:int, X_3:int, 
X_4:int, X_5:bat[:any_1], X_6:int):bat[:str] ", "SQLbatstr_cast;",      ""      
]
+[ "batcalc",   "str",  "pattern batcalc.str(X_1:int, X_2:int, X_3:int, 
X_4:int, X_5:bat[:any_1], X_6:bat[:oid], X_7:int):bat[:str] ",  
"SQLbatstr_cast;",      ""      ]
 [ "batcalc",   "str_noerror",  "pattern 
batcalc.str_noerror(X_1:bat[:any]):bat[:str] ",        "CMDconvert_str;",      
""      ]
 [ "batcalc",   "str_noerror",  "pattern batcalc.str_noerror(X_1:bat[:any], 
X_2:bat[:cnd]):bat[:str] ", "CMDconvert_str;",      ""      ]
 [ "batcalc",   "sub_noerror",  "pattern batcalc.sub_noerror(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:cnd], X_4:bat[:cnd]):bat[:bte] ",   "CMDbatSUB;",   ""  
    ]
@@ -6651,26 +6720,17 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "sub_noerror",  "pattern batcalc.sub_noerror(X_1:sht, 
X_2:bat[:int], X_3:bat[:cnd]):bat[:int] ",        "CMDbatSUB;",   ""      ]
 [ "batcalc",   "sub_noerror",  "pattern batcalc.sub_noerror(X_1:sht, 
X_2:bat[:lng], X_3:bat[:cnd]):bat[:lng] ",        "CMDbatSUB;",   ""      ]
 [ "batcalc",   "sub_noerror",  "pattern batcalc.sub_noerror(X_1:sht, 
X_2:bat[:sht], X_3:bat[:cnd]):bat[:sht] ",        "CMDbatSUB;",   ""      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(X_1:bat[:date]):bat[:timestamp] ",   
"MTIMEtimestamp_fromdate_bulk;",        ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:date], 
X_2:bat[:oid]):bat[:timestamp] ",    "MTIMEtimestamp_fromdate_bulk_cand;",   "" 
     ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(X_1:bat[:lng]):bat[:timestamp] ",    
"MTIMEtimestamp_frommsec_bulk;",        ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:lng], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_frommsec_bulk_cand;",   
""      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(X_1:bat[:int]):bat[:timestamp] ",    
"MTIMEtimestamp_fromsecond_bulk;",      ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:int], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_fromsecond_bulk_cand;", 
""      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(X_1:bat[:str]):bat[:timestamp] ",    
"MTIMEtimestamp_fromstr_bulk;", ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_fromstr_bulk_cand;",    
""      ]
-[ "batcalc",   "timestamp",    "command 
batcalc.timestamp(X_1:bat[:timestamp]):bat[:timestamp] ",      
"MTIMEtimestamp_timestamp_bulk;",       ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:timestamp] ",       "MTIMEtimestamp_timestamp_bulk_cand;",  
""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:int):bat[:timestamp] ",   "batstr_2time_timestamp;",      ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:cnd], X_3:int):bat[:timestamp] ",    "batstr_2time_timestamp_cand;", 
""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:int, X_3:int):bat[:timestamp] ",  "batstr_2time_timestamptz;",    ""      ]
-[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:cnd], X_3:int, X_4:int):bat[:timestamp] ",   
"batstr_2time_timestamptz_cand;",       ""      ]
-[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:date], 
X_2:bat[:cnd], X_3:int):bat[:timestamp] ",   "date_2_timestamp;",    ""      ]
-[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:date], 
X_2:int):bat[:timestamp] ",  "date_2_timestamp;",    ""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:date], 
X_2:bat[:oid]):bat[:timestamp] ",    "MTIMEtimestamp_fromdate_bulk;",        "" 
     ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:lng], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_frommsec_bulk;",        
""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:int], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_fromsecond_bulk;",      
""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:oid]):bat[:timestamp] ",     "MTIMEtimestamp_fromstr_bulk;", ""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:timestamp] ",       "MTIMEtimestamp_timestamp_bulk;",       
""      ]
+[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:oid], X_3:int):bat[:timestamp] ",    "batstr_2time_timestamp;",      
""      ]
+[ "batcalc",   "timestamp",    "command batcalc.timestamp(X_1:bat[:str], 
X_2:bat[:oid], X_3:int, X_4:int):bat[:timestamp] ",   
"batstr_2time_timestamptz;",    ""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:date], 
X_2:bat[:oid], X_3:int):bat[:timestamp] ",   "date_2_timestamp;",    ""      ]
 [ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:oid], 
X_2:int):bat[:timestamp] ",   "nil_2time_timestamp;", ""      ]
 [ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:oid], 
X_2:int, X_3:bat[:BAT]):bat[:timestamp] ",    "nil_2time_timestamp;", ""      ]
-[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:timestamp], 
X_2:bat[:cnd], X_3:int):bat[:timestamp] ",      "timestamp_2time_timestamp;",   
""      ]
-[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:timestamp], 
X_2:int):bat[:timestamp] ",     "timestamp_2time_timestamp;",   ""      ]
+[ "batcalc",   "timestamp",    "pattern batcalc.timestamp(X_1:bat[:timestamp], 
X_2:bat[:oid], X_3:int):bat[:timestamp] ",      "timestamp_2time_timestamp;",   
""      ]
 [ "batcalc",   "wkb",  "command batcalc.wkb(X_1:bat[:wkb], X_2:int, 
X_3:int):bat[:wkb] ",      "geom_2_geom_bat;",     ""      ]
 [ "batcalc",   "xml",  "command batcalc.xml(X_1:bat[:str]):bat[:xml] ",        
"BATXMLstr2xml;",       ""      ]
 [ "batcalc",   "xor",  "pattern batcalc.xor(X_1:bat[:bit], 
X_2:bat[:bit]):bat[:bit] ", "CMDbatXOR;",   ""      ]
@@ -6931,97 +6991,187 @@ stdout of test 'MAL-signatures` in direc
 [ "batmmath",  "tanh", "pattern batmmath.tanh(X_1:bat[:dbl], 
X_2:bat[:cnd]):bat[:dbl] ",       "CMDscience_bat_tanh;", ""      ]
 [ "batmmath",  "tanh", "pattern batmmath.tanh(X_1:bat[:flt]):bat[:flt] ",      
"CMDscience_bat_tanh;", ""      ]
 [ "batmmath",  "tanh", "pattern batmmath.tanh(X_1:bat[:flt], 
X_2:bat[:cnd]):bat[:flt] ",       "CMDscience_bat_tanh;", ""      ]
-[ "batmtime",  "addmonths",    "command batmtime.addmonths(X_1:bat[:date], 
X_2:bat[:int]):bat[:date] ",        "MTIMEdate_addmonths_bulk;",    ""      ]
-[ "batmtime",  "addmonths",    "command batmtime.addmonths(X_1:date, 
X_2:bat[:int]):bat[:date] ",      "MTIMEdate_addmonths_bulk_p1;", ""      ]
-[ "batmtime",  "addmonths",    "command batmtime.addmonths(X_1:bat[:date], 
X_2:int):bat[:date] ",      "MTIMEdate_addmonths_bulk_p2;", ""      ]
-[ "batmtime",  "century",      "command 
batmtime.century(X_1:bat[:date]):bat[:int] ",  
"MTIMEdate_extract_century_bulk;",      ""      ]
-[ "batmtime",  "century",      "command 
batmtime.century(X_1:bat[:timestamp]):bat[:int] ",     
"MTIMEtimestamp_century_bulk;", ""      ]
-[ "batmtime",  "date_add_msec_interval",       "command 
batmtime.date_add_msec_interval(X_1:bat[:date], X_2:bat[:lng]):bat[:date] ",   
"MTIMEdate_add_msec_interval_bulk;",    ""      ]
-[ "batmtime",  "date_add_msec_interval",       "command 
batmtime.date_add_msec_interval(X_1:date, X_2:bat[:lng]):bat[:date] ", 
"MTIMEdate_add_msec_interval_bulk_p1;", ""      ]
-[ "batmtime",  "date_add_msec_interval",       "command 
batmtime.date_add_msec_interval(X_1:bat[:date], X_2:lng):bat[:date] ", 
"MTIMEdate_add_msec_interval_bulk_p2;", ""      ]
-[ "batmtime",  "date_sub_month_interval",      "command 
batmtime.date_sub_month_interval(X_1:bat[:date], X_2:bat[:int]):bat[:date] ",  
"MTIMEdate_submonths_bulk;",    ""      ]
-[ "batmtime",  "date_sub_month_interval",      "command 
batmtime.date_sub_month_interval(X_1:date, X_2:bat[:int]):bat[:date] ",        
"MTIMEdate_submonths_bulk_p1;", ""      ]
-[ "batmtime",  "date_sub_month_interval",      "command 
batmtime.date_sub_month_interval(X_1:bat[:date], X_2:int):bat[:date] ",        
"MTIMEdate_submonths_bulk_p2;", ""      ]
-[ "batmtime",  "date_sub_msec_interval",       "command 
batmtime.date_sub_msec_interval(X_1:bat[:date], X_2:bat[:lng]):bat[:date] ",   
"MTIMEdate_sub_msec_interval_bulk;",    ""      ]
-[ "batmtime",  "date_sub_msec_interval",       "command 
batmtime.date_sub_msec_interval(X_1:date, X_2:bat[:lng]):bat[:date] ", 
"MTIMEdate_sub_msec_interval_bulk_p1;", ""      ]
-[ "batmtime",  "date_sub_msec_interval",       "command 
batmtime.date_sub_msec_interval(X_1:bat[:date], X_2:lng):bat[:date] ", 
"MTIMEdate_sub_msec_interval_bulk_p2;", ""      ]
-[ "batmtime",  "date_to_str",  "command batmtime.date_to_str(X_1:bat[:str], 
X_2:bat[:str]):bat[:str] ",        "MTIMEdate_to_str_bulk;",       ""      ]
-[ "batmtime",  "date_to_str",  "command batmtime.date_to_str(X_1:date, 
X_2:bat[:str]):bat[:str] ",     "MTIMEdate_to_str_bulk_p1;",    ""      ]
-[ "batmtime",  "date_to_str",  "command batmtime.date_to_str(X_1:bat[:date], 
X_2:str):bat[:str] ",     "MTIMEdate_to_str_bulk_p2;",    ""      ]
-[ "batmtime",  "day",  "command batmtime.day(X_1:bat[:date]):bat[:int] ",      
"MTIMEdate_extract_day_bulk;",  ""      ]
-[ "batmtime",  "day",  "command batmtime.day(X_1:bat[:lng]):bat[:lng] ",       
"MTIMEsql_day_bulk;",   ""      ]
-[ "batmtime",  "day",  "command batmtime.day(X_1:bat[:timestamp]):bat[:int] ", 
"MTIMEtimestamp_day_bulk;",     ""      ]
-[ "batmtime",  "dayofweek",    "command 
batmtime.dayofweek(X_1:bat[:date]):bat[:int] ",        
"MTIMEdate_extract_dayofweek_bulk;",    ""      ]
-[ "batmtime",  "dayofyear",    "command 
batmtime.dayofyear(X_1:bat[:date]):bat[:int] ",        
"MTIMEdate_extract_dayofyear_bulk;",    ""      ]
-[ "batmtime",  "decade",       "command 
batmtime.decade(X_1:bat[:date]):bat[:int] ",   
"MTIMEdate_extract_decade_bulk;",       ""      ]
-[ "batmtime",  "decade",       "command 
batmtime.decade(X_1:bat[:timestamp]):bat[:int] ",      
"MTIMEtimestamp_decade_bulk;",  ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:date], 
X_2:bat[:date]):bat[:lng] ",     "MTIMEdate_diff_bulk;", ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:date, 
X_2:bat[:date]):bat[:lng] ",   "MTIMEdate_diff_bulk_p1;",      ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:date], 
X_2:date):bat[:lng] ",   "MTIMEdate_diff_bulk_p2;",      ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:daytime], 
X_2:bat[:daytime]):bat[:lng] ",       "MTIMEdaytime_diff_msec_bulk;", ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:daytime, 
X_2:bat[:daytime]):bat[:lng] ",     "MTIMEdaytime_diff_msec_bulk_p1;",      ""  
    ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:daytime], 
X_2:daytime):bat[:lng] ",     "MTIMEdaytime_diff_msec_bulk_p2;",      ""      ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:timestamp], 
X_2:bat[:timestamp]):bat[:lng] ",   "MTIMEtimestamp_diff_msec_bulk;",       ""  
    ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:timestamp, 
X_2:bat[:timestamp]):bat[:lng] ", "MTIMEtimestamp_diff_msec_bulk_p1;",    ""    
  ]
-[ "batmtime",  "diff", "command batmtime.diff(X_1:bat[:timestamp], 
X_2:timestamp):bat[:lng] ", "MTIMEtimestamp_diff_msec_bulk_p2;",    ""      ]
-[ "batmtime",  "epoch",        "command 
batmtime.epoch(X_1:bat[:timestamp]):bat[:int] ",       
"MTIMEseconds_since_epoch_bulk;",       ""      ]
-[ "batmtime",  "epoch",        "command 
batmtime.epoch(X_1:bat[:lng]):bat[:timestamp] ",       
"MTIMEtimestamp_frommsec_bulk;",        ""      ]
-[ "batmtime",  "epoch",        "command 
batmtime.epoch(X_1:bat[:int]):bat[:timestamp] ",       
"MTIMEtimestamp_fromsecond_bulk;",      ""      ]
-[ "batmtime",  "epoch_ms",     "command 
batmtime.epoch_ms(X_1:bat[:date]):bat[:lng] ", 
"MTIMEdate_extract_epoch_ms_bulk;",     ""      ]
-[ "batmtime",  "epoch_ms",     "command 
batmtime.epoch_ms(X_1:bat[:daytime]):bat[:lng] ",      
"MTIMEdaytime_extract_epoch_ms_bulk;",  ""      ]
-[ "batmtime",  "epoch_ms",     "command 
batmtime.epoch_ms(X_1:bat[:lng]):bat[:lng] ",  
"MTIMEmsec_extract_epoch_ms_bulk;",     ""      ]
-[ "batmtime",  "epoch_ms",     "command 
batmtime.epoch_ms(X_1:bat[:timestamp]):bat[:lng] ",    
"MTIMEtimestamp_extract_epoch_ms_bulk;",        ""      ]
-[ "batmtime",  "hours",        "command 
batmtime.hours(X_1:bat[:daytime]):bat[:int] ", 
"MTIMEdaytime_extract_hours_bulk;",     ""      ]
-[ "batmtime",  "hours",        "command 
batmtime.hours(X_1:bat[:lng]):bat[:int] ",     "MTIMEsql_hours_bulk;", ""      ]
-[ "batmtime",  "hours",        "command 
batmtime.hours(X_1:bat[:timestamp]):bat[:int] ",       
"MTIMEtimestamp_hours_bulk;",   ""      ]
-[ "batmtime",  "minutes",      "command 
batmtime.minutes(X_1:bat[:daytime]):bat[:int] ",       
"MTIMEdaytime_extract_minutes_bulk;",   ""      ]
-[ "batmtime",  "minutes",      "command 
batmtime.minutes(X_1:bat[:lng]):bat[:int] ",   "MTIMEsql_minutes_bulk;",       
""      ]
-[ "batmtime",  "minutes",      "command 
batmtime.minutes(X_1:bat[:timestamp]):bat[:int] ",     
"MTIMEtimestamp_minutes_bulk;", ""      ]
-[ "batmtime",  "month",        "command 
batmtime.month(X_1:bat[:date]):bat[:int] ",    "MTIMEdate_extract_month_bulk;", 
       ""      ]
-[ "batmtime",  "month",        "command 
batmtime.month(X_1:bat[:int]):bat[:int] ",     "MTIMEsql_month_bulk;", ""      ]
-[ "batmtime",  "month",        "command 
batmtime.month(X_1:bat[:timestamp]):bat[:int] ",       
"MTIMEtimestamp_month_bulk;",   ""      ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to