Changeset: 35698c84743b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=35698c84743b
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
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-hge/Tests/upgrade.stable.out.int128
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.32bit
sql/test/emptydb/Tests/check.stable.out.int128
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: remote_auth
Log Message:
Approve upgrade tests
diffs (truncated from 436 to 300 lines):
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -45,9 +45,17 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
-# 15:50:22 >
-# 15:50:22 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-17773" "--port=32731"
-# 15:50:22 >
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
+
+# 15:17:55 >
+# 15:17:55 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-6495" "--port=30245"
+# 15:17:55 >
#select 1;
% .L2 # table_name
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -45,6 +45,14 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
+
# 15:55:37 >
# 15:55:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-12365" "--port=35877"
# 15:55:37 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -45,6 +45,14 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
+
# 16:02:52 >
# 16:02:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5391" "--port=32916"
# 16:02:52 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5373,6 +5373,13 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
# 16:53:35 >
# 16:53:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-30908" "--port=39660"
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
@@ -5373,6 +5373,13 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
# 15:43:25 >
# 15:43:25 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5725" "--port=37647"
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -45,9 +45,17 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
-# 15:50:23 >
-# 15:50:23 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-17773" "--port=32731"
-# 15:50:23 >
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
+
+# 15:17:04 >
+# 15:17:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-4292" "--port=34610"
+# 15:17:04 >
#select 1;
% .L2 # table_name
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -45,6 +45,14 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
+
# 16:02:52 >
# 16:02:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5391" "--port=32916"
# 16:02:52 >
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -5373,6 +5373,13 @@ insert into sys.systemfunctions (select
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "sys";
+commit;
+
# 18:26:24 >
# 18:26:24 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20759" "--port=37815"
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
@@ -238,6 +238,7 @@ Ready.
\dSf sys."queue"
\dSf sys."radians"
\dSf sys."rejects"
+\dSf sys."remote_table_credentials"
\dSf sys."replicabeat"
\dSf sys."replicaclock"
\dSf sys."replicate"
@@ -666,6 +667,7 @@ SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.rand
SYSTEM FUNCTION sys.rank
SYSTEM FUNCTION sys.rejects
+SYSTEM FUNCTION sys.remote_table_credentials
SYSTEM FUNCTION sys.repeat
SYSTEM FUNCTION sys.replace
SYSTEM PROCEDURE sys.replicabeat
@@ -1099,6 +1101,7 @@ create procedure sys.querylog_enable(thr
create function sys.queue() returns table(qtag bigint, "user" string, started
timestamp, estimate timestamp, progress int, status string, tag oid, query
string) external name sql.sysmon_queue;
create function radians(d double) returns double return d*pi()/180;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create procedure replicabeat(duration integer) external name
wlr."setreplicabeat";
create function replicaclock() returns string external name
wlr."getreplicaclock";
create procedure replicate() external name wlr.replicate;
@@ -2586,6 +2589,7 @@ drop function pcre_replace(string, strin
[ "sys", "rand", "sqlrand", "mmath", "Internal C", "Scalar
function", true, false, false, "res_0", "int", 32, 0,
"out", "arg_1", "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 ]
[ "sys", "rank", "rank", "sql", "Internal C", "Analytic function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "any", 0, 0, "in", "arg_2", "boolean",
1, 0, "in", "arg_3", "boolean", 1, 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
]
[ "sys", "rejects", "create function sys.rejects() returns
table(rowid bigint, fldid int, \"message\" string, \"input\" string) external
name sql.copy_rejects;", "sql", "MAL", "Function returning a table",
false, false, false, "rowid", "bigint", 64, 0, "out",
"fldid", "int", 32, 0, "out", "message", "clob", 0,
0, "out", "input", "clob", 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 ]
+[ "sys", "remote_table_credentials", "create function
sys.remote_table_credentials (tablename string) returns table (\"uri\" string,
\"username\" string, \"hash\" string) external name sql.rt_credentials;",
"sql", "MAL", "Function returning a table", false, false, false, "uri",
"clob", 0, 0, "out", "username", "clob", 0, 0, "out",
"hash", "clob", 0, 0, "out", "tablename", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "char", 0, 0,
"out", "arg_1", "char", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "clob", 0, 0,
"out", "arg_1", "clob", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "varchar", 0,
0, "out", "arg_1", "varchar", 0, 0, "in",
"arg_2", "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 ]
@@ -5424,6 +5428,7 @@ drop function pcre_replace(string, strin
[ "rand" ]
[ "rank" ]
[ "rejects" ]
+[ "remote_table_credentials" ]
[ "repeat" ]
[ "repeat" ]
[ "repeat" ]
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
@@ -238,6 +238,7 @@ Ready.
\dSf sys."queue"
\dSf sys."radians"
\dSf sys."rejects"
+\dSf sys."remote_table_credentials"
\dSf sys."replicabeat"
\dSf sys."replicaclock"
\dSf sys."replicate"
@@ -666,6 +667,7 @@ SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.rand
SYSTEM FUNCTION sys.rank
SYSTEM FUNCTION sys.rejects
+SYSTEM FUNCTION sys.remote_table_credentials
SYSTEM FUNCTION sys.repeat
SYSTEM FUNCTION sys.replace
SYSTEM PROCEDURE sys.replicabeat
@@ -1099,6 +1101,7 @@ create procedure sys.querylog_enable(thr
create function sys.queue() returns table(qtag bigint, "user" string, started
timestamp, estimate timestamp, progress int, status string, tag oid, query
string) external name sql.sysmon_queue;
create function radians(d double) returns double return d*pi()/180;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create procedure replicabeat(duration integer) external name
wlr."setreplicabeat";
create function replicaclock() returns string external name
wlr."getreplicaclock";
create procedure replicate() external name wlr.replicate;
@@ -2586,6 +2589,7 @@ drop function pcre_replace(string, strin
[ "sys", "rand", "sqlrand", "mmath", "Internal C", "Scalar
function", true, false, false, "res_0", "int", 32, 0,
"out", "arg_1", "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 ]
[ "sys", "rank", "rank", "sql", "Internal C", "Analytic function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "any", 0, 0, "in", "arg_2", "boolean",
1, 0, "in", "arg_3", "boolean", 1, 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
]
[ "sys", "rejects", "create function sys.rejects() returns
table(rowid bigint, fldid int, \"message\" string, \"input\" string) external
name sql.copy_rejects;", "sql", "MAL", "Function returning a table",
false, false, false, "rowid", "bigint", 64, 0, "out",
"fldid", "int", 32, 0, "out", "message", "clob", 0,
0, "out", "input", "clob", 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 ]
+[ "sys", "remote_table_credentials", "create function
sys.remote_table_credentials (tablename string) returns table (\"uri\" string,
\"username\" string, \"hash\" string) external name sql.rt_credentials;",
"sql", "MAL", "Function returning a table", false, false, false, "uri",
"clob", 0, 0, "out", "username", "clob", 0, 0, "out",
"hash", "clob", 0, 0, "out", "tablename", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "char", 0, 0,
"out", "arg_1", "char", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "clob", 0, 0,
"out", "arg_1", "clob", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "varchar", 0,
0, "out", "arg_1", "varchar", 0, 0, "in",
"arg_2", "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 ]
@@ -5424,6 +5428,7 @@ drop function pcre_replace(string, strin
[ "rand" ]
[ "rank" ]
[ "rejects" ]
+[ "remote_table_credentials" ]
[ "repeat" ]
[ "repeat" ]
[ "repeat" ]
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
@@ -238,6 +238,7 @@ Ready.
\dSf sys."queue"
\dSf sys."radians"
\dSf sys."rejects"
+\dSf sys."remote_table_credentials"
\dSf sys."replicabeat"
\dSf sys."replicaclock"
\dSf sys."replicate"
@@ -666,6 +667,7 @@ SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.rand
SYSTEM FUNCTION sys.rank
SYSTEM FUNCTION sys.rejects
+SYSTEM FUNCTION sys.remote_table_credentials
SYSTEM FUNCTION sys.repeat
SYSTEM FUNCTION sys.replace
SYSTEM PROCEDURE sys.replicabeat
@@ -1105,6 +1107,7 @@ create procedure sys.querylog_enable(thr
create function sys.queue() returns table(qtag bigint, "user" string, started
timestamp, estimate timestamp, progress int, status string, tag oid, query
string) external name sql.sysmon_queue;
create function radians(d double) returns double return d*pi()/180;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create procedure replicabeat(duration integer) external name
wlr."setreplicabeat";
create function replicaclock() returns string external name
wlr."getreplicaclock";
create procedure replicate() external name wlr.replicate;
@@ -2620,6 +2623,7 @@ drop function pcre_replace(string, strin
[ "sys", "rand", "sqlrand", "mmath", "Internal C", "Scalar
function", true, false, false, "res_0", "int", 32, 0,
"out", "arg_1", "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 ]
[ "sys", "rank", "rank", "sql", "Internal C", "Analytic function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "any", 0, 0, "in", "arg_2", "boolean",
1, 0, "in", "arg_3", "boolean", 1, 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
]
[ "sys", "rejects", "create function sys.rejects() returns
table(rowid bigint, fldid int, \"message\" string, \"input\" string) external
name sql.copy_rejects;", "sql", "MAL", "Function returning a table",
false, false, false, "rowid", "bigint", 64, 0, "out",
"fldid", "int", 32, 0, "out", "message", "clob", 0,
0, "out", "input", "clob", 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 ]
+[ "sys", "remote_table_credentials", "create function
sys.remote_table_credentials (tablename string) returns table (\"uri\" string,
\"username\" string, \"hash\" string) external name sql.rt_credentials;",
"sql", "MAL", "Function returning a table", false, false, false, "uri",
"clob", 0, 0, "out", "username", "clob", 0, 0, "out",
"hash", "clob", 0, 0, "out", "tablename", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "char", 0, 0,
"out", "arg_1", "char", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "clob", 0, 0,
"out", "arg_1", "clob", 0, 0, "in", "arg_2", "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 ]
[ "sys", "repeat", "repeat", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "varchar", 0,
0, "out", "arg_1", "varchar", 0, 0, "in",
"arg_2", "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 ]
@@ -5658,6 +5662,7 @@ drop function pcre_replace(string, strin
[ "rand" ]
[ "rank" ]
[ "rejects" ]
+[ "remote_table_credentials" ]
[ "repeat" ]
[ "repeat" ]
[ "repeat" ]
diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -43,9 +43,17 @@ insert into sys.systemfunctions (select
set schema "testschema";
commit;
-# 15:51:04 >
-# 15:51:04 > "/usr/bin/python" "upgrade.SQL.py" "upgrade"
-# 15:51:04 >
+Running database upgrade commands:
+set schema sys;
+create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
+insert into sys.systemfunctions (select id from sys.functions where
name='remote_table_credentials' and id not in (select function_id from
sys.systemfunctions));
+set schema "testschema";
+commit;
+
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
