Changeset: 214f28ca7220 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=214f28ca7220
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
        gdk/gdk_analytic.h
        gdk/gdk_analytic_bounds.c
        gdk/gdk_analytic_func.c
        gdk/gdk_string.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql_rank.c
        sql/common/sql_types.c
        sql/server/rel_exp.c
        sql/server/rel_exp.h
        sql/server/rel_select.c
        sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: window-tunning
Log Message:

Using oid type. This pairs with other gdk primitives and hopefully helps on 
32-bit tests


diffs (truncated from 2624 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
@@ -9355,7 +9355,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "exportResult", "unsafe pattern sql.exportResult(X_1:streams, 
X_2:int):void ",  "mvc_export_result_wrap;",      ""      ]
 [ "sql",       "export_table", "unsafe pattern sql.export_table(X_1:str, 
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str], 
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int], X_13:any...):int 
",       "mvc_export_row_wrap;", ""      ]
 [ "sql",       "export_table", "unsafe pattern sql.export_table(X_1:str, 
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str], 
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int], 
X_13:bat[:any]...):int ", "mvc_export_table_wrap;",       ""      ]
-[ "sql",       "first_value",  "pattern sql.first_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ",       "SQLfirst_value;",      ""   
   ]
+[ "sql",       "first_value",  "pattern sql.first_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",       "SQLfirst_value;",      ""   
   ]
 [ "sql",       "flush_log",    "unsafe command sql.flush_log():void ", 
"SQLflush_log;",        ""      ]
 [ "sql",       "getVariable",  "pattern sql.getVariable(X_1:int, X_2:str, 
X_3:str):any_1 ",    "getVariable;", ""      ]
 [ "sql",       "getVersion",   "command sql.getVersion(X_1:int):lng ", 
"mvc_getVersion;",      ""      ]
@@ -9371,18 +9371,18 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:any, X_3:any_1, 
X_4:bit, X_5:bit):any_1 ",      "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:any, X_3:bit, 
X_4:bit):any_1 ", "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:bit, X_3:bit):any_1 ",  
"SQLlag;",      ""      ]
-[ "sql",       "last_value",   "pattern sql.last_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ",        "SQLlast_value;",       ""  
    ]
+[ "sql",       "last_value",   "pattern sql.last_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",        "SQLlast_value;",       ""  
    ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:any_1, 
X_4:bit, X_5:bit):any_1 ",     "SQLlead;",     ""      ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:bit, 
X_4:bit):any_1 ",        "SQLlead;",     ""      ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:bit, X_3:bit):any_1 ", 
"SQLlead;",     ""      ]
 [ "sql",       "logfile",      "unsafe pattern sql.logfile(X_1:str):void ",    
"mvc_logfile;", ""      ]
-[ "sql",       "max",  "pattern sql.max(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):any_1 ",       "SQLmax;",      ""      ]
-[ "sql",       "min",  "pattern sql.min(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):any_1 ",       "SQLmin;",      ""      ]
+[ "sql",       "max",  "pattern sql.max(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):any_1 ",       "SQLmax;",      ""      ]
+[ "sql",       "min",  "pattern sql.min(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):any_1 ",       "SQLmin;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_1:dbl, X_2:int):dbl ",  
"dbl_trunc_wrap;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_1:flt, X_2:int):flt ",  
"flt_trunc_wrap;",      ""      ]
 [ "sql",       "mvc",  "pattern sql.mvc():int ",       "SQLmvc;",      ""      
]
 [ "sql",       "next_value",   "unsafe pattern sql.next_value(X_1:str, 
X_2:str):lng ", "mvc_next_value;",      ""      ]
-[ "sql",       "nth_value",    "pattern sql.nth_value(X_1:any_1, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):any_1 ",        "SQLnth_value;",   
     ""      ]
