Changeset: 3cb054b3870e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/3cb054b3870e
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
Branch: pushcands
Log Message:

Approved output


diffs (truncated from 417 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
@@ -761,11 +761,17 @@ stdout of test 'MAL-signatures` in direc
 [ "bataggr",   "not_exist",    "pattern 
bataggr.not_exist(X_0:bat[:any_1]):bat[:bit] ",        "SQLnot_exist;",        
""      ]
 [ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_0:bat[:any_1]):bit 
",      "SQLnot_exist;",        ""      ]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ",   "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid], X_5:bat[:oid]):bat[:bit] ",     
"BATPCRElike;", ""      ]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:str, X_2:str, X_3:bit):bat[:bit] ", "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:str, X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",  "BATPCRElike;", ""      
]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ", "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",  "BATPCRElike;", 
""      ]
 [ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] 
",       "BATPCREnotlike;",      ""      ]
+[ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:bat[:str], X_2:str, X_3:bit, 
X_4:bat[:oid], X_5:bat[:oid]):bat[:bit] ", "BATPCREnotlike;",      ""      ]
 [ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:str, X_2:str, X_3:bit):bat[:bit] ",     
"BATPCREnotlike;",      ""      ]
+[ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:str, X_2:str, X_3:bit, 
X_4:bat[:oid]):bat[:bit] ",      "BATPCREnotlike;",      ""      ]
 [ "batalgebra",        "not_like",     "pattern batalgebra.not_like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ",     "BATPCREnotlike;",      ""    
  ]
+[ "batalgebra",        "not_like",     "pattern batalgebra.not_like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",      
"BATPCREnotlike;",      ""      ]
 [ "batblob",   "nitems",       "pattern 
batblob.nitems(X_0:bat[:blob]):bat[:int] ",    "BLOBnitems_bulk;",     ""      ]
 [ "batblob",   "nitems",       "pattern batblob.nitems(X_0:bat[:blob], 
X_1:bat[:oid]):bat[:int] ",     "BLOBnitems_bulk;",     ""      ]
 [ "batcalc",   "!=",   "pattern batcalc.!=(X_0:any_1, 
X_1:bat[:any_1]):bat[:bit] ",    "CMDbatNE;",    ""      ]
@@ -4667,17 +4673,10 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "flt_noerror",  "pattern batcalc.flt_noerror(X_0:bat[:sht], 
X_1:bat[:oid]):bat[:flt] ", "CMDconvert_flt;",      ""      ]
 [ "batcalc",   "flt_noerror",  "pattern 
batcalc.flt_noerror(X_0:bat[:str]):bat[:flt] ",        "CMDconvert_flt;",      
""      ]
 [ "batcalc",   "flt_noerror",  "pattern batcalc.flt_noerror(X_0:bat[:str], 
X_1:bat[:oid]):bat[:flt] ", "CMDconvert_flt;",      ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:any_1]):bat[:lng] ",     
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:bte]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:dbl]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:flt]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:int]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:lng]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:lng]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:oid]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:sht]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "identity",     "command 
batcalc.identity(X_0:bat[:any]):bat[:oid] ",   "BATSQLidentity;",      ""      ]
+[ "batcalc",   "identity",     "pattern 
batcalc.identity(X_0:bat[:any]):bat[:oid] ",   "BATSQLidentity;",      ""      ]
+[ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:bat[:oid]):bat[:oid] ",    "BATSQLidentity;",      ""      ]
 [ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:oid) (X_2:bat[:oid], X_3:oid) ",   "PBATSQLidentity;",     ""      ]
+[ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:oid, X_2:bat[:oid]) (X_3:bat[:oid], X_4:oid) ",    "PBATSQLidentity;",     
""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:any_1, X_2:any_1):bat[:any_1] ", "CMDifthen;",   ""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:any_1, X_2:bat[:any_1]):bat[:any_1] ",   "CMDifthen;",   ""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:bat[:any_1], X_2:any_1):bat[:any_1] ",   "CMDifthen;",   ""      ]
@@ -5478,7 +5477,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:lng, X_1:bat[:lng], 
X_2:bat[:oid]):bat[:lng] ", "CMDbatOR;",    ""      ]
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:sht, X_1:bat[:sht]):bat[:sht] 
",        "CMDbatOR;",    ""      ]
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:sht, X_1:bat[:sht], 
X_2:bat[:oid]):bat[:sht] ", "CMDbatOR;",    ""      ]
-[ "batcalc",   "rotate_xor_hash",      "command 
batcalc.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1]):bat[:int] ",  
"MKEYbulk_rotate_xor_hash;",    ""      ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bat[:bte], X_1:bte, 
X_2:bat[:oid], X_3:int, X_4:int):bat[:bte] ",    "bte_bat_round_wrap;",  ""     
 ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bat[:bte], X_1:bte, 
