Changeset: a012d4d677e0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a012d4d677e0
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
Branch: unlock
Log Message:

approved output


diffs (truncated from 1554 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
@@ -627,47 +627,31 @@ stdout of test 'MAL-signatures` in direc
 [ "algebra",   "crossproduct", "command algebra.crossproduct(X_1:bat[:any_1], 
X_2:bat[:any_2], X_3:bit):bat[:oid] ",   "ALGcrossproduct1;",    ""      ]
 [ "algebra",   "crossproduct", "command algebra.crossproduct(X_2:bat[:any_1], 
X_3:bat[:any_2], X_4:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      
"ALGcrossproduct2;",    ""      ]
 [ "algebra",   "difference",   "command algebra.difference(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",     "ALGdifference;",       ""      ]
-[ "algebra",   "difference",   "command algebra.difference(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",       "ALGdifference;",       ""      ]
-[ "algebra",   "difference",   "command algebra.difference(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",       "ALGdifference;",       ""      ]
 [ "algebra",   "exist",        "command algebra.exist(X_1:bat[:any_1], 
X_2:any_1):bit ",       "ALGexist;",    ""      ]
 [ "algebra",   "fetch",        "command algebra.fetch(X_1:bat[:any_1], 
X_2:oid):any_1 ",       "ALGfetchoid;", ""      ]
 [ "algebra",   "find", "command algebra.find(X_1:bat[:any_1], X_2:any_1):oid 
",        "ALGfind;",     ""      ]
 [ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit):bat[:oid] ",  
 "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], 
X_2:bat[:oid], X_3:lng, X_4:bit, X_5:bit, X_6:bit):bat[:oid] ",  "ALGfirstn;",  
 ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], X_2:lng, 
X_3:bit, X_4:bit, X_5:bit):bat[:oid] ", "ALGfirstn;",   ""      ]
 [ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], 