+[ "sql",       "nth_value",    "pattern sql.nth_value(X_1:any_1, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):any_1 ",        "SQLnth_value;",   
     ""      ]
 [ "sql",       "ntile",        "pattern sql.ntile(X_1:any, X_2:any_1, X_3:bit, 
X_4:bit):any_1 ",       "SQLntile;",    ""      ]
 [ "sql",       "optimizer_updates",    "pattern sql.optimizer_updates():void 
",        "SQLoptimizersUpdate;", ""      ]
 [ "sql",       "optimizers",   "command sql.optimizers() (X_0:bat[:str], 
X_1:bat[:str], X_2:bat[:str]) ",      "getPipeCatalog;",      ""      ]
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
@@ -9015,34 +9015,34 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "variancep",    "pattern batsql.variancep(X_1:bat[:int], 
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ",      "SQLvar_pop;",  
""      ]
 [ "batsql",    "variancep",    "pattern batsql.variancep(X_1:bat[:lng], 
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ",      "SQLvar_pop;",  
""      ]
 [ "batsql",    "variancep",    "pattern batsql.variancep(X_1:bat[:sht], 
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ",      "SQLvar_pop;",  
""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:bte]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:dbl]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:flt]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:hge]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:int]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:lng]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:sht]):bat[:lng] ",    "SQLwindow_bound;",   
  ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bte):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:dbl):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:flt):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:hge):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:int):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:lng):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:sht):bat[:lng] ",  "SQLwindow_bound;",     ""    
  ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:bte]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:dbl]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:flt]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:hge]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:int]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:lng]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:sht]):bat[:lng] ",     
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bte):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:dbl):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:flt):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:hge):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:int):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:lng):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
-[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:sht):bat[:lng] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:bte]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:dbl]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:flt]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:hge]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:int]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:lng]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bat[:sht]):bat[:oid] ",    "SQLwindow_bound;",   
  ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:bte):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:dbl):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:flt):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:hge):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:int):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:lng):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], 