X_2:int, X_3:int):bat[:bte] ",   "bte_bat_round_wrap;",  ""      ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bte, X_1:bat[:bte], 
X_2:bat[:oid], X_3:int, X_4:int):bat[:bte] ",    "bte_bat_round_wrap_cst;",     
 ""      ]
@@ -5947,7 +5945,14 @@ stdout of test 'MAL-signatures` in direc
 [ "batgeom",   "mbr",  "command batgeom.mbr(X_0:bat[:wkb]):bat[:mbr] ",        
"wkbMBR_bat;",  ""      ]
 [ "batgeom",   "setSRID",      "command batgeom.setSRID(X_0:bat[:wkb], 
X_1:int):bat[:wkb] ",   "wkbSetSRID_bat;",      ""      ]
 [ "batmal",    "multiplex",    "pattern batmal.multiplex(X_0:str, X_1:str, 
X_2:any...):any... ",       "MANIFOLDremapMultiplex;",      ""      ]
-[ "batmkey",   "hash", "command batmkey.hash(X_0:bat[:any_1]):bat[:lng] ",     
"MKEYbathash;", ""      ]
+[ "batmkey",   "hash", "pattern batmkey.hash(X_0:bat[:any]):bat[:lng] ",       
"MKEYbathash;", ""      ]
+[ "batmkey",   "hash", "pattern batmkey.hash(X_0:bat[:any], 
X_1:bat[:oid]):bat[:lng] ",        "MKEYbathash;", ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1]):bat[:lng] ",  
"MKEYbulk_rotate_xor_hash;",    ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid]):bat[:lng] ",    "MKEYbulk_rotate_xor_hash;",    ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:any):bat[:lng] ",  
"MKEYbulkconst_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:any, 
X_3:bat[:oid]):bat[:lng] ",   "MKEYbulkconst_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:lng, X_1:int, X_2:bat[:any_1]):bat[:lng] ",        
"MKEYconstbulk_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:lng, X_1:int, X_2:bat[:any_1], 
X_3:bat[:oid]):bat[:lng] ", "MKEYconstbulk_rotate_xor_hash;",       ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:dbl]):bat[:dbl] ",      
"CMDscience_bat_acos;", ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",       "CMDscience_bat_acos;", ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:flt]):bat[:flt] ",      
"CMDscience_bat_acos;", ""      ]
@@ -6052,8 +6057,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",    "CMDscience_bat_radians;",      ""      ]
 [ "batmmath",  "radians",      "pattern 
batmmath.radians(X_0:bat[:flt]):bat[:flt] ",   "CMDscience_bat_radians;",      
""      ]
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_0:bat[:flt], 
X_1:bat[:oid]):bat[:flt] ",    "CMDscience_bat_radians;",      ""      ]
-[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:int]):bat[:int] 
",       "CMDscience_bat_randintarg;",   ""      ]
-[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:int], 
X_1:bat[:oid]):bat[:int] ",        "CMDscience_bat_randintarg;",   ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:any]):bat[:int] 
",       "CMDscience_bat_randintarg;",   ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:any], 
X_1:bat[:oid]):bat[:int] ",        "CMDscience_bat_randintarg;",   ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:dbl]):bat[:dbl] ",       
"CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",        "CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:flt]):bat[:flt] ",       
"CMDscience_bat_sin;",  ""      ]
@@ -6362,9 +6367,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:bat[:str], 
X_1:bat[:str]):bat[:lng] ",    "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:bat[:str], 
X_1:str):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:bte] ",      "BATSTRindex_bte;",     ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:int] ",      "BATSTRindex_int;",     ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:sht] ",      "BATSTRindex_sht;",     ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:any, 
X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ",   "SQLlag;",      ""      
]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:bat[:any], 
X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1] ",   "SQLlag;",      ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:bat[:any], 
X_2:any_2, X_3:any_3):bat[:any_1] ",      "SQLlag;",      ""      ]
@@ -6433,7 +6435,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:str] ",        "SQLstrgroup_concat;",  ""      ]
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:bat[:str], X_1:str, X_2:any, X_3:any, X_4:int, 
X_5:any, X_6:any):bat[:str] ",      "SQLstrgroup_concat;",  ""      ]
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:str, X_1:bat[:str], X_2:any, X_3:any, X_4:int, 
X_5:any, X_6:any):bat[:str] ",      "SQLstrgroup_concat;",  ""      ]
-[ "batsql",    "strings",      "command 
batsql.strings(X_0:bat[:str]):bat[:str] ",     "BATSTRstrings;",       ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:bte], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:lng] ",    "SQLsum;",      ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:dbl], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:dbl] ",    "SQLsum;",      ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:flt], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:dbl] ",    "SQLsum;",      ""      ]
@@ -6633,7 +6634,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batudf",    "fuse", "command batudf.fuse(X_0:bat[:sht], 
X_1:bat[:sht]):bat[:int] ", "UDFBATfuse;",  ""      ]
 [ "batudf",    "reverse",      "command 
batudf.reverse(X_0:bat[:str]):bat[:str] ",     "UDFBATreverse;",       ""      ]
 [ "batuuid",   "isaUUID",      "command 
batuuid.isaUUID(X_0:bat[:str]):bat[:bit] ",    "UUIDisaUUID_bulk;",    ""      ]
-[ "batuuid",   "new",  "unsafe command batuuid.new(X_0:bat[:int]):bat[:uuid] 
",        "UUIDgenerateUuidInt_bulk;",    ""      ]
+[ "batuuid",   "new",  "unsafe command batuuid.new(X_0:bat[:any]):bat[:uuid] 
",        "UUIDgenerateUuidInt_bulk;",    ""      ]
 [ "batxml",    "attribute",    "command batxml.attribute(X_0:str, 
X_1:bat[:str]):bat[:xml] ",  "BATXMLattribute;",     ""      ]
 [ "batxml",    "comment",      "command 
batxml.comment(X_0:bat[:str]):bat[:xml] ",     "BATXMLcomment;",       ""      ]
 [ "batxml",    "concat",       "command batxml.concat(X_0:bat[:xml], 
X_1:bat[:xml]):bat[:xml] ",       "BATXMLconcat;",        ""      ]
@@ -7957,15 +7958,6 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "flt",  "command calc.flt(X_0:int, X_1:sht):flt ",      
"sht_dec2_flt;",        ""      ]
 [ "calc",      "flt",  "command calc.flt(X_0:int, X_1:sht, X_2:int, 
X_3:int):flt ",    "sht_dec2dec_flt;",     ""      ]
 [ "calc",      "flt",  "command calc.flt(X_0:sht, X_1:int, X_2:int):flt ",     
"sht_num2dec_flt;",     ""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:any):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:bte):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:dbl):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:flt):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:int):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:lng):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:lng):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:oid):lng ",      "MKEYhash;",    
""      ]
-[ "calc",      "hash", "pattern calc.hash(X_0:sht):lng ",      "MKEYhash;",    
""      ]
 [ "calc",      "identity",     "command calc.identity(X_0:any):oid ",  
"SQLidentity;", ""      ]
 [ "calc",      "ifthenelse",   "pattern calc.ifthenelse(X_0:bit, X_1:any_1, 
X_2:any_1):any_1 ",        "CALCswitchbit;",       ""      ]
 [ "calc",      "inet", "command calc.inet(X_0:str):inet ",     
"INET_fromstr;",        ""      ]
@@ -8250,7 +8242,6 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "or",   "pattern calc.or(X_0:lng, X_1:lng):lng ",       
"CMDvarOR;",    ""      ]
 [ "calc",      "or",   "pattern calc.or(X_0:sht, X_1:sht):sht ",       
"CMDvarOR;",    ""      ]
 [ "calc",      "ptr",  "command calc.ptr(X_0:ptr):ptr ",       
"CMDvarCONVERTptr;",    ""      ]
-[ "calc",      "rotate_xor_hash",      "pattern calc.rotate_xor_hash(X_0:lng, 
X_1:int, X_2:any_1):lng ",       "MKEYrotate_xor_hash;", ""      ]
 [ "calc",      "round",        "command calc.round(X_0:bte, X_1:bte, X_2:int, 
X_3:int):bte ",  "bte_round_wrap;",      ""      ]
 [ "calc",      "round",        "command calc.round(X_0:dbl, X_1:bte):dbl ",    
"dbl_round_wrap;",      ""      ]
 [ "calc",      "round",        "command calc.round(X_0:flt, X_1:bte):flt ",    
"flt_round_wrap;",      ""      ]
@@ -8945,20 +8936,8 @@ stdout of test 'MAL-signatures` in direc
 [ "mdb",       "stop", "pattern mdb.stop():void ",     "MDBstop;",     ""      
]
 [ "mdb",       "var",  "pattern mdb.var(X_0:str, X_1:str):void ",      
"MDBvar3;",     ""      ]
 [ "mdb",       "var",  "pattern mdb.var():void ",      "MDBvar;",      ""      
]
-[ "mkey",      "bulk_rotate_xor_hash", "command 
mkey.bulk_rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1]):bat[:lng] ", 
       "MKEYbulk_rotate_xor_hash;",    ""      ]