X_3:bat[:oid], X_4:bat[:oid], X_5:lng, X_6:bit, X_7:bit, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",      "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], 
X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ",     "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], X_3:lng, 
X_4:bit, X_5:bit, X_6:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   
""      ]
 [ "algebra",   "groupby",      "command algebra.groupby(X_1:bat[:oid], 
X_2:bat[:lng]):bat[:oid] ",     "ALGgroupby;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(X_1:str, X_2:str):bit ", 
"PCREilike2;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(X_1:str, X_2:str, 
X_3:str):bit ",        "PCREilike3;",  ""      ]
 [ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, 
X_7:bit):bat[:oid] ",  "ILIKEjoin1;",  ""      ]
 [ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",     "ILIKEjoin;",   ""      ]
-[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:str, X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ", "ILIKEjoin_esc1;",      ""      ]
-[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:str, X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ILIKEjoin_esc;",       ""      ]
+[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",   "ILIKEjoin_esc1;",      ""      ]
+[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:str], X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      "ILIKEjoin_esc;",       ""      
]
 [ "algebra",   "ilikeselect",  "command algebra.ilikeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit):bat[:oid] ",      "PCRElikeselect1;", 
    ""      ]
 [ "algebra",   "ilikeselect",  "command algebra.ilikeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:bit):bat[:oid] ",       "PCRElikeselect4;",     ""  
    ]
 [ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",      "ALGintersect;",        ""      ]
-[ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGintersect;",        ""      ]
-[ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGintersect;",        ""      ]
 [ "algebra",   "join", "command algebra.join(X_1:bat[:any_1], X_2:bat[:any_1], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",    "ALGjoin1;",    
""      ]
-[ "algebra",   "join", "command algebra.join(X_1:bat[:any_1], X_2:bat[:msk], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",      "ALGjoin1;",  
  ""      ]
-[ "algebra",   "join", "command algebra.join(X_1:bat[:msk], X_2:bat[:any_1], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",      "ALGjoin1;",  
  ""      ]
 [ "algebra",   "join", "command algebra.join(X_2:bat[:any_1], X_3:bat[:any_1], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
",       "ALGjoin;",     ""      ]
-[ "algebra",   "join", "command algebra.join(X_2:bat[:any_1], X_3:bat[:msk], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
", "ALGjoin;",     ""      ]
-[ "algebra",   "join", "command algebra.join(X_2:bat[:msk], X_3:bat[:any_1], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
", "ALGjoin;",     ""      ]
 [ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",   
     "ALGleftjoin1;",        ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",  
"ALGleftjoin1;",        ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",  
"ALGleftjoin1;",        ""      ]
 [ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:any_1], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGleftjoin;", ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:any_1], 
X_3:bat[:msk], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], 
X_1:bat[:oid]) ",     "ALGleftjoin;", ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:msk], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",     "ALGleftjoin;", ""      ]
 [ "algebra",   "like", "command algebra.like(X_1:str, X_2:str):bit ",  
"PCRElike2;",   ""      ]
 [ "algebra",   "like", "command algebra.like(X_1:str, X_2:str, X_3:str):bit ", 
"PCRElike3;",   ""      ]
 [ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, 
X_7:bit):bat[:oid] ",   "LIKEjoin1;",   ""      ]
 [ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",      "LIKEjoin;",    ""      ]
-[ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:str, X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",  "LIKEjoin_esc1;",       ""      ]
-[ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:str, X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",     "LIKEjoin_esc;",        ""      ]
+[ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",    "LIKEjoin_esc1;",       ""      ]
+[ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:str], X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",       "LIKEjoin_esc;",        ""     
 ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit, X_6:bit):bat[:oid] ",      
"PCRElikeselect2;",     ""      ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit):bat[:oid] ",       
"PCRElikeselect3;",     ""      ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:bit):bat[:oid] ",        "PCRElikeselect5;",     "" 
     ]
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
@@ -744,47 +744,31 @@ stdout of test 'MAL-signatures` in direc
 [ "algebra",   "crossproduct", "command algebra.crossproduct(X_1:bat[:any_1], 
X_2:bat[:any_2], X_3:bit):bat[:oid] ",   "ALGcrossproduct1;",    ""      ]
 [ "algebra",   "crossproduct", "command algebra.crossproduct(X_2:bat[:any_1], 
X_3:bat[:any_2], X_4:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      
"ALGcrossproduct2;",    ""      ]
 [ "algebra",   "difference",   "command algebra.difference(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",     "ALGdifference;",       ""      ]
-[ "algebra",   "difference",   "command algebra.difference(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",       "ALGdifference;",       ""      ]
-[ "algebra",   "difference",   "command algebra.difference(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",       "ALGdifference;",       ""      ]
 [ "algebra",   "exist",        "command algebra.exist(X_1:bat[:any_1], 
X_2:any_1):bit ",       "ALGexist;",    ""      ]
 [ "algebra",   "fetch",        "command algebra.fetch(X_1:bat[:any_1], 
X_2:oid):any_1 ",       "ALGfetchoid;", ""      ]
 [ "algebra",   "find", "command algebra.find(X_1:bat[:any_1], X_2:any_1):oid 
",        "ALGfind;",     ""      ]
 [ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], 
X_2:bat[:oid], X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit):bat[:oid] ",  
 "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], 
X_2:bat[:oid], X_3:lng, X_4:bit, X_5:bit, X_6:bit):bat[:oid] ",  "ALGfirstn;",  
 ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_1:bat[:any], X_2:lng, 
X_3:bit, X_4:bit, X_5:bit):bat[:oid] ", "ALGfirstn;",   ""      ]
 [ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], 
X_3:bat[:oid], X_4:bat[:oid], X_5:lng, X_6:bit, X_7:bit, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",      "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], 
X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ",     "ALGfirstn;",   ""      ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(X_2:bat[:any], X_3:lng, 
X_4:bit, X_5:bit, X_6:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   
""      ]
 [ "algebra",   "groupby",      "command algebra.groupby(X_1:bat[:oid], 
X_2:bat[:lng]):bat[:oid] ",     "ALGgroupby;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(X_1:str, X_2:str):bit ", 
"PCREilike2;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(X_1:str, X_2:str, 
X_3:str):bit ",        "PCREilike3;",  ""      ]
 [ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, 
X_7:bit):bat[:oid] ",  "ILIKEjoin1;",  ""      ]
 [ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",     "ILIKEjoin;",   ""      ]
-[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:str, X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ", "ILIKEjoin_esc1;",      ""      ]
-[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:str, X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ILIKEjoin_esc;",       ""      ]
+[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",   "ILIKEjoin_esc1;",      ""      ]
+[ "algebra",   "ilikejoin",    "command algebra.ilikejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:str], X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      "ILIKEjoin_esc;",       ""      
]
 [ "algebra",   "ilikeselect",  "command algebra.ilikeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit):bat[:oid] ",      "PCRElikeselect1;", 
    ""      ]
 [ "algebra",   "ilikeselect",  "command algebra.ilikeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:bit):bat[:oid] ",       "PCRElikeselect4;",     ""  
    ]
 [ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",      "ALGintersect;",        ""      ]
-[ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGintersect;",        ""      ]
-[ "algebra",   "intersect",    "command algebra.intersect(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGintersect;",        ""      ]
 [ "algebra",   "join", "command algebra.join(X_1:bat[:any_1], X_2:bat[:any_1], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",    "ALGjoin1;",    
""      ]
-[ "algebra",   "join", "command algebra.join(X_1:bat[:any_1], X_2:bat[:msk], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",      "ALGjoin1;",  
  ""      ]
-[ "algebra",   "join", "command algebra.join(X_1:bat[:msk], X_2:bat[:any_1], 
X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",      "ALGjoin1;",  
  ""      ]
 [ "algebra",   "join", "command algebra.join(X_2:bat[:any_1], X_3:bat[:any_1], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
",       "ALGjoin;",     ""      ]
-[ "algebra",   "join", "command algebra.join(X_2:bat[:any_1], X_3:bat[:msk], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
", "ALGjoin;",     ""      ]
-[ "algebra",   "join", "command algebra.join(X_2:bat[:msk], X_3:bat[:any_1], 
X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], X_1:bat[:oid]) 
", "ALGjoin;",     ""      ]
 [ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",   
     "ALGleftjoin1;",        ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",  
"ALGleftjoin1;",        ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng):bat[:oid] ",  
"ALGleftjoin1;",        ""      ]
 [ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:any_1], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGleftjoin;", ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:any_1], 
X_3:bat[:msk], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) (X_0:bat[:oid], 
X_1:bat[:oid]) ",     "ALGleftjoin;", ""      ]
-[ "algebra",   "leftjoin",     "command algebra.leftjoin(X_2:bat[:msk], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",     "ALGleftjoin;", ""      ]
 [ "algebra",   "like", "command algebra.like(X_1:str, X_2:str):bit ",  
"PCRElike2;",   ""      ]
 [ "algebra",   "like", "command algebra.like(X_1:str, X_2:str, X_3:str):bit ", 
"PCRElike3;",   ""      ]
 [ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, 
X_7:bit):bat[:oid] ",   "LIKEjoin1;",   ""      ]
 [ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",      "LIKEjoin;",    ""      ]
-[ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:str, X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",  "LIKEjoin_esc1;",       ""      ]
-[ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:str, X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",     "LIKEjoin_esc;",        ""      ]
+[ "algebra",   "likejoin",     "command algebra.likejoin(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, 
X_8:bit):bat[:oid] ",    "LIKEjoin_esc1;",       ""      ]
+[ "algebra",   "likejoin",     "command algebra.likejoin(X_2:bat[:str], 
X_3:bat[:str], X_4:bat[:str], X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, 
X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",       "LIKEjoin_esc;",        ""     
 ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit, X_6:bit):bat[:oid] ",      
"PCRElikeselect2;",     ""      ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:str, X_5:bit):bat[:oid] ",       
"PCRElikeselect3;",     ""      ]
 [ "algebra",   "likeselect",   "command algebra.likeselect(X_1:bat[:str], 
X_2:bat[:oid], X_3:str, X_4:bit):bat[:oid] ",        "PCRElikeselect5;",     "" 
     ]
@@ -794,15 +778,9 @@ stdout of test 'MAL-signatures` in direc
 [ "algebra",   "not_like",     "command algebra.not_like(X_1:str, X_2:str, 
X_3:str):bit ",     "PCREnotlike3;",        ""      ]
 [ "algebra",   "orderidx",     "command algebra.orderidx(X_1:bat[:any_1], 
X_2:bit):bat[:any_1] ",      "OIDXorderidx;",        ""      ]
 [ "algebra",   "outerjoin",    "command algebra.outerjoin(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",      "ALGouterjoin1;",       ""      ]
-[ "algebra",   "outerjoin",    "command algebra.outerjoin(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGouterjoin1;",       ""      ]
-[ "algebra",   "outerjoin",    "command algebra.outerjoin(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGouterjoin1;",       ""      ]
 [ "algebra",   "outerjoin",    "command algebra.outerjoin(X_2:bat[:any_1], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ", "ALGouterjoin;",        ""      ]
-[ "algebra",   "outerjoin",    "command algebra.outerjoin(X_2:bat[:any_1], 
X_3:bat[:msk], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGouterjoin;",        ""      ]
-[ "algebra",   "outerjoin",    "command algebra.outerjoin(X_2:bat[:msk], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGouterjoin;",        ""      ]
 [ "algebra",   "project",      "pattern algebra.project(X_1:bat[:any_1], 
X_2:any_3):bat[:any_3] ",     "ALGprojecttail;",      ""      ]
-[ "algebra",   "projection",   "command algebra.projection(X_1:bat[:msk], 
X_2:bat[:any_3], X_3:bat[:any_3]):bat[:any_3] ",     "ALGprojection2;",      "" 
     ]
 [ "algebra",   "projection",   "command algebra.projection(X_1:bat[:oid], 
X_2:bat[:any_3], X_3:bat[:any_3]):bat[:any_3] ",     "ALGprojection2;",      "" 
     ]
-[ "algebra",   "projection",   "command algebra.projection(X_1:bat[:msk], 
X_2:bat[:any_3]):bat[:any_3] ",      "ALGprojection;",       ""      ]
 [ "algebra",   "projection",   "command algebra.projection(X_1:bat[:oid], 
X_2:bat[:any_3]):bat[:any_3] ",      "ALGprojection;",       ""      ]
 [ "algebra",   "projectionpath",       "pattern 
algebra.projectionpath(X_1:bat[:any]...):bat[:any] ",  "ALGprojectionpath;",   
""      ]
 [ "algebra",   "rangejoin",    "command algebra.rangejoin(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, 
X_7:bit, X_8:bit, X_9:bit, X_10:lng):bat[:oid] ",  "ALGrangejoin1;",       ""   
   ]
@@ -814,8 +792,6 @@ stdout of test 'MAL-signatures` in direc
 [ "algebra",   "select",       "command algebra.select(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:any_1, X_4:any_1, X_5:bit, X_6:bit, X_7:bit, 
X_8:bit):bat[:oid] ",  "ALGselect2nil;",       ""      ]
 [ "algebra",   "selectNotNil", "command 
algebra.selectNotNil(X_1:bat[:any_2]):bat[:any_2] ",   "ALGselectNotNil;",     
""      ]
 [ "algebra",   "semijoin",     "command algebra.semijoin(X_2:bat[:any_1], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",  "ALGsemijoin;", ""      ]
-[ "algebra",   "semijoin",     "command algebra.semijoin(X_2:bat[:any_1], 
X_3:bat[:msk], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGsemijoin;", ""      ]
-[ "algebra",   "semijoin",     "command algebra.semijoin(X_2:bat[:msk], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGsemijoin;", ""      ]
 [ "algebra",   "slice",        "command algebra.slice(X_1:bat[:any_1], 
X_2:lng, X_3:lng):bat[:any_1] ",        "ALGslice;",    ""      ]
 [ "algebra",   "slice",        "command algebra.slice(X_1:bat[:any_1], 
X_2:int, X_3:int):bat[:any_1] ",        "ALGslice_int;",        ""      ]
 [ "algebra",   "slice",        "command algebra.slice(X_1:bat[:any_1], 
X_2:lng, X_3:lng):bat[:any_1] ",        "ALGslice_lng;",        ""      ]
@@ -831,15 +807,9 @@ stdout of test 'MAL-signatures` in direc
 [ "algebra",   "sort", "command algebra.sort(X_3:bat[:any_1], X_4:bat[:oid], 
X_5:bat[:oid], X_6:bit, X_7:bit, X_8:bit) (X_0:bat[:any_1], X_1:bat[:oid], 
X_2:bat[:oid]) ",      "ALGsort33;",   ""      ]
 [ "algebra",   "subslice",     "command algebra.subslice(X_1:bat[:any_1], 
X_2:lng, X_3:lng):bat[:oid] ",       "ALGsubslice_lng;",     ""      ]
 [ "algebra",   "thetajoin",    "command algebra.thetajoin(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:bit, 
X_7:lng):bat[:oid] ",      "ALGthetajoin1;",       ""      ]
-[ "algebra",   "thetajoin",    "command algebra.thetajoin(X_1:bat[:any_1], 
X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGthetajoin1;",       ""      ]
-[ "algebra",   "thetajoin",    "command algebra.thetajoin(X_1:bat[:msk], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:int, X_6:bit, 
X_7:lng):bat[:oid] ",        "ALGthetajoin1;",       ""      ]
 [ "algebra",   "thetajoin",    "command algebra.thetajoin(X_2:bat[:any_1], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:int, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ", "ALGthetajoin;",        ""      ]
-[ "algebra",   "thetajoin",    "command algebra.thetajoin(X_2:bat[:any_1], 
X_3:bat[:msk], X_4:bat[:oid], X_5:bat[:oid], X_6:int, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGthetajoin;",        ""      ]
-[ "algebra",   "thetajoin",    "command algebra.thetajoin(X_2:bat[:msk], 
X_3:bat[:any_1], X_4:bat[:oid], X_5:bat[:oid], X_6:int, X_7:bit, X_8:lng) 
(X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGthetajoin;",        ""      ]
-[ "algebra",   "thetaselect",  "command algebra.thetaselect(X_1:bat[:any_1], 
X_2:any_1, X_3:str):bat[:oid] ",  "ALGthetaselect1;",     ""      ]
 [ "algebra",   "thetaselect",  "command algebra.thetaselect(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:any_1, X_4:str):bat[:oid] ",   "ALGthetaselect2;",     ""    
  ]
-[ "algebra",   "unique",       "command 
algebra.unique(X_1:bat[:any_1]):bat[:oid] ",   "ALGunique1;",  ""      ]
-[ "algebra",   "unique",       "command algebra.unique(X_1:bat[:any_1], 
X_2:bat[:oid]):bat[:oid] ",    "ALGunique2;",  ""      ]
+[ "algebra",   "unique",       "command algebra.unique(X_1:bat[:any_1], 
X_2:bat[:oid]):bat[:oid] ",    "ALGunique;",   ""      ]
 [ "bat",       "append",       "command bat.append(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid], X_4:bit):bat[:any_1] ",    
"BKCappend_cand_force_wrap;",   ""      ]
 [ "bat",       "append",       "command bat.append(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bat[:oid]):bat[:any_1] ",     "BKCappend_cand_wrap;", ""   
   ]
 [ "bat",       "append",       "command bat.append(X_1:bat[:any_1], 
X_2:bat[:any_1], X_3:bit):bat[:any_1] ",   "BKCappend_force_wrap;",        ""   
   ]
@@ -11887,21 +11857,13 @@ stdout of test 'MAL-signatures` in direc
 [ "generator", "series",       "pattern generator.series(X_1:sht, X_2:sht, 
X_3:sht):bat[:sht] ",       "VLTgenerator_table;",  ""      ]
 [ "generator", "series",       "pattern generator.series(X_1:timestamp, 
X_2:timestamp, X_3:lng):bat[:timestamp] ",     "VLTgenerator_table;",  ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:bte], 
X_2:bat[:oid], X_3:bte, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:bte], 
X_2:bte, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:dbl], 
X_2:bat[:oid], X_3:dbl, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:dbl], 
X_2:dbl, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:flt], 
X_2:bat[:oid], X_3:flt, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:flt], 
X_2:flt, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:hge], 
X_2:bat[:oid], X_3:hge, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:hge], 
X_2:hge, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:int], 
X_2:bat[:oid], X_3:int, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:int], 
X_2:int, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:lng], 
X_2:bat[:oid], X_3:lng, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:lng], 
X_2:lng, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:sht], 
X_2:bat[:oid], X_3:sht, X_4:str):bat[:oid] ",     
"VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern generator.thetaselect(X_1:bat[:sht], 
X_2:sht, X_3:str):bat[:oid] ",    "VLTgenerator_thetasubselect;", ""      ]
 [ "generator", "thetaselect",  "pattern 
generator.thetaselect(X_1:bat[:timestamp], X_2:bat[:oid], X_3:timestamp, 
X_4:str):bat[:oid] ", "VLTgenerator_thetasubselect;", ""      ]
-[ "generator", "thetaselect",  "pattern 
generator.thetaselect(X_1:bat[:timestamp], X_2:timestamp, X_3:str):bat[:oid] ", 
       "VLTgenerator_thetasubselect;", ""      ]
 [ "geom",      "Area", "command geom.Area(X_1:wkb):dbl ",      "wkbArea;",     
""      ]
 [ "geom",      "AsBinary",     "command geom.AsBinary(X_1:wkb):str ",  
"wkbAsBinary;", ""      ]
 [ "geom",      "AsEWKT",       "function geom.AsEWKT(w:wkb):str;",     "",     
""      ]
@@ -12157,7 +12119,7 @@ stdout of test 'MAL-signatures` in direc
 [ "iterator",  "next", "command iterator.next(X_1:lng, X_2:lng):lng ", 
"ITRnext_lng;", ""      ]
 [ "iterator",  "next", "command iterator.next(X_1:oid, X_2:oid):oid ", 
"ITRnext_oid;", ""      ]
 [ "iterator",  "next", "command iterator.next(X_1:sht, X_2:sht):sht ", 
"ITRnext_sht;", ""      ]
-[ "json",      "dump", "pattern json.dump(X_1:json):void ",    "JSONdump;",    
""      ]
+[ "json",      "dump", "pattern json.dump(X_1:json):bat[:str] ",       
"JSONdump;",    ""      ]
 [ "json",      "filter",       "command json.filter(X_1:json, X_2:str):json ", 
"JSONfilter;",  ""      ]
 [ "json",      "filter",       "command json.filter(X_1:json, X_2:bte, 
X_3:str):json ",        "JSONfilterArrayDefault_bte;",  ""      ]
 [ "json",      "filter",       "command json.filter(X_1:json, X_2:hge, 
X_3:str):json ",        "JSONfilterArrayDefault_hge;",  ""      ]
@@ -12280,13 +12242,6 @@ stdout of test 'MAL-signatures` in direc
 [ "mapi",      "suspend",      "command mapi.suspend():void ", 
"SERVERsuspend;",       ""      ]
 [ "mapi",      "trace",        "command mapi.trace(X_1:int, X_2:int):void ",   
"SERVERtrace;", ""      ]
 [ "mask",      "mask", "pattern mask.mask(X_1:bat[:oid]):bat[:msk] ",  
"MSKmask;",     ""      ]
-[ "mask",      "select",       "command mask.select(X_1:bat[:any_1], 
X_2:any_1, X_3:any_1, X_4:bit, X_5:bit, X_6:bit):bat[:oid] ",     
"MSKselect1;",  ""      ]
-[ "mask",      "select",       "command mask.select(X_1:bat[:any_1], 
X_2:any_1, X_3:any_1, X_4:bit, X_5:bit, X_6:bit, X_7:bit):bat[:oid] ",    
"MSKselect1nil;",       ""      ]
-[ "mask",      "select",       "command mask.select(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:any_1, X_4:any_1, X_5:bit, X_6:bit, X_7:bit):bat[:oid] ",    
  "MSKselect2;",  ""      ]