X_2:int, X_3:int, X_4:int, X_5:sht):bat[:oid] ",  "SQLwindow_bound;",     ""    
  ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:bte]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:dbl]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:flt]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:hge]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:int]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:lng]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:sht]):bat[:oid] ",     
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bte):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:dbl):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:flt):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:hge):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:int):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:lng):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
+[ "batsql",    "window_bound", "pattern batsql.window_bound(X_1:bat[:bit], 
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:sht):bat[:oid] ",   
"SQLwindow_bound;",     ""      ]
 [ "batstr",    "ascii",        "pattern batstr.ascii(X_1:bat[:str]):bat[:int] 
",       "STRbatAscii;", ""      ]
 [ "batstr",    "ascii",        "pattern batstr.ascii(X_1:bat[:str], 
X_2:bat[:oid]):bat[:int] ",        "STRbatAscii;", ""      ]
 [ "batstr",    "endsWith",     "pattern batstr.endsWith(X_1:bat[:str], 
X_2:bat[:str]):bat[:bit] ",     "STRbatSuffix;",        ""      ]
@@ -12575,18 +12575,18 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "assert",       "pattern sql.assert(X_1:bit, X_2:str):void ",   
"SQLassert;",   ""      ]
 [ "sql",       "assert",       "pattern sql.assert(X_1:int, X_2:str):void ",   
"SQLassertInt;",        ""      ]
 [ "sql",       "assert",       "pattern sql.assert(X_1:lng, X_2:str):void ",   
"SQLassertLng;",        ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:dbl, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLavg;",      ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):bte ",   "SQLavginteger;",       ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLavginteger;",       ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):int ",   "SQLavginteger;",       ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",   "SQLavginteger;",       ""      ]
-[ "sql",       "avg",  "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):sht ",   "SQLavginteger;",       ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:dbl, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",   "SQLavg;",      ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):bte ",   "SQLavginteger;",       ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",   "SQLavginteger;",       ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):int ",   "SQLavginteger;",       ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",   "SQLavginteger;",       ""      ]
+[ "sql",       "avg",  "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):sht ",   "SQLavginteger;",       ""      ]
 [ "sql",       "bind", "pattern sql.bind(X_1:int, X_2:str, X_3:str, X_4:str, 
X_5:int):bat[:any_1] ",   "mvc_bind_wrap;",       ""      ]
 [ "sql",       "bind", "pattern sql.bind(X_1:int, X_2:str, X_3:str, X_4:str, 
X_5:int, X_6:int, X_7:int):bat[:any_1] ", "mvc_bind_wrap;",       ""      ]
 [ "sql",       "bind", "pattern sql.bind(X_2:int, X_3:str, X_4:str, X_5:str, 
X_6:int) (X_0:bat[:oid], X_1:bat[:any_1]) ",      "mvc_bind_wrap;",       ""    
  ]
@@ -12600,28 +12600,28 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "copy_from",    "unsafe pattern sql.copy_from(X_1:ptr, X_2:str, 
X_3:str, X_4:str, X_5:str, X_6:str, X_7:lng, X_8:lng, X_9:int, X_10:int, 
X_11:str, X_12:int, X_13:int):bat[:any]... ",  "mvc_import_table_wrap;",       
""      ]
 [ "sql",       "copy_rejects", "pattern sql.copy_rejects() (X_0:bat[:lng], 
X_1:bat[:int], X_2:bat[:str], X_3:bat[:str]) ",     "COPYrejects;", ""      ]
 [ "sql",       "copy_rejects_clear",   "unsafe pattern 
sql.copy_rejects_clear():void ",        "COPYrejects_clear;",   ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:bte, X_2:bte, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:dbl, X_2:dbl, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:flt, X_2:flt, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:hge, X_2:hge, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:int, X_2:int, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:lng, X_2:lng, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "corr", "pattern sql.corr(X_1:sht, X_2:sht, X_3:bit, X_4:bit, 
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;",     ""      ]
-[ "sql",       "count",        "pattern sql.count(X_1:any_1, X_2:bit, X_3:bit, 
X_4:bit, X_5:int, X_6:lng, X_7:lng):lng ",      "SQLcount;",    ""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:bte, X_2:bte, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:dbl, X_2:dbl, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:flt, X_2:flt, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:hge, X_2:hge, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:int, X_2:int, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:lng, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariance",   "pattern sql.covariance(X_1:sht, X_2:sht, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",   "SQLcovar_samp;",       
""      ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:bte, X_2:bte, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:dbl, X_2:dbl, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:flt, X_2:flt, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:hge, X_2:hge, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:int, X_2:int, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:lng, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
-[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:sht, X_2:sht, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "corr", "pattern sql.corr(X_1:bte, X_2:bte, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:dbl, X_2:dbl, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:flt, X_2:flt, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:hge, X_2:hge, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:int, X_2:int, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:lng, X_2:lng, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "corr", "pattern sql.corr(X_1:sht, X_2:sht, X_3:bit, X_4:bit, 
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;",     ""      ]
+[ "sql",       "count",        "pattern sql.count(X_1:any_1, X_2:bit, X_3:bit, 
X_4:bit, X_5:int, X_6:oid, X_7:oid):lng ",      "SQLcount;",    ""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:bte, X_2:bte, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:dbl, X_2:dbl, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:flt, X_2:flt, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:hge, X_2:hge, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:int, X_2:int, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:lng, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariance",   "pattern sql.covariance(X_1:sht, X_2:sht, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",   "SQLcovar_samp;",       
""      ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:bte, X_2:bte, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:dbl, X_2:dbl, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:flt, X_2:flt, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:hge, X_2:hge, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:int, X_2:int, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:lng, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
+[ "sql",       "covariancep",  "pattern sql.covariancep(X_1:sht, X_2:sht, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ",  "SQLcovar_pop;",        "" 
     ]
 [ "sql",       "createorderindex",     "unsafe pattern 
sql.createorderindex(X_1:str, X_2:str, X_3:str):void ", 
"sql_createorderindex;",        ""      ]
 [ "sql",       "cume_dist",    "pattern sql.cume_dist(X_1:any_1, X_2:bit, 
X_3:bit):dbl ",      "SQLcume_dist;",        ""      ]
 [ "sql",       "current_time", "pattern sql.current_time():daytime ",  
"SQLcurrent_daytime;",  ""      ]
@@ -12662,7 +12662,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "exportResult", "unsafe pattern sql.exportResult(X_1:streams, 
X_2:int):void ",  "mvc_export_result_wrap;",      ""      ]
 [ "sql",       "export_table", "unsafe pattern sql.export_table(X_1:str, 
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str], 
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int], X_13:any...):int 
",       "mvc_export_row_wrap;", ""      ]
 [ "sql",       "export_table", "unsafe pattern sql.export_table(X_1:str, 
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str], 
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int], 
X_13:bat[:any]...):int ", "mvc_export_table_wrap;",       ""      ]
-[ "sql",       "first_value",  "pattern sql.first_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ",       "SQLfirst_value;",      ""   
   ]