-[ "mkey",      "bulk_rotate_xor_hash", "pattern 
mkey.bulk_rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:any):bat[:lng] ",        
"MKEYbulkconst_rotate_xor_hash;",       ""      ]
-[ "mkey",      "bulk_rotate_xor_hash", "command 
mkey.bulk_rotate_xor_hash(X_0:lng, X_1:int, X_2:bat[:any_1]):bat[:lng] ",      
"MKEYconstbulk_rotate_xor_hash;",       ""      ]
-[ "mkey",      "bulk_rotate_xor_hash", "pattern 
mkey.bulk_rotate_xor_hash(X_0:lng, X_1:int, X_2:any):lng ",    
"MKEYrotate_xor_hash;", ""      ]
 [ "mkey",      "hash", "pattern mkey.hash(X_0:any):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:bit):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:bte):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:dbl):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:flt):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:int):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:lng):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:sht):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "hash", "pattern mkey.hash(X_0:str):lng ",      "MKEYhash;",    
""      ]
-[ "mkey",      "rotate",       "command mkey.rotate(X_0:lng, X_1:int):lng ",   
"MKEYrotate;",  ""      ]
+[ "mkey",      "rotate_xor_hash",      "pattern mkey.rotate_xor_hash(X_0:lng, 
X_1:int, X_2:any):lng ", "MKEYrotate_xor_hash;", ""      ]
 [ "mmath",     "acos", "command mmath.acos(X_0:dbl):dbl ",     
"MATHunary_ACOSdbl;",   ""      ]
 [ "mmath",     "acos", "command mmath.acos(X_0:flt):flt ",     
"MATHunary_ACOSflt;",   ""      ]
 [ "mmath",     "asin", "command mmath.asin(X_0:dbl):dbl ",     
"MATHunary_ASINdbl;",   ""      ]
@@ -9004,7 +8983,7 @@ stdout of test 'MAL-signatures` in direc
 [ "mmath",     "radians",      "command mmath.radians(X_0:dbl):dbl ",  
"MATHunary_RADIANSdbl;",        ""      ]
 [ "mmath",     "radians",      "command mmath.radians(X_0:flt):flt ",  
"MATHunary_RADIANSflt;",        ""      ]
 [ "mmath",     "rand", "unsafe command mmath.rand():int ",     "MATHrandint;", 
""      ]
-[ "mmath",     "rand", "unsafe command mmath.rand(X_0:int):int ",      
"MATHrandintarg;",      ""      ]
+[ "mmath",     "rand", "unsafe command mmath.rand(X_0:any):int ",      
"MATHrandintarg;",      ""      ]
 [ "mmath",     "round",        "command mmath.round(X_0:dbl, X_1:int):dbl ",   
"MATHbinary_ROUNDdbl;", ""      ]
 [ "mmath",     "round",        "command mmath.round(X_0:flt, X_1:int):flt ",   
"MATHbinary_ROUNDflt;", ""      ]
 [ "mmath",     "sin",  "command mmath.sin(X_0:dbl):dbl ",      
"MATHunary_SINdbl;",    ""      ]
@@ -9364,9 +9343,6 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "importColumn", "pattern sql.importColumn(X_0:str, X_1:bit, 
X_2:str, X_3:int, X_4:oid) (X_5:bat[:any], X_6:oid) ",      
"mvc_bin_import_column_wrap;",  ""      ]
 [ "sql",       "importTable",  "unsafe pattern sql.importTable(X_0:str, 
X_1:str, X_2:int, X_3:bit, X_4:str...):bat[:any]... ", 
"mvc_bin_import_table_wrap;",   ""      ]
 [ "sql",       "include",      "pattern sql.include(X_0:str):void ",   
"SQLinclude;",  ""      ]
-[ "sql",       "index",        "command sql.index(X_0:str, X_1:bit):bte ",     
"STRindex_bte;",        ""      ]
-[ "sql",       "index",        "command sql.index(X_0:str, X_1:bit):int ",     
"STRindex_int;",        ""      ]
-[ "sql",       "index",        "command sql.index(X_0:str, X_1:bit):sht ",     
"STRindex_sht;",        ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_0:any_1, X_1:any, X_2:any_1, 
X_3:bit, X_4:bit):any_1 ",      "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_0:any_1, X_1:any, X_2:bit, 
X_3:bit):any_1 ", "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_0:any_1, X_1:bit, X_2:bit):any_1 ",  
"SQLlag;",      ""      ]
@@ -9443,7 +9419,6 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "storage",      "pattern sql.storage(X_0:str, X_1:str, X_2:str) 
(X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str], X_7:bat[:str], 
X_8:bat[:str], X_9:bat[:lng], X_10:bat[:int], X_11:bat[:lng], X_12:bat[:lng], 
X_13:bat[:lng], X_14:bat[:bit], X_15:bat[:lng], X_16:bat[:bit], X_17:bat[:bit], 
X_18:bat[:bit], X_19:bat[:lng]) ",    "sql_storage;", ""      ]
 [ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_0:str, 
X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):str ",      "SQLstrgroup_concat;", 
 ""      ]
 [ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_0:str, 
X_1:str, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):str ",     
"SQLstrgroup_concat;",  ""      ]
-[ "sql",       "strings",      "command sql.strings(X_0:str):str ",    
"STRstrings;",  ""      ]
 [ "sql",       "subdelta",     "command sql.subdelta(X_0:bat[:oid], 
X_1:bat[:oid], X_2:bat[:oid], X_3:bat[:oid]):bat[:oid] ",  "DELTAsub;",    ""   
   ]
 [ "sql",       "sum",  "pattern sql.sum(X_0:bte, X_1:bit, X_2:bit, X_3:int, 
X_4:oid, X_5:oid):lng ",   "SQLsum;",      ""      ]
 [ "sql",       "sum",  "pattern sql.sum(X_0:dbl, X_1:bit, X_2:bit, X_3:int, 
X_4:oid, X_5:oid):dbl ",   "SQLsum;",      ""      ]
@@ -9658,7 +9633,7 @@ stdout of test 'MAL-signatures` in direc
 [ "user",      "main", "function user.main():void;",   "",     ""      ]
 [ "uuid",      "isaUUID",      "command uuid.isaUUID(X_0:str):bit ",   
"UUIDisaUUID;", ""      ]
 [ "uuid",      "new",  "unsafe command uuid.new():uuid ",      
"UUIDgenerateUuid;",    ""      ]
-[ "uuid",      "new",  "unsafe command uuid.new(X_0:int):uuid ",       
"UUIDgenerateUuidInt;", ""      ]
+[ "uuid",      "new",  "unsafe command uuid.new(X_0:any):uuid ",       
"UUIDgenerateUuidInt;", ""      ]
 [ "uuid",      "str",  "command uuid.str(X_0:uuid):str ",      
"UUIDuuid2str;",        ""      ]
 [ "uuid",      "uuid", "command uuid.uuid(X_0:str):uuid ",     
"UUIDstr2uuid;",        ""      ]
 [ "wlc",       "action",       "pattern wlc.action(X_0:str):void ",    
"WLCaction;",   ""      ]
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
@@ -880,11 +880,17 @@ stdout of test 'MAL-signatures` in direc
 [ "bataggr",   "not_exist",    "pattern 
bataggr.not_exist(X_0:bat[:any_1]):bat[:bit] ",        "SQLnot_exist;",        
""      ]
 [ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_0:bat[:any_1]):bit 
