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