+[ "sql",       "first_value",  "pattern sql.first_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",       "SQLfirst_value;",      ""   
   ]
 [ "sql",       "flush_log",    "unsafe command sql.flush_log():void ", 
"SQLflush_log;",        ""      ]
 [ "sql",       "getVariable",  "pattern sql.getVariable(X_1:int, X_2:str, 
X_3:str):any_1 ",    "getVariable;", ""      ]
 [ "sql",       "getVersion",   "command sql.getVersion(X_1:int):lng ", 
"mvc_getVersion;",      ""      ]
@@ -12678,18 +12678,18 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:any, X_3:any_1, 
X_4:bit, X_5:bit):any_1 ",      "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:any, X_3:bit, 
X_4:bit):any_1 ", "SQLlag;",      ""      ]
 [ "sql",       "lag",  "pattern sql.lag(X_1:any_1, X_2:bit, X_3:bit):any_1 ",  
"SQLlag;",      ""      ]
-[ "sql",       "last_value",   "pattern sql.last_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ",        "SQLlast_value;",       ""  
    ]
+[ "sql",       "last_value",   "pattern sql.last_value(X_1:any_1, X_2:bit, 
X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",        "SQLlast_value;",       ""  
    ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:any_1, 
X_4:bit, X_5:bit):any_1 ",     "SQLlead;",     ""      ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:bit, 
X_4:bit):any_1 ",        "SQLlead;",     ""      ]
 [ "sql",       "lead", "pattern sql.lead(X_1:any_1, X_2:bit, X_3:bit):any_1 ", 
"SQLlead;",     ""      ]
 [ "sql",       "logfile",      "unsafe pattern sql.logfile(X_1:str):void ",    
"mvc_logfile;", ""      ]
-[ "sql",       "max",  "pattern sql.max(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):any_1 ",       "SQLmax;",      ""      ]
-[ "sql",       "min",  "pattern sql.min(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):any_1 ",       "SQLmin;",      ""      ]
+[ "sql",       "max",  "pattern sql.max(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):any_1 ",       "SQLmax;",      ""      ]
+[ "sql",       "min",  "pattern sql.min(X_1:any_1, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):any_1 ",       "SQLmin;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_1:dbl, X_2:int):dbl ",  
"dbl_trunc_wrap;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_1:flt, X_2:int):flt ",  
"flt_trunc_wrap;",      ""      ]
 [ "sql",       "mvc",  "pattern sql.mvc():int ",       "SQLmvc;",      ""      
]
 [ "sql",       "next_value",   "unsafe pattern sql.next_value(X_1:str, 
X_2:str):lng ", "mvc_next_value;",      ""      ]
-[ "sql",       "nth_value",    "pattern sql.nth_value(X_1:any_1, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):any_1 ",        "SQLnth_value;",   
     ""      ]