",      "SQLnot_exist;",        ""      ]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ",   "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid], X_5:bat[:oid]):bat[:bit] ",     
"BATPCRElike;", ""      ]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:str, X_2:str, X_3:bit):bat[:bit] ", "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:bat[:str], 
X_1:str, X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",  "BATPCRElike;", ""      
]
 [ "batalgebra",        "like", "pattern batalgebra.like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ", "BATPCRElike;", ""      ]
+[ "batalgebra",        "like", "pattern batalgebra.like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",  "BATPCRElike;", 
""      ]
 [ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] 
",       "BATPCREnotlike;",      ""      ]
+[ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:bat[:str], X_2:str, X_3:bit, 
X_4:bat[:oid], X_5:bat[:oid]):bat[:bit] ", "BATPCREnotlike;",      ""      ]
 [ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:str, X_2:str, X_3:bit):bat[:bit] ",     
"BATPCREnotlike;",      ""      ]
+[ "batalgebra",        "not_like",     "pattern 
batalgebra.not_like(X_0:bat[:str], X_1:str, X_2:str, X_3:bit, 
X_4:bat[:oid]):bat[:bit] ",      "BATPCREnotlike;",      ""      ]
 [ "batalgebra",        "not_like",     "pattern batalgebra.not_like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit):bat[:bit] ",     "BATPCREnotlike;",      ""    
  ]
+[ "batalgebra",        "not_like",     "pattern batalgebra.not_like(X_0:str, 
X_1:bat[:str], X_2:str, X_3:bit, X_4:bat[:oid]):bat[:bit] ",      
"BATPCREnotlike;",      ""      ]
 [ "batblob",   "nitems",       "pattern 
batblob.nitems(X_0:bat[:blob]):bat[:int] ",    "BLOBnitems_bulk;",     ""      ]
 [ "batblob",   "nitems",       "pattern batblob.nitems(X_0:bat[:blob], 
X_1:bat[:oid]):bat[:int] ",     "BLOBnitems_bulk;",     ""      ]
 [ "batcalc",   "!=",   "pattern batcalc.!=(X_0:any_1, 
X_1:bat[:any_1]):bat[:bit] ",    "CMDbatNE;",    ""      ]
@@ -6660,16 +6666,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "flt_noerror",  "pattern batcalc.flt_noerror(X_0:bat[:sht], 
X_1:bat[:oid]):bat[:flt] ", "CMDconvert_flt;",      ""      ]
 [ "batcalc",   "flt_noerror",  "pattern 
batcalc.flt_noerror(X_0:bat[:str]):bat[:flt] ",        "CMDconvert_flt;",      
""      ]
 [ "batcalc",   "flt_noerror",  "pattern batcalc.flt_noerror(X_0:bat[:str], 
X_1:bat[:oid]):bat[:flt] ", "CMDconvert_flt;",      ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:any_1]):bat[:lng] ",     
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:bte]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:dbl]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:flt]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:hge]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:int]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:lng]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:lng]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:oid]):bat[:lng] ",       
"MKEYbathash;", ""      ]
-[ "batcalc",   "hash", "command batcalc.hash(X_0:bat[:sht]):bat[:lng] ",       
"MKEYbathash;", ""      ]
 [ "batcalc",   "hge",  "pattern batcalc.hge(X_0:bat[:bit]):bat[:hge] ",        
"CMDconvertsignal_hge;",        ""      ]
 [ "batcalc",   "hge",  "pattern batcalc.hge(X_0:bat[:bit], 
X_1:bat[:oid]):bat[:hge] ", "CMDconvertsignal_hge;",        ""      ]
 [ "batcalc",   "hge",  "pattern batcalc.hge(X_0:bat[:bte]):bat[:hge] ",        
"CMDconvertsignal_hge;",        ""      ]
@@ -6729,8 +6725,10 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "hge_noerror",  "pattern batcalc.hge_noerror(X_0:bat[:sht], 
X_1:bat[:oid]):bat[:hge] ", "CMDconvert_hge;",      ""      ]
 [ "batcalc",   "hge_noerror",  "pattern 
batcalc.hge_noerror(X_0:bat[:str]):bat[:hge] ",        "CMDconvert_hge;",      
""      ]
 [ "batcalc",   "hge_noerror",  "pattern batcalc.hge_noerror(X_0:bat[:str], 
X_1:bat[:oid]):bat[:hge] ", "CMDconvert_hge;",      ""      ]
-[ "batcalc",   "identity",     "command 
batcalc.identity(X_0:bat[:any]):bat[:oid] ",   "BATSQLidentity;",      ""      ]
+[ "batcalc",   "identity",     "pattern 
batcalc.identity(X_0:bat[:any]):bat[:oid] ",   "BATSQLidentity;",      ""      ]
+[ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:bat[:oid]):bat[:oid] ",    "BATSQLidentity;",      ""      ]
 [ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:oid) (X_2:bat[:oid], X_3:oid) ",   "PBATSQLidentity;",     ""      ]
+[ "batcalc",   "identity",     "pattern batcalc.identity(X_0:bat[:any], 
X_1:oid, X_2:bat[:oid]) (X_3:bat[:oid], X_4:oid) ",    "PBATSQLidentity;",     
""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:any_1, X_2:any_1):bat[:any_1] ", "CMDifthen;",   ""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:any_1, X_2:bat[:any_1]):bat[:any_1] ",   "CMDifthen;",   ""      ]
 [ "batcalc",   "ifthenelse",   "pattern batcalc.ifthenelse(X_0:bat[:bit], 
X_1:bat[:any_1], X_2:any_1):bat[:any_1] ",   "CMDifthen;",   ""      ]
@@ -7896,7 +7894,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:lng, X_1:bat[:lng], 
X_2:bat[:oid]):bat[:lng] ", "CMDbatOR;",    ""      ]
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:sht, X_1:bat[:sht]):bat[:sht] 
",        "CMDbatOR;",    ""      ]
 [ "batcalc",   "or",   "pattern batcalc.or(X_0:sht, X_1:bat[:sht], 
X_2:bat[:oid]):bat[:sht] ", "CMDbatOR;",    ""      ]
-[ "batcalc",   "rotate_xor_hash",      "command 
batcalc.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1]):bat[:int] ",  
"MKEYbulk_rotate_xor_hash;",    ""      ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bat[:bte], X_1:bte, 
X_2:bat[:oid], X_3:int, X_4:int):bat[:bte] ",    "bte_bat_round_wrap;",  ""     
 ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bat[:bte], X_1:bte, 