-[ "mask",      "select",       "command mask.select(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:any_1, X_4:any_1, X_5:bit, X_6:bit, X_7:bit, 
X_8:bit):bat[:oid] ",     "MSKselect2nil;",       ""      ]
-[ "mask",      "selectNotNil", "command 
mask.selectNotNil(X_1:bat[:any_2]):bat[:any_2] ",      "MSKselectNotNil;",     
""      ]
-[ "mask",      "thetaselect",  "command mask.thetaselect(X_1:bat[:any_1], 
X_2:any_1, X_3:str):bat[:oid] ",     "MSKthetaselect1;",     ""      ]
-[ "mask",      "thetaselect",  "command mask.thetaselect(X_1:bat[:any_1], 
X_2:bat[:oid], X_3:any_1, X_4:str):bat[:oid] ",      "MSKthetaselect2;",     "" 
     ]
 [ "mask",      "umask",        "pattern mask.umask(X_1:bat[:msk]):bat[:oid] ", 
"MSKumask;",    ""      ]
 [ "mat",       "new",  "pattern mat.new(X_1:bat[:any_2]...):bat[:any_2] ",     
"MATpack;",     ""      ]
 [ "mat",       "pack", "pattern mat.pack(X_1:bat[:any_2]...):bat[:any_2] ",    
"MATpack;",     ""      ]
@@ -12471,6 +12426,8 @@ stdout of test 'MAL-signatures` in direc
 [ "oltp",      "table",        "unsafe pattern oltp.table() 
(X_0:bat[:timestamp], X_1:bat[:str], X_2:bat[:int], X_3:bat[:int]) ",      
"OLTPtable;",   ""      ]
 [ "optimizer", "aliases",      "pattern optimizer.aliases():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "aliases",      "pattern optimizer.aliases(X_1:str, 
X_2:str):str ",     "OPTwrapper;",  ""      ]
+[ "optimizer", "bincopyfrom",  "pattern optimizer.bincopyfrom():str ", 
"OPTwrapper;",  ""      ]
+[ "optimizer", "bincopyfrom",  "pattern optimizer.bincopyfrom(X_1:str, 
X_2:str):str ", "OPTwrapper;",  ""      ]
 [ "optimizer", "candidates",   "pattern optimizer.candidates():str ",  
"OPTwrapper;",  ""      ]
 [ "optimizer", "candidates",   "pattern optimizer.candidates(X_1:str, 
X_2:str):str ",  "OPTwrapper;",  ""      ]
 [ "optimizer", "coercions",    "pattern optimizer.coercions():str ",   
"OPTwrapper;",  ""      ]
@@ -12512,8 +12469,8 @@ stdout of test 'MAL-signatures` in direc
 [ "optimizer", "minimal_pipe", "function optimizer.minimal_pipe():void;",      
"",     ""      ]
 [ "optimizer", "mitosis",      "pattern optimizer.mitosis():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "mitosis",      "pattern optimizer.mitosis(X_1:str, 
X_2:str):str ",     "OPTwrapper;",  ""      ]
-[ "optimizer", "multiplex",    "pattern optimizer.multiplex():void ",  
"OPTwrapper;",  ""      ]
-[ "optimizer", "multiplex",    "pattern optimizer.multiplex(X_1:str, 
X_2:str):void ",  "OPTwrapper;",  ""      ]
+[ "optimizer", "multiplex",    "pattern optimizer.multiplex():str ",   
"OPTwrapper;",  ""      ]
+[ "optimizer", "multiplex",    "pattern optimizer.multiplex(X_1:str, 
X_2:str):str ",   "OPTwrapper;",  ""      ]
 [ "optimizer", "no_mitosis_pipe",      "function 
optimizer.no_mitosis_pipe():void;",   "",     ""      ]
 [ "optimizer", "oltp", "pattern optimizer.oltp():str ",        "OPTwrapper;",  
""      ]
 [ "optimizer", "oltp", "pattern optimizer.oltp(X_1:str, X_2:str):str ",        
"OPTwrapper;",  ""      ]
@@ -12521,6 +12478,8 @@ stdout of test 'MAL-signatures` in direc
 [ "optimizer", "optimize",     "pattern optimizer.optimize(X_1:str, 
X_2:str):void ",   "QOToptimize;", ""      ]
 [ "optimizer", "orcam",        "pattern optimizer.orcam(X_1:str, X_2:str):void 
",      "OPTorcam;",    ""      ]
 [ "optimizer", "orcam",        "pattern optimizer.orcam(X_1:str, X_2:str, 
X_3:str, X_4:str):void ",    "OPTorcam;",    ""      ]
+[ "optimizer", "parappend",    "pattern optimizer.parappend():str ",   
"OPTwrapper;",  ""      ]
+[ "optimizer", "parappend",    "pattern optimizer.parappend(X_1:str, 
X_2:str):str ",   "OPTwrapper;",  ""      ]
 [ "optimizer", "postfix",      "pattern optimizer.postfix():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "postfix",      "pattern optimizer.postfix(X_1:str, 
X_2:str):str ",     "OPTwrapper;",  ""      ]
 [ "optimizer", "prelude",      "pattern optimizer.prelude():void ",    
"optimizer_prelude;",   ""      ]
@@ -12604,7 +12563,7 @@ stdout of test 'MAL-signatures` in direc
 [ "remote",    "batbincopy",   "pattern remote.batbincopy(X_1:bat[:any]):void 
",       "RMTbincopyto;",        ""      ]
 [ "remote",    "batload",      "pattern remote.batload(X_1:any_1, 
X_2:int):bat[:any_1] ",      "RMTbatload;",  ""      ]
 [ "remote",    "bintype",      "pattern remote.bintype():void ",       
"RMTbintype;",  ""      ]
-[ "remote",    "connect",      "command remote.connect(X_1:str, X_2:str, 
X_3:str, X_4:str):str ",      "RMTconnect;",  ""      ]
+[ "remote",    "connect",      "pattern remote.connect(X_1:str, X_2:str, 
X_3:str, X_4:str):str ",      "RMTconnect;",  ""      ]
 [ "remote",    "connect",      "command remote.connect(X_1:str, X_2:str, 
X_3:str, X_4:str, X_5:bit):str ",     "RMTconnectScen;",      ""      ]
 [ "remote",    "connect",      "pattern remote.connect(X_1:str, X_2:str):str 
",        "RMTconnectTable;",     ""      ]
 [ "remote",    "disconnect",   "command remote.disconnect(X_1:str):void ",     
"RMTdisconnect;",       ""      ]
@@ -12639,6 +12598,9 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "analyze",      "unsafe pattern sql.analyze(X_1:int, X_2:lng, 
X_3:str, X_4:str, X_5:str):void ",        "sql_analyze;", ""      ]
 [ "sql",       "any",  "pattern sql.any(X_1:bit, X_2:bit, X_3:bit):bit ",      
"SQLany_cmp;",  ""      ]
 [ "sql",       "append",       "pattern sql.append(X_1:int, X_2:str, X_3:str, 
X_4:str, X_5:lng, X_6:any):int ",        "mvc_append_wrap;",     ""      ]
+[ "sql",       "append_exec",  "pattern sql.append_exec(X_1:ptr, X_2:lng, 
X_3:any_1):ptr ",    "mvc_append_exec_wrap;",        ""      ]
+[ "sql",       "append_finish",        "pattern sql.append_finish(X_1:int, 
X_2:ptr...):int ",  "mvc_append_finish_wrap;",      ""      ]
+[ "sql",       "append_prep",  "pattern sql.append_prep(X_2:int, X_3:str, 
X_4:str, X_5:str...) (X_0:int, X_1:ptr...) ",        "mvc_append_prep_wrap;",   
     ""      ]
 [ "sql",       "argRecord",    "pattern sql.argRecord():str ", 
"SQLargRecord;",        ""      ]
 [ "sql",       "argRecord",    "pattern sql.argRecord(X_1:any...):str ",       
"SQLargRecord;",        ""      ]
 [ "sql",       "assert",       "pattern sql.assert(X_1:bit, X_2:str):void ",   
"SQLassert;",   ""      ]
@@ -12736,9 +12698,10 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "getVersion",   "command sql.getVersion(X_1:int):lng ", 
"mvc_getVersion;",      ""      ]
 [ "sql",       "get_value",    "pattern sql.get_value(X_1:str, X_2:str):lng ", 
"mvc_get_value;",       ""      ]
 [ "sql",       "grow", "pattern sql.grow(X_1:bat[:oid], X_2:any_1):int ",      
"mvc_grow_wrap;",       ""      ]
-[ "sql",       "hot_snapshot", "unsafe command sql.hot_snapshot(X_1:str):void 
",       "SQLhot_snapshot;",     ""      ]
+[ "sql",       "hot_snapshot", "unsafe pattern sql.hot_snapshot(X_1:str):void 
",       "SQLhot_snapshot;",     ""      ]
 [ "sql",       "hot_snapshot", "unsafe pattern sql.hot_snapshot(X_1:str, 
X_2:bit):void ",      "SQLhot_snapshot_wrap;",        ""      ]
-[ "sql",       "importTable",  "unsafe pattern sql.importTable(X_1:str, 
X_2:str, X_3:int, X_4:str...):bat[:any]... ",  "mvc_bin_import_table_wrap;",   
""      ]
+[ "sql",       "importColumn", "pattern sql.importColumn(X_2:str, X_3:bit, 
X_4:str, X_5:int, X_6:oid) (X_0:bat[:any], X_1:oid) ",      
"mvc_bin_import_column_wrap;",  ""      ]
+[ "sql",       "importTable",  "unsafe pattern sql.importTable(X_1:str, 
X_2:str, X_3:int, X_4:bit, X_5:str...):bat[:any]... ", 
"mvc_bin_import_table_wrap;",   ""      ]
 [ "sql",       "include",      "pattern sql.include(X_1:str):void ",   
"SQLinclude;",  ""      ]
 [ "sql",       "index",        "command sql.index(X_1:str, X_2:bit):bte ",     
"STRindex_bte;",        ""      ]
 [ "sql",       "index",        "command sql.index(X_1:str, X_2:bit):int ",     
"STRindex_int;",        ""      ]
@@ -12793,7 +12756,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "resultSet",    "unsafe pattern sql.resultSet(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:int], X_5:bat[:int], X_6:any...):int ",  
   "mvc_row_result_wrap;", ""      ]
 [ "sql",       "resultSet",    "unsafe pattern sql.resultSet(X_1:str, X_2:str, 
X_3:str, X_4:int, X_5:int, X_6:int, X_7:any):int ",     
"mvc_scalar_value_wrap;",       ""      ]
 [ "sql",       "resultSet",    "unsafe pattern sql.resultSet(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:str], X_4:bat[:int], X_5:bat[:int], 
X_6:bat[:any]...):int ",       "mvc_table_result_wrap;",       ""      ]
-[ "sql",       "resume_log_flushing",  "unsafe command 
sql.resume_log_flushing():void ",       "SQLresume_log_flushing;",      ""      
]
+[ "sql",       "resume_log_flushing",  "unsafe pattern 
sql.resume_log_flushing():void ",       "SQLresume_log_flushing;",      ""      
]
 [ "sql",       "row_number",   "pattern sql.row_number(X_1:any_1, X_2:bit, 
X_3:bit):int ",     "SQLrow_number;",       ""      ]
 [ "sql",       "rt_credentials",       "pattern sql.rt_credentials(X_3:str) 
(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str]) ",   "sql_rt_credentials_wrap;",  
   ""      ]
 [ "sql",       "sessions",     "pattern sql.sessions() (X_0:bat[:int], 
X_1:bat[:str], X_2:bat[:timestamp], X_3:bat[:timestamp], X_4:bat[:str], 
X_5:bat[:int], X_6:bat[:int], X_7:bat[:int], X_8:bat[:int]) ",  
"sql_sessions_wrap;",   ""      ]
@@ -12840,7 +12803,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "sum",  "pattern sql.sum(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",   "SQLsum;",      ""      ]
 [ "sql",       "sum",  "pattern sql.sum(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",   "SQLsum;",      ""      ]
 [ "sql",       "sum",  "pattern sql.sum(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",   "SQLsum;",      ""      ]