+[ "sql",       "nth_value",    "pattern sql.nth_value(X_1:any_1, X_2:lng, 
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):any_1 ",        "SQLnth_value;",   
     ""      ]
 [ "sql",       "ntile",        "pattern sql.ntile(X_1:any, X_2:any_1, X_3:bit, 
X_4:bit):any_1 ",       "SQLntile;",    ""      ]
 [ "sql",       "optimizer_updates",    "pattern sql.optimizer_updates():void 
",        "SQLoptimizersUpdate;", ""      ]
 [ "sql",       "optimizers",   "command sql.optimizers() (X_0:bat[:str], 
X_1:bat[:str], X_2:bat[:str]) ",      "getPipeCatalog;",      ""      ]
@@ -12698,18 +12698,18 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "prelude",      "pattern sql.prelude():void ",  "SQLprelude;",  
""      ]
 [ "sql",       "prepared_statements",  "pattern sql.prepared_statements() 
(X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:str], 
X_4:bat[:timestamp]) ", "SQLsession_prepared_statements;",      ""      ]
 [ "sql",       "prepared_statements_args",     "pattern 
sql.prepared_statements_args() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], 
X_3:bat[:int], X_4:bat[:bte], X_5:bat[:int], X_6:bat[:str], X_7:bat[:str], 
X_8:bat[:str]) ",      "SQLsession_prepared_statements_args;", ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:dbl, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):flt ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",  "SQLprod;",     ""      ]
-[ "sql",       "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:dbl, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):dbl ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):flt ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):hge ",  "SQLprod;",     ""      ]
+[ "sql",       "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:oid, X_6:oid):lng ",  "SQLprod;",     ""      ]
 [ "sql",       "project",      "command sql.project(X_1:bat[:oid], 
X_2:bat[:oid], X_3:bat[:oid]):bat[:oid] ",  "BATleftproject;",      ""      ]
 [ "sql",       "projectdelta", "command sql.projectdelta(X_1:bat[:oid], 
X_2:bat[:any_3], X_3:bat[:oid], X_4:bat[:any_3]):bat[:any_3] ",        
"DELTAproject2;",       ""      ]
 [ "sql",       "projectdelta", "command sql.projectdelta(X_1:bat[:oid], 
X_2:bat[:any_3], X_3:bat[:oid], X_4:bat[:any_3], X_5:bat[:any_3]):bat[:any_3] 
",       "DELTAproject;",        ""      ]
@@ -12755,41 +12755,41 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "shutdown",     "pattern sql.shutdown(X_1:sht):str ",   
"SQLshutdown_wrap;",    ""      ]
 [ "sql",       "shutdown",     "pattern sql.shutdown(X_1:sht, X_2:bit):str ",  
"SQLshutdown_wrap;",    ""      ]
 [ "sql",       "sql_variables",        "pattern sql.sql_variables() 
(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str]) ",    
"sql_variables;",       ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:bte, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:dbl, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:flt, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:hge, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:int, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:lng, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdev",        "pattern sql.stdev(X_1:sht, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;",      ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:bte, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:dbl, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:flt, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:hge, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:int, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:lng, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
-[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:sht, X_2:bit, X_3:bit, 
X_4:int, X_5:lng, X_6:lng):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:bte, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:dbl, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:flt, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:hge, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:int, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:lng, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdev",        "pattern sql.stdev(X_1:sht, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;",      ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:bte, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:dbl, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:flt, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:hge, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:int, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:lng, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
+[ "sql",       "stdevp",       "pattern sql.stdevp(X_1:sht, X_2:bit, X_3:bit, 
X_4:int, X_5:oid, X_6:oid):dbl ",        "SQLstddev_pop;",       ""      ]
 [ "sql",       "storage",      "pattern sql.storage() (X_0:bat[:str], 
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], 
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng], 
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit], 
X_16:bat[:lng]) ",        "sql_storage;", ""      ]
 [ "sql",       "storage",      "pattern sql.storage(X_17:str) (X_0:bat[:str], 
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], 
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng], 
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit], 
X_16:bat[:lng]) ",        "sql_storage;", ""      ]
 [ "sql",       "storage",      "pattern sql.storage(X_17:str, X_18:str) 
(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], 
X_5:bat[:str], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], 
X_10:bat[:lng], X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], 
X_15:bat[:bit], X_16:bat[:lng]) ",      "sql_storage;", ""      ]
 [ "sql",       "storage",      "pattern sql.storage(X_17:str, X_18:str, 
X_19:str) (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], 
X_4:bat[:str], X_5:bat[:str], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], 
X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], 
X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:lng]) ",    "sql_storage;", ""      ]
-[ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_1:str, 
X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):str ",      "SQLstrgroup_concat;", 
 ""      ]
-[ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_1:str, 
X_2:str, X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):str ",     
"SQLstrgroup_concat;",  ""      ]
+[ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_1:str, 
X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):str ",      "SQLstrgroup_concat;", 
 ""      ]
+[ "sql",       "str_group_concat",     "pattern sql.str_group_concat(X_1:str, 
X_2:str, X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):str ",     
"SQLstrgroup_concat;",  ""      ]
 [ "sql",       "strings",      "command sql.strings(X_1:str):str ",    
"STRstrings;",  ""      ]
 [ "sql",       "subdelta",     "command sql.subdelta(X_1:bat[:oid], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid]):bat[:oid] ",  "DELTAsub2;",   ""   
   ]
 [ "sql",       "subdelta",     "command sql.subdelta(X_1:bat[:oid], 
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid]):bat[:oid] ",   
"DELTAsub;",    ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:bte, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:dbl, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):dbl ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):flt ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:hge, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:int, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:lng, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):lng ",   "SQLsum;",      ""      ]
-[ "sql",       "sum",  "pattern sql.sum(X_1:sht, X_2:bit, X_3:bit, X_4:int, 
X_5:lng, X_6:lng):hge ",   "SQLsum;",      ""      ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to