X_2:int, X_3:int):bat[:bte] ",   "bte_bat_round_wrap;",  ""      ]
 [ "batcalc",   "round",        "pattern batcalc.round(X_0:bte, X_1:bat[:bte], 
X_2:bat[:oid], X_3:int, X_4:int):bat[:bte] ",    "bte_bat_round_wrap_cst;",     
 ""      ]
@@ -8481,7 +8478,14 @@ stdout of test 'MAL-signatures` in direc
 [ "batgeom",   "mbr",  "command batgeom.mbr(X_0:bat[:wkb]):bat[:mbr] ",        
"wkbMBR_bat;",  ""      ]
 [ "batgeom",   "setSRID",      "command batgeom.setSRID(X_0:bat[:wkb], 
X_1:int):bat[:wkb] ",   "wkbSetSRID_bat;",      ""      ]
 [ "batmal",    "multiplex",    "pattern batmal.multiplex(X_0:str, X_1:str, 
X_2:any...):any... ",       "MANIFOLDremapMultiplex;",      ""      ]
-[ "batmkey",   "hash", "command batmkey.hash(X_0:bat[:any_1]):bat[:lng] ",     
"MKEYbathash;", ""      ]
+[ "batmkey",   "hash", "pattern batmkey.hash(X_0:bat[:any]):bat[:lng] ",       
"MKEYbathash;", ""      ]
+[ "batmkey",   "hash", "pattern batmkey.hash(X_0:bat[:any], 
X_1:bat[:oid]):bat[:lng] ",        "MKEYbathash;", ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1]):bat[:lng] ",  
"MKEYbulk_rotate_xor_hash;",    ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:bat[:any_1], X_3:bat[:oid], 
X_4:bat[:oid]):bat[:lng] ",    "MKEYbulk_rotate_xor_hash;",    ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:any):bat[:lng] ",  
"MKEYbulkconst_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:bat[:lng], X_1:int, X_2:any, 
X_3:bat[:oid]):bat[:lng] ",   "MKEYbulkconst_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:lng, X_1:int, X_2:bat[:any_1]):bat[:lng] ",        
"MKEYconstbulk_rotate_xor_hash;",       ""      ]
+[ "batmkey",   "rotate_xor_hash",      "pattern 
batmkey.rotate_xor_hash(X_0:lng, X_1:int, X_2:bat[:any_1], 
X_3:bat[:oid]):bat[:lng] ", "MKEYconstbulk_rotate_xor_hash;",       ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:dbl]):bat[:dbl] ",      
"CMDscience_bat_acos;", ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",       "CMDscience_bat_acos;", ""      ]
 [ "batmmath",  "acos", "pattern batmmath.acos(X_0:bat[:flt]):bat[:flt] ",      
"CMDscience_bat_acos;", ""      ]
@@ -8586,8 +8590,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",    "CMDscience_bat_radians;",      ""      ]
 [ "batmmath",  "radians",      "pattern 
batmmath.radians(X_0:bat[:flt]):bat[:flt] ",   "CMDscience_bat_radians;",      
""      ]
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_0:bat[:flt], 
X_1:bat[:oid]):bat[:flt] ",    "CMDscience_bat_radians;",      ""      ]
-[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:int]):bat[:int] 
",       "CMDscience_bat_randintarg;",   ""      ]
-[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:int], 
X_1:bat[:oid]):bat[:int] ",        "CMDscience_bat_randintarg;",   ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:any]):bat[:int] 
",       "CMDscience_bat_randintarg;",   ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_0:bat[:any], 
X_1:bat[:oid]):bat[:int] ",        "CMDscience_bat_randintarg;",   ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:dbl]):bat[:dbl] ",       
"CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:dbl], 
X_1:bat[:oid]):bat[:dbl] ",        "CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_0:bat[:flt]):bat[:flt] ",       
"CMDscience_bat_sin;",  ""      ]
@@ -8907,9 +8911,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:bat[:str], 
X_1:bat[:str]):bat[:lng] ",    "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:bat[:str], 
X_1:str):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:bte] ",      "BATSTRindex_bte;",     ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:int] ",      "BATSTRindex_int;",     ""      ]
-[ "batsql",    "index",        "command batsql.index(X_0:bat[:str], 
X_1:bit):bat[:sht] ",      "BATSTRindex_sht;",     ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:any, 
X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ",   "SQLlag;",      ""      
]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:bat[:any], 
X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1] ",   "SQLlag;",      ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_0:any_1, X_1:bat[:any], 
X_2:any_2, X_3:any_3):bat[:any_1] ",      "SQLlag;",      ""      ]
@@ -8985,7 +8986,6 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:str] ",        "SQLstrgroup_concat;",  ""      ]
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:bat[:str], X_1:str, X_2:any, X_3:any, X_4:int, 
X_5:any, X_6:any):bat[:str] ",      "SQLstrgroup_concat;",  ""      ]
 [ "batsql",    "str_group_concat",     "pattern 
batsql.str_group_concat(X_0:str, X_1:bat[:str], X_2:any, X_3:any, X_4:int, 
X_5:any, X_6:any):bat[:str] ",      "SQLstrgroup_concat;",  ""      ]
-[ "batsql",    "strings",      "command 
batsql.strings(X_0:bat[:str]):bat[:str] ",     "BATSTRstrings;",       ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:bte], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:hge] ",    "SQLsum;",      ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:bte], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:lng] ",    "SQLsum;",      ""      ]
 [ "batsql",    "sum",  "pattern batsql.sum(X_0:bat[:dbl], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:dbl] ",    "SQLsum;",      ""      ]