-[ "sql",       "suspend_log_flushing", "unsafe command 
sql.suspend_log_flushing():void ",      "SQLsuspend_log_flushing;",     ""      
]
+[ "sql",       "suspend_log_flushing", "unsafe pattern 
sql.suspend_log_flushing():void ",      "SQLsuspend_log_flushing;",     ""      
]
 [ "sql",       "tid",  "pattern sql.tid(X_1:int, X_2:str, X_3:str):bat[:oid] 
",        "SQLtid;",      ""      ]
 [ "sql",       "tid",  "pattern sql.tid(X_1:int, X_2:str, X_3:str, X_4:int, 
X_5:int):bat[:oid] ",      "SQLtid;",      ""      ]
 [ "sql",       "transaction",  "unsafe pattern sql.transaction():void ",       
"SQLtransaction2;",     ""      ]
@@ -12851,6 +12814,8 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "transaction_rollback", "unsafe pattern 
sql.transaction_rollback(X_1:int, X_2:str):void ",      
"SQLtransaction_rollback;",     ""      ]
 [ "sql",       "unionfunc",    "pattern sql.unionfunc(X_1:str, X_2:str, 
X_3:any...):any... ",  "SQLunionfunc;",        ""      ]
 [ "sql",       "update",       "pattern sql.update(X_1:int, X_2:str, X_3:str, 
X_4:str, X_5:any, X_6:any):int ",        "mvc_update_wrap;",     ""      ]
+[ "sql",       "update_exec",  "pattern sql.update_exec(X_1:ptr, 
X_2:bat[:oid], X_3:bat[:any_1]):ptr ",        "mvc_update_exec_wrap;",        
""      ]
+[ "sql",       "update_prep",  "pattern sql.update_prep(X_2:int, X_3:str, 
X_4:str, X_5:str...) (X_0:int, X_1:ptr...) ",        "mvc_update_prep_wrap;",   
     ""      ]
 [ "sql",       "update_schemas",       "unsafe pattern 
sql.update_schemas():void ",    "SYSupdate_schemas;",   ""      ]
 [ "sql",       "update_tables",        "unsafe pattern 
sql.update_tables():void ",     "SYSupdate_tables;",    ""      ]
 [ "sql",       "variance",     "pattern sql.variance(X_1:bte, X_2:bit, 
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ",      "SQLvar_samp;", ""      ]
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -344,16 +344,25 @@ size_t HEAPmemsize(Heap *h);
 size_t HEAPvmsize(Heap *h);
 void IMPSdestroy(BAT *b);
 lng IMPSimprintsize(BAT *b);
+int MT_access(const char *pathname, int mode);
 int MT_check_nr_cores(void);
 int MT_create_thread(MT_Id *t, void (*function)(void *), void *arg, enum 
MT_thr_detach d, const char *threadname);
 void MT_exiting_thread(void);
+FILE *MT_fopen(const char *filename, const char *mode);
+char *MT_getcwd(char *buffer, size_t size);
 MT_Id MT_getpid(void);
 size_t MT_getrss(void);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to