Changeset: e83bc030388f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e83bc030388f Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 Branch: string_imprints Log Message:
Approve some tests. diffs (truncated from 358 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 @@ -9123,6 +9123,7 @@ [ "optimizer", "mergetable", "pattern optimizer.mergetable(X_0:str, X_1:str):str ", "OPTwrapper;", "Resolve the multi-table definitions" ] [ "optimizer", "minimal_fast", "function optimizer.minimal_fast():void;", "", "" ] [ "optimizer", "minimal_pipe", "function optimizer.minimal_pipe():void;", "", "" ] +[ "optimizer", "minimal_strimps_pipe", "function optimizer.minimal_strimps_pipe():void;", "", "" ] [ "optimizer", "minimalfast", "pattern optimizer.minimalfast():str ", "OPTwrapper;", "" ] [ "optimizer", "minimalfast", "pattern optimizer.minimalfast(X_0:str, X_1:str):str ", "OPTwrapper;", "Fast compound minimal optimizer pipe" ] [ "optimizer", "mitosis", "pattern optimizer.mitosis():str ", "OPTwrapper;", "" ] @@ -9156,6 +9157,9 @@ [ "optimizer", "reorder", "pattern optimizer.reorder():str ", "OPTwrapper;", "" ] [ "optimizer", "reorder", "pattern optimizer.reorder(X_0:str, X_1:str):str ", "OPTwrapper;", "Reorder by dataflow dependencies" ] [ "optimizer", "sequential_pipe", "function optimizer.sequential_pipe():void;", "", "" ] +[ "optimizer", "strimps", "pattern optimizer.strimps():str ", "OPTwrapper;", "" ] +[ "optimizer", "strimps", "pattern optimizer.strimps(X_0:str, X_1:str):str ", "OPTwrapper;", "Use strimps index if appropriate" ] +[ "optimizer", "strimps_pipe", "function optimizer.strimps_pipe():void;", "", "" ] [ "optimizer", "volcano", "pattern optimizer.volcano():str ", "OPTwrapper;", "" ] [ "optimizer", "volcano", "pattern optimizer.volcano(X_0:str, X_1:str):str ", "OPTwrapper;", "Simulate volcano style execution" ] [ "optimizer", "volcano_pipe", "function optimizer.volcano_pipe():void;", "", "" ] @@ -9305,6 +9309,7 @@ [ "sql", "covariancep", "pattern sql.covariancep(X_0:lng, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLcovar_pop;", "return the covariance population value of groups" ] [ "sql", "covariancep", "pattern sql.covariancep(X_0:sht, X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLcovar_pop;", "return the covariance population value of groups" ] [ "sql", "createorderindex", "unsafe pattern sql.createorderindex(X_0:str, X_1:str, X_2:str):void ", "sql_createorderindex;", "Instantiate the order index on a column" ] +[ "sql", "createstrimps", "unsafe pattern sql.createstrimps(X_0:str, X_1:str, X_2:str):void ", "sql_createstrimps;", "Instantiate the strimps index on a column" ] [ "sql", "cume_dist", "pattern sql.cume_dist(X_0:any_1, X_1:bit, X_2:bit):dbl ", "SQLcume_dist;", "return the accumulated distribution of the number of rows per group to the total number of partition rows" ] [ "sql", "current_time", "pattern sql.current_time():daytime ", "SQLcurrent_daytime;", "Get the clients current daytime" ] [ "sql", "current_timestamp", "pattern sql.current_timestamp():timestamp ", "SQLcurrent_timestamp;", "Get the clients current timestamp" ] @@ -9592,6 +9597,10 @@ [ "streams", "readStr", "unsafe command streams.readStr(X_0:streams):str ", "mnstr_read_stringwrap;", "read string data from the stream" ] [ "streams", "writeInt", "unsafe command streams.writeInt(X_0:streams, X_1:int):void ", "mnstr_writeIntwrap;", "write data on the stream" ] [ "streams", "writeStr", "unsafe command streams.writeStr(X_0:streams, X_1:str):void ", "mnstr_write_stringwrap;", "write data on the stream" ] +[ "strimps", "mkstrimp", "pattern strimps.mkstrimp(X_0:bat[:str], X_1:bat[:oid]):void ", "PATstrimpCreate;", "construct the strimp a BAT" ] +[ "strimps", "strimpfilter", "pattern strimps.strimpfilter(X_0:str, X_1:str):bit ", "PATstrimpFilter;", "" ] +[ "strimps", "strimpfilterjoin", "pattern strimps.strimpfilterjoin(X_0:str, X_1:any, X_2:any, X_3:any, X_4:any, X_5:any) (X_6:bat[:oid], X_7:bat[:str]) ", "PATstrimpFilter;", "" ] +[ "strimps", "strimpfilterselect", "pattern strimps.strimpfilterselect(X_0:bat[:str], X_1:bat[:oid], X_2:str, X_3:bit):bat[:oid] ", "PATstrimpFilterSelect;", "" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:int):void ", "SYSMONpause;", "Suspend a running query" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:lng):void ", "SYSMONpause;", "Suspend a running query" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:sht):void ", "SYSMONpause;", "Suspend a running query" ] 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 @@ -12423,6 +12423,7 @@ [ "optimizer", "mergetable", "pattern optimizer.mergetable(X_0:str, X_1:str):str ", "OPTwrapper;", "Resolve the multi-table definitions" ] [ "optimizer", "minimal_fast", "function optimizer.minimal_fast():void;", "", "" ] [ "optimizer", "minimal_pipe", "function optimizer.minimal_pipe():void;", "", "" ] +[ "optimizer", "minimal_strimps_pipe", "function optimizer.minimal_strimps_pipe():void;", "", "" ] [ "optimizer", "minimalfast", "pattern optimizer.minimalfast():str ", "OPTwrapper;", "" ] [ "optimizer", "minimalfast", "pattern optimizer.minimalfast(X_0:str, X_1:str):str ", "OPTwrapper;", "Fast compound minimal optimizer pipe" ] [ "optimizer", "mitosis", "pattern optimizer.mitosis():str ", "OPTwrapper;", "" ] @@ -12456,6 +12457,9 @@ [ "optimizer", "reorder", "pattern optimizer.reorder():str ", "OPTwrapper;", "" ] [ "optimizer", "reorder", "pattern optimizer.reorder(X_0:str, X_1:str):str ", "OPTwrapper;", "Reorder by dataflow dependencies" ] [ "optimizer", "sequential_pipe", "function optimizer.sequential_pipe():void;", "", "" ] +[ "optimizer", "strimps", "pattern optimizer.strimps():str ", "OPTwrapper;", "" ] +[ "optimizer", "strimps", "pattern optimizer.strimps(X_0:str, X_1:str):str ", "OPTwrapper;", "Use strimps index if appropriate" ] +[ "optimizer", "strimps_pipe", "function optimizer.strimps_pipe():void;", "", "" ] [ "optimizer", "volcano", "pattern optimizer.volcano():str ", "OPTwrapper;", "" ] [ "optimizer", "volcano", "pattern optimizer.volcano(X_0:str, X_1:str):str ", "OPTwrapper;", "Simulate volcano style execution" ] [ "optimizer", "volcano_pipe", "function optimizer.volcano_pipe():void;", "", "" ] @@ -12610,6 +12614,7 @@ [ "sql", "covariancep", "pattern sql.covariancep(X_0:lng, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLcovar_pop;", "return the covariance population value of groups" ] [ "sql", "covariancep", "pattern sql.covariancep(X_0:sht, X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLcovar_pop;", "return the covariance population value of groups" ] [ "sql", "createorderindex", "unsafe pattern sql.createorderindex(X_0:str, X_1:str, X_2:str):void ", "sql_createorderindex;", "Instantiate the order index on a column" ] +[ "sql", "createstrimps", "unsafe pattern sql.createstrimps(X_0:str, X_1:str, X_2:str):void ", "sql_createstrimps;", "Instantiate the strimps index on a column" ] [ "sql", "cume_dist", "pattern sql.cume_dist(X_0:any_1, X_1:bit, X_2:bit):dbl ", "SQLcume_dist;", "return the accumulated distribution of the number of rows per group to the total number of partition rows" ] [ "sql", "current_time", "pattern sql.current_time():daytime ", "SQLcurrent_daytime;", "Get the clients current daytime" ] [ "sql", "current_timestamp", "pattern sql.current_timestamp():timestamp ", "SQLcurrent_timestamp;", "Get the clients current timestamp" ] @@ -12913,6 +12918,10 @@ [ "streams", "readStr", "unsafe command streams.readStr(X_0:streams):str ", "mnstr_read_stringwrap;", "read string data from the stream" ] [ "streams", "writeInt", "unsafe command streams.writeInt(X_0:streams, X_1:int):void ", "mnstr_writeIntwrap;", "write data on the stream" ] [ "streams", "writeStr", "unsafe command streams.writeStr(X_0:streams, X_1:str):void ", "mnstr_write_stringwrap;", "write data on the stream" ] +[ "strimps", "mkstrimp", "pattern strimps.mkstrimp(X_0:bat[:str], X_1:bat[:oid]):void ", "PATstrimpCreate;", "construct the strimp a BAT" ] +[ "strimps", "strimpfilter", "pattern strimps.strimpfilter(X_0:str, X_1:str):bit ", "PATstrimpFilter;", "" ] +[ "strimps", "strimpfilterjoin", "pattern strimps.strimpfilterjoin(X_0:str, X_1:any, X_2:any, X_3:any, X_4:any, X_5:any) (X_6:bat[:oid], X_7:bat[:str]) ", "PATstrimpFilter;", "" ] +[ "strimps", "strimpfilterselect", "pattern strimps.strimpfilterselect(X_0:bat[:str], X_1:bat[:oid], X_2:str, X_3:bit):bat[:oid] ", "PATstrimpFilterSelect;", "" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:int):void ", "SYSMONpause;", "Suspend a running query" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:lng):void ", "SYSMONpause;", "Suspend a running query" ] [ "sysmon", "pause", "pattern sysmon.pause(X_0:sht):void ", "SYSMONpause;", "Suspend a running query" ] 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 @@ -392,6 +392,8 @@ BUN ORDERfndlast(BAT *b, Heap *oidxh, co BUN SORTfnd(BAT *b, const void *v); BUN SORTfndfirst(BAT *b, const void *v); BUN SORTfndlast(BAT *b, const void *v); +gdk_return STRMPcreate(BAT *b, BAT *s); +BAT *STRMPfilter(BAT *b, BAT *s, char *q); MT_Id THRcreate(void (*f)(void *), void *arg, enum MT_thr_detach d, const char *name); void *THRdata[THREADDATA]; void THRdel(Thread t); @@ -1145,6 +1147,7 @@ const char *minusRef; const char *mirrorRef; const char *mitosisRef; const char *mkeyRef; +const char *mkstrimpsRef; const char *mmathRef; const char *modRef; char monet_characteristics[4096]; @@ -1366,6 +1369,8 @@ void strAfterCall(ValPtr v, ValPtr bak); void strBeforeCall(ValPtr v, ValPtr bak); const char *strRef; const char *streamsRef; +const char *strimpFilterSelectRef; +const char *strimpsRef; const char *subavgRef; const char *subcountRef; const char *subdeltaRef; diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -11,6 +11,7 @@ \dn json \dn logging \dn profiler +\dn strimps \dn sys \dn tmp \dn wlc @@ -156,6 +157,7 @@ \dSf sys."covar_pop" \dSf sys."covar_samp" \dSf sys."createorderindex" +\dSf sys."createstrimps" \dSf sys."current_sessionid" \dSf sys."date_to_str" \dSf sys."date_trunc" @@ -382,6 +384,7 @@ SYSTEM SCHEMA json SYSTEM SCHEMA logging SYSTEM SCHEMA profiler +SYSTEM SCHEMA strimps SYSTEM SCHEMA sys SYSTEM SCHEMA tmp SYSTEM SCHEMA wlc @@ -567,6 +570,7 @@ SYSTEM WINDOW sys.covar_pop SYSTEM AGGREGATE sys.covar_samp SYSTEM WINDOW sys.covar_samp SYSTEM PROCEDURE sys.createorderindex +SYSTEM PROCEDURE sys.createstrimps SYSTEM WINDOW sys.cume_dist SYSTEM FUNCTION sys.curdate SYSTEM FUNCTION sys.current_date @@ -951,6 +955,7 @@ SYSTEM AGGREGATE sys.zero_or_one CREATE SCHEMA "json" AUTHORIZATION "monetdb"; CREATE SCHEMA "logging" AUTHORIZATION "monetdb"; CREATE SCHEMA "profiler" AUTHORIZATION "monetdb"; +CREATE SCHEMA "strimps" AUTHORIZATION "monetdb"; CREATE SCHEMA "sys"; CREATE SCHEMA "tmp"; CREATE SCHEMA "wlc" AUTHORIZATION "monetdb"; @@ -1132,6 +1137,7 @@ create window covar_samp(e1 real, e2 rea create window covar_samp(e1 smallint, e2 smallint) returns double external name "sql"."covariance"; create window covar_samp(e1 tinyint, e2 tinyint) returns double external name "sql"."covariance"; create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex; +create procedure sys.createstrimps(sch string, tab string, col string) external name sql.createstrimps; create function sys.current_sessionid() returns int external name clients.current_sessionid; create function date_to_str(d date, format string) returns string external name mtime."date_to_str"; create function sys.date_trunc(txt string, t timestamp with time zone) returns timestamp with time zone external name sql.date_trunc; @@ -1925,6 +1931,7 @@ select 'null in value_partitions.value', [ "sys.schemas", "json", "monetdb", "monetdb", true ] [ "sys.schemas", "logging", "monetdb", "monetdb", true ] [ "sys.schemas", "profiler", "monetdb", "monetdb", true ] +[ "sys.schemas", "strimps", "monetdb", "monetdb", true ] [ "sys.schemas", "sys", "sysadmin", "monetdb", true ] [ "sys.schemas", "tmp", "sysadmin", "monetdb", true ] [ "sys.schemas", "wlc", "monetdb", "monetdb", true ] @@ -2860,6 +2867,7 @@ select 'null in value_partitions.value', [ "sys.functions", "profiler", "setlimit", "SYSTEM", "create procedure profiler.setlimit(lim integer) external name profiler.setlimit;", "profiler", "MAL", "Procedure", true, false, false, true, "lim", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "profiler", "start", "SYSTEM", "create procedure profiler.start() external name profiler.\"start\";", "profiler", "MAL", "Procedure", true, false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "profiler", "stop", "SYSTEM", "create procedure profiler.stop() external name profiler.stop;", "profiler", "MAL", "Procedure", true, false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "strimps", "filter", "SYSTEM", "create filter function strimps.filter(strs string, q string) external name strimps.strimpfilter;", "strimps", "MAL", "Filter function", false, false, false, true, "strs", "clob", 0, 0, "in", "q", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<", "SYSTEM", "<", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<=", "SYSTEM", "<=", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<>", "SYSTEM", "!=", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -3046,6 +3054,7 @@ select 'null in value_partitions.value', [ "sys.functions", "sys", "covar_samp", "SYSTEM", "create window covar_samp(e1 smallint, e2 smallint) returns double external name \"sql\".\"covariance\";", "sql", "MAL", "Analytic function", false, false, false, true, "result", "double", 53, 0, "out", "e1", "smallint", 16, 0, "in", "e2", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "covar_samp", "SYSTEM", "create window covar_samp(e1 tinyint, e2 tinyint) returns double external name \"sql\".\"covariance\";", "sql", "MAL", "Analytic function", false, false, false, true, "result", "double", 53, 0, "out", "e1", "tinyint", 8, 0, "in", "e2", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "createorderindex", "SYSTEM", "create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex;", "sql", "MAL", "Procedure", true, false, false, true, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "createstrimps", "SYSTEM", "create procedure sys.createstrimps(sch string, tab string, col string) external name sql.createstrimps;", "sql", "MAL", "Procedure", true, false, false, true, "sch", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "cume_dist", "SYSTEM", "cume_dist", "sql", "Internal C", "Analytic function", false, false, false, true, "res_0", "double", 53, 0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "curdate", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "current_date", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5790,6 +5799,7 @@ select 'null in value_partitions.value', [ "grant on function", "json", "tojsonarray", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "json", "valuearray", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "logging", "compinfo", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "strimps", "filter", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "abbrev", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "alpha", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "broadcast", "public", "EXECUTE", "monetdb", 0 ] diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit b/sql/test/emptydb/Tests/check.stable.out.32bit --- a/sql/test/emptydb/Tests/check.stable.out.32bit +++ b/sql/test/emptydb/Tests/check.stable.out.32bit @@ -11,6 +11,7 @@ \dn json \dn logging \dn profiler +\dn strimps \dn sys \dn tmp \dn wlc @@ -156,6 +157,7 @@ \dSf sys."covar_pop" \dSf sys."covar_samp" \dSf sys."createorderindex" +\dSf sys."createstrimps" \dSf sys."current_sessionid" \dSf sys."date_to_str" \dSf sys."date_trunc" @@ -382,6 +384,7 @@ SYSTEM SCHEMA json SYSTEM SCHEMA logging SYSTEM SCHEMA profiler +SYSTEM SCHEMA strimps SYSTEM SCHEMA sys SYSTEM SCHEMA tmp SYSTEM SCHEMA wlc @@ -567,6 +570,7 @@ SYSTEM WINDOW sys.covar_pop SYSTEM AGGREGATE sys.covar_samp SYSTEM WINDOW sys.covar_samp SYSTEM PROCEDURE sys.createorderindex +SYSTEM PROCEDURE sys.createstrimps SYSTEM WINDOW sys.cume_dist SYSTEM FUNCTION sys.curdate SYSTEM FUNCTION sys.current_date @@ -951,6 +955,7 @@ SYSTEM AGGREGATE sys.zero_or_one CREATE SCHEMA "json" AUTHORIZATION "monetdb"; CREATE SCHEMA "logging" AUTHORIZATION "monetdb"; CREATE SCHEMA "profiler" AUTHORIZATION "monetdb"; +CREATE SCHEMA "strimps" AUTHORIZATION "monetdb"; CREATE SCHEMA "sys"; CREATE SCHEMA "tmp"; CREATE SCHEMA "wlc" AUTHORIZATION "monetdb"; @@ -1132,6 +1137,7 @@ create window covar_samp(e1 real, e2 rea create window covar_samp(e1 smallint, e2 smallint) returns double external name "sql"."covariance"; create window covar_samp(e1 tinyint, e2 tinyint) returns double external name "sql"."covariance"; create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex; +create procedure sys.createstrimps(sch string, tab string, col string) external name sql.createstrimps; create function sys.current_sessionid() returns int external name clients.current_sessionid; create function date_to_str(d date, format string) returns string external name mtime."date_to_str"; create function sys.date_trunc(txt string, t timestamp with time zone) returns timestamp with time zone external name sql.date_trunc; @@ -1925,6 +1931,7 @@ select 'null in value_partitions.value', [ "sys.schemas", "json", "monetdb", "monetdb", true ] [ "sys.schemas", "logging", "monetdb", "monetdb", true ] [ "sys.schemas", "profiler", "monetdb", "monetdb", true ] +[ "sys.schemas", "strimps", "monetdb", "monetdb", true ] [ "sys.schemas", "sys", "sysadmin", "monetdb", true ] [ "sys.schemas", "tmp", "sysadmin", "monetdb", true ] [ "sys.schemas", "wlc", "monetdb", "monetdb", true ] @@ -2859,6 +2866,7 @@ select 'null in value_partitions.value', [ "sys.functions", "profiler", "setlimit", "SYSTEM", "create procedure profiler.setlimit(lim integer) external name profiler.setlimit;", "profiler", "MAL", "Procedure", true, false, false, true, "lim", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "profiler", "start", "SYSTEM", "create procedure profiler.start() external name profiler.\"start\";", "profiler", "MAL", "Procedure", true, false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "profiler", "stop", "SYSTEM", "create procedure profiler.stop() external name profiler.stop;", "profiler", "MAL", "Procedure", true, false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "strimps", "filter", "SYSTEM", "create filter function strimps.filter(strs string, q string) external name strimps.strimpfilter;", "strimps", "MAL", "Filter function", false, false, false, true, "strs", "clob", 0, 0, "in", "q", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<", "SYSTEM", "<", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<=", "SYSTEM", "<=", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "<>", "SYSTEM", "!=", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -3045,6 +3053,7 @@ select 'null in value_partitions.value', [ "sys.functions", "sys", "covar_samp", "SYSTEM", "create window covar_samp(e1 smallint, e2 smallint) returns double external name \"sql\".\"covariance\";", "sql", "MAL", "Analytic function", false, false, false, true, "result", "double", 53, 0, "out", "e1", "smallint", 16, 0, "in", "e2", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "covar_samp", "SYSTEM", "create window covar_samp(e1 tinyint, e2 tinyint) returns double external name \"sql\".\"covariance\";", "sql", "MAL", "Analytic function", false, false, false, true, "result", "double", 53, 0, "out", "e1", "tinyint", 8, 0, "in", "e2", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "createorderindex", "SYSTEM", "create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex;", "sql", "MAL", "Procedure", true, false, false, true, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "createstrimps", "SYSTEM", "create procedure sys.createstrimps(sch string, tab string, col string) external name sql.createstrimps;", "sql", "MAL", "Procedure", true, false, false, true, "sch", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "cume_dist", "SYSTEM", "cume_dist", "sql", "Internal C", "Analytic function", false, false, false, true, "res_0", "double", 53, 0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "curdate", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "current_date", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5774,6 +5783,7 @@ select 'null in value_partitions.value', [ "grant on function", "json", "tojsonarray", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "json", "valuearray", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "logging", "compinfo", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "strimps", "filter", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "abbrev", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "alpha", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "broadcast", "public", "EXECUTE", "monetdb", 0 ] diff --git a/sql/test/emptydb/Tests/check.stable.out.int128 b/sql/test/emptydb/Tests/check.stable.out.int128 --- a/sql/test/emptydb/Tests/check.stable.out.int128 +++ b/sql/test/emptydb/Tests/check.stable.out.int128 @@ -11,6 +11,7 @@ \dn json \dn logging \dn profiler +\dn strimps \dn sys \dn tmp \dn wlc @@ -156,6 +157,7 @@ \dSf sys."covar_pop" \dSf sys."covar_samp" \dSf sys."createorderindex" +\dSf sys."createstrimps" \dSf sys."current_sessionid" \dSf sys."date_to_str" \dSf sys."date_trunc" @@ -382,6 +384,7 @@ SYSTEM SCHEMA json SYSTEM SCHEMA logging SYSTEM SCHEMA profiler +SYSTEM SCHEMA strimps SYSTEM SCHEMA sys _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