@@ -9197,7 +9197,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batudf",    "fuse", "command batudf.fuse(X_0:bat[:sht], 
X_1:bat[:sht]):bat[:int] ", "UDFBATfuse;",  ""      ]
 [ "batudf",    "reverse",      "command 
batudf.reverse(X_0:bat[:str]):bat[:str] ",     "UDFBATreverse;",       ""      ]
 [ "batuuid",   "isaUUID",      "command 
batuuid.isaUUID(X_0:bat[:str]):bat[:bit] ",    "UUIDisaUUID_bulk;",    ""      ]
-[ "batuuid",   "new",  "unsafe command batuuid.new(X_0:bat[:int]):bat[:uuid] 
",        "UUIDgenerateUuidInt_bulk;",    ""      ]
+[ "batuuid",   "new",  "unsafe command batuuid.new(X_0:bat[:any]):bat[:uuid] 
",        "UUIDgenerateUuidInt_bulk;",    ""      ]
 [ "batxml",    "attribute",    "command batxml.attribute(X_0:str, 
X_1:bat[:str]):bat[:xml] ",  "BATXMLattribute;",     ""      ]
 [ "batxml",    "comment",      "command 
batxml.comment(X_0:bat[:str]):bat[:xml] ",     "BATXMLcomment;",       ""      ]
 [ "batxml",    "concat",       "command batxml.concat(X_0:bat[:xml], 
X_1:bat[:xml]):bat[:xml] ",       "BATXMLconcat;",        ""      ]
@@ -11064,16 +11064,6 @@ stdout of test 'MAL-signatures` in direc
 [ "calc",      "flt",  "command calc.flt(X_0:int, X_1:sht):flt ",      
"sht_dec2_flt;",        ""      ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to