Changeset: 1969440f28e1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1969440f28e1 Modified Files: sql/backends/monet5/Tests/pyloader01.stable.out sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: system-functions Log Message:
Approvals after recent changes. diffs (truncated from 51056 to 300 lines): diff --git a/sql/backends/monet5/Tests/pyloader01.stable.out b/sql/backends/monet5/Tests/pyloader01.stable.out --- a/sql/backends/monet5/Tests/pyloader01.stable.out +++ b/sql/backends/monet5/Tests/pyloader01.stable.out @@ -66,10 +66,10 @@ Ready. #DROP LOADER myfunc2; #DROP LOADER myfunc3; #SELECT * FROM functions WHERE name='myfunc'; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length #ROLLBACK; # 13:26:39 > diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out --- a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out +++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out @@ -66,10 +66,10 @@ Ready. #DROP LOADER myfunc2; #DROP LOADER myfunc3; #SELECT * FROM functions WHERE name='myfunc'; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length #ROLLBACK; # 13:26:39 > diff --git a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out --- a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out +++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out @@ -43,7 +43,7 @@ Ready. # null AS SCOPE_CATALOG, # null AS SCOPE_SCHEMA, # null AS SCOPE_TABLE -% .L52, .L54, .L56, .L60, .L62, .L64, .L66, .L70, .L72, .L74, .L76, .L100, .L102, .L104, .L106, .L110, .L112, .L114, .L116 # table_name +% .L53, .L55, .L57, .L61, .L63, .L65, .L67, .L71, .L73, .L75, .L77, .L101, .L103, .L105, .L107, .L111, .L113, .L115, .L117 # table_name % table_cat, table_schem, table_name, column_name, type_name, column_size, decimal_digits, buffer_length, num_prec_radix, nullable, remarks, column_def, sql_data_type, sql_datetime_sub, char_octet_length, ordinal_position, scope_catalog, scope_schema, scope_table # name % char, varchar, varchar, varchar, varchar, int, int, tinyint, tinyint, char, char, varchar, tinyint, tinyint, tinyint, bigint, char, char, char # type % 0, 3, 9, 11, 7, 4, 1, 1, 2, 0, 0, 0, 1, 1, 1, 2, 0, 0, 0 # length @@ -75,6 +75,7 @@ Ready. [ NULL, "sys", "functions", "varres", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 8, NULL, NULL, NULL ] [ NULL, "sys", "functions", "vararg", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 9, NULL, NULL, NULL ] [ NULL, "sys", "functions", "schema_id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 10, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "system", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 11, NULL, NULL, NULL ] [ NULL, "sys", "keys", "id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 1, NULL, NULL, NULL ] [ NULL, "sys", "keys", "table_id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 2, NULL, NULL, NULL ] [ NULL, "sys", "keys", "type", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 3, NULL, NULL, NULL ] diff --git a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out --- a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out +++ b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out @@ -41,7 +41,7 @@ Ready. [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 2, "two" ] [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 3, "three" ] -[ 2027, "args", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] +[ 2028, "args", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] #drop table x cascade; # 19:39:26 > diff --git a/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out --- a/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out +++ b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out @@ -37,7 +37,7 @@ Ready. [ 1, "one" ] [ 2, "two" ] #DELETE FROM sys.statistics; -[ 184 ] +[ 185 ] #SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics; % sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name % type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out b/sql/test/Dependencies/Tests/Dependencies.stable.out --- a/sql/test/Dependencies/Tests/Dependencies.stable.out +++ b/sql/test/Dependencies/Tests/Dependencies.stable.out @@ -369,8 +369,13 @@ Dependencies between database objects [ "statement", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "statement", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "statement", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "system", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "system", "dependencies_owners_on_schemas", "DEP_FUNC" ] [ "system", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "system", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_views_on_functions", "DEP_FUNC" ] [ "table", "storagemodel", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] @@ -1155,8 +1160,13 @@ Cleanup [ "statement", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "statement", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "statement", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "system", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "system", "dependencies_owners_on_schemas", "DEP_FUNC" ] [ "system", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "system", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_views_on_functions", "DEP_FUNC" ] [ "table", "storagemodel", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 --- a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 +++ b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 @@ -369,8 +369,13 @@ Dependencies between database objects [ "statement", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "statement", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "statement", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "system", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "system", "dependencies_owners_on_schemas", "DEP_FUNC" ] [ "system", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "system", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_views_on_functions", "DEP_FUNC" ] [ "table", "storagemodel", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] @@ -1155,8 +1160,13 @@ Cleanup [ "statement", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "statement", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "statement", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "system", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "system", "dependencies_owners_on_schemas", "DEP_FUNC" ] [ "system", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "system", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "system", "dependencies_views_on_functions", "DEP_FUNC" ] [ "table", "storagemodel", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -58,83 +58,83 @@ Ready. % sys.L6, sys.L10, sys.L12, sys.L14, sys.L16 # table_name % schema, function, argno, argtype, definition # name % varchar, varchar, int, varchar, varchar # type -% 8, 35, 2, 14, 611 # length -[ "bam", "bam_drop_file", 0, "bigint", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint)\nexternal name bam.bam_drop_file;" ] +% 8, 35, 2, 14, 618 # length +[ "bam", "bam_drop_file", 0, "bigint", "create system procedure bam.bam_drop_file(file_id bigint, dbschema smallint)\nexternal name bam.bam_drop_file;" ] [ "bam", "bam_drop_file", 1, "smallint", "" ] -[ "bam", "bam_export", 0, "clob", "create procedure bam.bam_export(output_path string)\nexternal name bam.bam_export;" ] -[ "bam", "bam_flag", 0, "boolean", "create function bam.bam_flag(flag smallint, name string)\nreturns boolean external name bam.bam_flag;" ] +[ "bam", "bam_export", 0, "clob", "create system procedure bam.bam_export(output_path string)\nexternal name bam.bam_export;" ] +[ "bam", "bam_flag", 0, "boolean", "create system function bam.bam_flag(flag smallint, name string)\nreturns boolean external name bam.bam_flag;" ] [ "bam", "bam_flag", 1, "smallint", "" ] [ "bam", "bam_flag", 2, "clob", "" ] -[ "bam", "bam_loader_file", 0, "clob", "create procedure bam.bam_loader_file(bam_file string, dbschema smallint)\nexternal name bam.bam_loader_file;" ] +[ "bam", "bam_loader_file", 0, "clob", "create system procedure bam.bam_loader_file(bam_file string, dbschema smallint)\nexternal name bam.bam_loader_file;" ] [ "bam", "bam_loader_file", 1, "smallint", "" ] -[ "bam", "bam_loader_files", 0, "clob", "create procedure bam.bam_loader_files(bam_files string, dbschema smallint)\nexternal name bam.bam_loader_files;" ] +[ "bam", "bam_loader_files", 0, "clob", "create system procedure bam.bam_loader_files(bam_files string, dbschema smallint)\nexternal name bam.bam_loader_files;" ] [ "bam", "bam_loader_files", 1, "smallint", "" ] -[ "bam", "bam_loader_repos", 0, "clob", "create procedure bam.bam_loader_repos(bam_repos string, dbschema smallint)\nexternal name bam.bam_loader_repos;" ] +[ "bam", "bam_loader_repos", 0, "clob", "create system procedure bam.bam_loader_repos(bam_repos string, dbschema smallint)\nexternal name bam.bam_loader_repos;" ] [ "bam", "bam_loader_repos", 1, "smallint", "" ] -[ "bam", "reverse_qual", 0, "clob", "create function bam.reverse_qual(qual string)\nreturns string external name bam.reverse_qual;" ] +[ "bam", "reverse_qual", 0, "clob", "create system function bam.reverse_qual(qual string)\nreturns string external name bam.reverse_qual;" ] [ "bam", "reverse_qual", 1, "clob", "" ] -[ "bam", "reverse_seq", 0, "clob", "create function bam.reverse_seq(seq string)\nreturns string external name bam.reverse_seq;" ] +[ "bam", "reverse_seq", 0, "clob", "create system function bam.reverse_seq(seq string)\nreturns string external name bam.reverse_seq;" ] [ "bam", "reverse_seq", 1, "clob", "" ] -[ "bam", "sam_export", 0, "clob", "create procedure bam.sam_export(output_path string)\nexternal name bam.sam_export;" ] -[ "bam", "seq_char", 0, "char", "create function bam.seq_char(ref_pos int, alg_seq string, alg_pos int, alg_cigar string)\nreturns char(1) external name bam.seq_char;" ] +[ "bam", "sam_export", 0, "clob", "create system procedure bam.sam_export(output_path string)\nexternal name bam.sam_export;" ] +[ "bam", "seq_char", 0, "char", "create system function bam.seq_char(ref_pos int, alg_seq string, alg_pos int, alg_cigar string)\nreturns char(1) external name bam.seq_char;" ] [ "bam", "seq_char", 1, "int", "" ] [ "bam", "seq_char", 2, "clob", "" ] [ "bam", "seq_char", 3, "int", "" ] [ "bam", "seq_char", 4, "clob", "" ] -[ "bam", "seq_length", 0, "int", "create function bam.seq_length(cigar string)\nreturns int external name bam.seq_length;" ] +[ "bam", "seq_length", 0, "int", "create system function bam.seq_length(cigar string)\nreturns int external name bam.seq_length;" ] [ "bam", "seq_length", 1, "clob", "" ] -[ "json", "filter", 0, "json", "create function json.filter(js json, pathexpr string)\nreturns json external name json.filter;" ] +[ "json", "filter", 0, "json", "create system function json.filter(js json, pathexpr string)\nreturns json external name json.filter;" ] [ "json", "filter", 1, "json", "" ] [ "json", "filter", 2, "clob", "" ] -[ "json", "filter", 0, "json", "create function json.filter(js json, name tinyint)\nreturns json external name json.filter;" ] +[ "json", "filter", 0, "json", "create system function json.filter(js json, name tinyint)\nreturns json external name json.filter;" ] [ "json", "filter", 1, "json", "" ] [ "json", "filter", 2, "tinyint", "" ] -[ "json", "filter", 0, "json", "create function json.filter(js json, name integer)\nreturns json external name json.filter;" ] +[ "json", "filter", 0, "json", "create system function json.filter(js json, name integer)\nreturns json external name json.filter;" ] [ "json", "filter", 1, "json", "" ] [ "json", "filter", 2, "int", "" ] -[ "json", "filter", 0, "json", "create function json.filter(js json, name bigint)\nreturns json external name json.filter;" ] +[ "json", "filter", 0, "json", "create system function json.filter(js json, name bigint)\nreturns json external name json.filter;" ] [ "json", "filter", 1, "json", "" ] [ "json", "filter", 2, "bigint", "" ] -[ "json", "integer", 0, "bigint", "create function json.\"integer\"(js json)\nreturns bigint external name json.\"integer\";" ] +[ "json", "integer", 0, "bigint", "create system function json.\"integer\"(js json)\nreturns bigint external name json.\"integer\";" ] [ "json", "integer", 1, "json", "" ] -[ "json", "isarray", 0, "boolean", "create function json.isarray(js string)\nreturns bool external name json.isarray;" ] +[ "json", "isarray", 0, "boolean", "create system function json.isarray(js string)\nreturns bool external name json.isarray;" ] [ "json", "isarray", 1, "clob", "" ] -[ "json", "isarray", 0, "boolean", "create function json.isarray(js json)\nreturns bool external name json.isarray;" ] +[ "json", "isarray", 0, "boolean", "create system function json.isarray(js json)\nreturns bool external name json.isarray;" ] [ "json", "isarray", 1, "json", "" ] -[ "json", "isobject", 0, "boolean", "create function json.isobject(js string)\nreturns bool external name json.isobject;" ] +[ "json", "isobject", 0, "boolean", "create system function json.isobject(js string)\nreturns bool external name json.isobject;" ] [ "json", "isobject", 1, "clob", "" ] -[ "json", "isobject", 0, "boolean", "create function json.isobject(js json)\nreturns bool external name json.isobject;" ] +[ "json", "isobject", 0, "boolean", "create system function json.isobject(js json)\nreturns bool external name json.isobject;" ] [ "json", "isobject", 1, "json", "" ] -[ "json", "isvalid", 0, "boolean", "create function json.isvalid(js string)\nreturns bool external name json.isvalid;" ] +[ "json", "isvalid", 0, "boolean", "create system function json.isvalid(js string)\nreturns bool external name json.isvalid;" ] [ "json", "isvalid", 1, "clob", "" ] -[ "json", "isvalid", 0, "boolean", "create function json.isvalid(js json)\nreturns bool external name json.isvalid;" ] +[ "json", "isvalid", 0, "boolean", "create system function json.isvalid(js json)\nreturns bool external name json.isvalid;" ] [ "json", "isvalid", 1, "json", "" ] -[ "json", "keyarray", 0, "json", "create function json.keyarray(js json)\nreturns json external name json.keyarray;" ] +[ "json", "keyarray", 0, "json", "create system function json.keyarray(js json)\nreturns json external name json.keyarray;" ] [ "json", "keyarray", 1, "json", "" ] -[ "json", "length", 0, "int", "create function json.length(js json)\nreturns integer external name json.length;" ] +[ "json", "length", 0, "int", "create system function json.length(js json)\nreturns integer external name json.length;" ] [ "json", "length", 1, "json", "" ] -[ "json", "number", 0, "double", "create function json.number(js json)\nreturns float external name json.number;" ] +[ "json", "number", 0, "double", "create system function json.number(js json)\nreturns float external name json.number;" ] [ "json", "number", 1, "json", "" ] -[ "json", "output", 0, "clob", "create aggregate json.output(js json)\nreturns string external name json.output;" ] +[ "json", "output", 0, "clob", "create system aggregate json.output(js json)\nreturns string external name json.output;" ] [ "json", "output", 1, "json", "" ] -[ "json", "text", 0, "clob", "create function json.text(js json, e string)\nreturns string external name json.text;" ] +[ "json", "text", 0, "clob", "create system function json.text(js json, e string)\nreturns string external name json.text;" ] [ "json", "text", 1, "json", "" ] [ "json", "text", 2, "clob", "" ] -[ "json", "text", 0, "clob", "create function json.text(js json)\nreturns string external name json.text;" ] +[ "json", "text", 0, "clob", "create system function json.text(js json)\nreturns string external name json.text;" ] [ "json", "text", 1, "json", "" ] -[ "json", "text", 0, "clob", "create function json.text(js string)\nreturns string external name json.text;" ] +[ "json", "text", 0, "clob", "create system function json.text(js string)\nreturns string external name json.text;" ] [ "json", "text", 1, "clob", "" ] -[ "json", "text", 0, "clob", "create function json.text(js int)\nreturns string external name json.text;" ] +[ "json", "text", 0, "clob", "create system function json.text(js int)\nreturns string external name json.text;" ] [ "json", "text", 1, "int", "" ] -[ "json", "tojsonarray", 0, "clob", "create aggregate json.tojsonarray( x string ) returns string external name aggr.jsonaggr;" ] +[ "json", "tojsonarray", 0, "clob", "create system aggregate json.tojsonarray( x string ) returns string external name aggr.jsonaggr;" ] [ "json", "tojsonarray", 1, "clob", "" ] -[ "json", "tojsonarray", 0, "clob", "create aggregate json.tojsonarray( x double ) returns string external name aggr.jsonaggr;" ] +[ "json", "tojsonarray", 0, "clob", "create system aggregate json.tojsonarray( x double ) returns string external name aggr.jsonaggr;" ] [ "json", "tojsonarray", 1, "double", "" ] -[ "json", "valuearray", 0, "json", "create function json.valuearray(js json)\nreturns json external name json.valuearray;" ] +[ "json", "valuearray", 0, "json", "create system function json.valuearray(js json)\nreturns json external name json.valuearray;" ] [ "json", "valuearray", 1, "json", "" ] -[ "profiler", "getlimit", 0, "int", "create function profiler.getlimit() returns integer external name profiler.getlimit;" ] -[ "profiler", "setheartbeat", 0, "int", "create procedure profiler.setheartbeat(beat int) external name profiler.setheartbeat;" ] -[ "profiler", "setlimit", 0, "int", "create procedure profiler.setlimit(lim integer) external name profiler.setlimit;" ] +[ "profiler", "getlimit", 0, "int", "create system function profiler.getlimit() returns integer external name profiler.getlimit;" ] +[ "profiler", "setheartbeat", 0, "int", "create system procedure profiler.setheartbeat(beat int) external name profiler.setheartbeat;" ] +[ "profiler", "setlimit", 0, "int", "create system procedure profiler.setlimit(lim integer) external name profiler.setlimit;" ] [ "sys", "<", 0, "boolean", "<" ] [ "sys", "<", 1, "any", "" ] [ "sys", "<", 2, "any", "" ] @@ -153,7 +153,7 @@ Ready. [ "sys", ">=", 0, "boolean", ">=" ] [ "sys", ">=", 1, "any", "" ] [ "sys", ">=", 2, "any", "" ] -[ "sys", "abbrev", 0, "clob", "create function \"abbrev\" (p inet) returns clob\n external name inet.\"abbrev\";" ] +[ "sys", "abbrev", 0, "clob", "create system function \"abbrev\" (p inet) returns clob\n external name inet.\"abbrev\";" ] [ "sys", "abbrev", 1, "inet", "" ] [ "sys", "abs", 0, "oid", "abs" ] [ "sys", "abs", 1, "oid", "" ] @@ -187,19 +187,19 @@ Ready. [ "sys", "acos", 1, "double", "" ] [ "sys", "all", 0, "any", "all" ] [ "sys", "all", 1, "any", "" ] -[ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] +[ "sys", "alpha", 0, "double", "create system function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] [ "sys", "alpha", 1, "double", "" ] [ "sys", "alpha", 2, "double", "" ] -[ "sys", "analyze", 0, "int", "create procedure sys.analyze(minmax int, \"sample\" bigint)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "int", "create system procedure sys.analyze(minmax int, \"sample\" bigint)\nexternal name sql.analyze;" ] [ "sys", "analyze", 1, "bigint", "" ] -[ "sys", "analyze", 0, "int", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "int", "create system procedure sys.analyze(minmax int, \"sample\" bigint, sch string)\nexternal name sql.analyze;" ] [ "sys", "analyze", 1, "bigint", "" ] [ "sys", "analyze", 2, "clob", "" ] -[ "sys", "analyze", 0, "int", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string, tbl string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "int", "create system procedure sys.analyze(minmax int, \"sample\" bigint, sch string, tbl string)\nexternal name sql.analyze;" ] [ "sys", "analyze", 1, "bigint", "" ] [ "sys", "analyze", 2, "clob", "" ] [ "sys", "analyze", 3, "clob", "" ] -[ "sys", "analyze", 0, "int", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string, tbl string, col string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "int", "create system procedure sys.analyze(minmax int, \"sample\" bigint, sch string, tbl string, col string)\nexternal name sql.analyze;" ] [ "sys", "analyze", 1, "bigint", "" ] [ "sys", "analyze", 2, "clob", "" ] [ "sys", "analyze", 3, "clob", "" ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
