Changeset: a6ac132bb75b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a6ac132bb75b
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.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.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.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.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: default
Log Message:
Approve recent changes.
diffs (291 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
@@ -5019,6 +5019,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -5019,6 +5019,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -5093,6 +5093,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -5093,6 +5093,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -5019,6 +5019,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -5093,6 +5093,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
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
@@ -1155,7 +1155,7 @@ create function sys.describe_type(ctype
end;
create function sys.dq (s string) returns string begin return '"' || s || '"';
end;
create procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
-create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;
+create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;
create procedure sys.dump_table_data() begin declare i int; set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system); if i is not null then
declare m int; set m = (select max(t.id) from sys.tables t, sys.table_types ts
where t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not
t.system); declare sch string; declare tbl string; while i < m do set sch =
(select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id = i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id
= t.schema_id and t.id = i); call _dump_table_data(sch, tbl); set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set
sch = (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); set tbl = (select t.name from sys.tables t, sys.sc
hemas s where s.id = t.schema_id and t.id = i); call _dump_table_data(sch,
tbl); end if; end;
CREATE FUNCTION env() RETURNS TABLE(name varchar(1024), value varchar(2048))
EXTERNAL NAME inspect."getEnvironment";
create function sys.epoch(sec bigint) returns timestamp with time zone
external name mtime.epoch;
@@ -2701,7 +2701,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 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", "dq", "SYSTEM", "create function sys.dq
(s string) returns string begin return '\"' || s || '\"'; end;", "user",
"SQL", "Scalar function", false, false, false, true, "result",
"clob", 0, 0, "out", "s", "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", "droporderindex", "SYSTEM", "create
procedure sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;", "user", "SQL", "Function returning a table",
false, false, false, true, "o", "int", 32, 0, "out", "stmt",
"clob", 0, 0, "out", "describe", "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, NU
LL, NULL, NULL, NULL, NULL, NULL, 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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;", "user", "SQL", "Function
returning a table", false, false, false, true, "o", "int", 32,
0, "out", "stmt", "clob", 0, 0, "out", "describe",
"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, NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
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", "dump_table_data", "SYSTEM", "create
procedure sys.dump_table_data() begin declare i int; set i = (select min(t.id)
from sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system); if i is not null then declare m
int; set m = (select max(t.id) from sys.tables t, sys.table_types ts where
t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not t.system);
declare sch string; declare tbl string; while i < m do set sch = (select s.name
from sys.tables t, sys.schemas s where s.id = t.schema_id and t.id = i); set
tbl = (select t.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); call _dump_table_data(sch, tbl); set i = (select min(t.id) from
sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set sch
= (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id
= i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id =
t.schema_id and t.id = i); call _dump_table_data(sch, tbl); end if; end;",
"user", "SQL", "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", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "char", 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", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "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 ]
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
@@ -1155,7 +1155,7 @@ create function sys.describe_type(ctype
end;
create function sys.dq (s string) returns string begin return '"' || s || '"';
end;
create procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
-create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;
+create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;
create procedure sys.dump_table_data() begin declare i int; set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system); if i is not null then
declare m int; set m = (select max(t.id) from sys.tables t, sys.table_types ts
where t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not
t.system); declare sch string; declare tbl string; while i < m do set sch =
(select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id = i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id
= t.schema_id and t.id = i); call _dump_table_data(sch, tbl); set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set
sch = (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); set tbl = (select t.name from sys.tables t, sys.sc
hemas s where s.id = t.schema_id and t.id = i); call _dump_table_data(sch,
tbl); end if; end;
CREATE FUNCTION env() RETURNS TABLE(name varchar(1024), value varchar(2048))
EXTERNAL NAME inspect."getEnvironment";
create function sys.epoch(sec bigint) returns timestamp with time zone
external name mtime.epoch;
@@ -2701,7 +2701,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 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", "dq", "SYSTEM", "create function sys.dq
(s string) returns string begin return '\"' || s || '\"'; end;", "user",
"SQL", "Scalar function", false, false, false, true, "result",
"clob", 0, 0, "out", "s", "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", "droporderindex", "SYSTEM", "create
procedure sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;", "user", "SQL", "Function returning a table",
false, false, false, true, "o", "int", 32, 0, "out", "stmt",
"clob", 0, 0, "out", "describe", "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, NU
LL, NULL, NULL, NULL, NULL, NULL, 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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;", "user", "SQL", "Function
returning a table", false, false, false, true, "o", "int", 32,
0, "out", "stmt", "clob", 0, 0, "out", "describe",
"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, NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
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", "dump_table_data", "SYSTEM", "create
procedure sys.dump_table_data() begin declare i int; set i = (select min(t.id)
from sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system); if i is not null then declare m
int; set m = (select max(t.id) from sys.tables t, sys.table_types ts where
t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not t.system);
declare sch string; declare tbl string; while i < m do set sch = (select s.name
from sys.tables t, sys.schemas s where s.id = t.schema_id and t.id = i); set
tbl = (select t.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); call _dump_table_data(sch, tbl); set i = (select min(t.id) from
sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set sch
= (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id
= i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id =
t.schema_id and t.id = i); call _dump_table_data(sch, tbl); end if; end;",
"user", "SQL", "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", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "char", 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", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "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 ]
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
@@ -1161,7 +1161,7 @@ create function sys.describe_type(ctype
end;
create function sys.dq (s string) returns string begin return '"' || s || '"';
end;
create procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
-create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;
+create function sys.dump_database(describe boolean) returns table(o int, stmt
string) begin set schema sys; truncate dump_statements; insert into
dump_statements values (1, 'START TRANSACTION;'); insert into dump_statements
values (current_size_dump_statements() + 1, 'SET SCHEMA "sys";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_grant_use
r_priviledges; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_sequences;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_statements select
current_size_dump_statements() + rank() o
ver(), stmt from sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;
create procedure sys.dump_table_data() begin declare i int; set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system); if i is not null then
declare m int; set m = (select max(t.id) from sys.tables t, sys.table_types ts
where t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not
t.system); declare sch string; declare tbl string; while i < m do set sch =
(select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id = i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id
= t.schema_id and t.id = i); call _dump_table_data(sch, tbl); set i = (select
min(t.id) from sys.tables t, sys.table_types ts where t.type = ts.table_type_id
and ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set
sch = (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); set tbl = (select t.name from sys.tables t, sys.sc
hemas s where s.id = t.schema_id and t.id = i); call _dump_table_data(sch,
tbl); end if; end;
CREATE FUNCTION env() RETURNS TABLE(name varchar(1024), value varchar(2048))
EXTERNAL NAME inspect."getEnvironment";
create function sys.epoch(sec bigint) returns timestamp with time zone
external name mtime.epoch;
@@ -2743,7 +2743,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 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", "dq", "SYSTEM", "create function sys.dq
(s string) returns string begin return '\"' || s || '\"'; end;", "user",
"SQL", "Scalar function", false, false, false, true, "result",
"clob", 0, 0, "out", "s", "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", "droporderindex", "SYSTEM", "create
procedure sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
return dump_statements; end;", "user", "SQL", "Function returning a table",
false, false, false, true, "o", "int", 32, 0, "out", "stmt",
"clob", 0, 0, "out", "describe", "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, NU
LL, NULL, NULL, NULL, NULL, NULL, 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", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate dump_statements; insert into dump_statements
values (1, 'START TRANSACTION;'); insert into dump_statements values
(current_size_dump_statements() + 1, 'SET SCHEMA \"sys\";'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_create_roles; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_users; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_create_schemas; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_user_defined_types; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_add_schemas_to_users; insert into dump_statements select
current_size_dump_st
atements() + rank() over(), stmt from sys.dump_grant_user_priviledges; insert
into dump_statements select current_size_dump_statements() + rank() over(),
stmt from sys.dump_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from
sys.dump_start_sequences; insert into dump_statements select
current_size_dump_statements() + rank() over(order by stmts.o), stmts.s from
(select * from sys.dump_functions f union select * from sys.dump_tables t) as
stmts(o, s); insert into dump_statements select current_size_dump_statements()
+ rank() over(), stmt from sys.dump_column_defaults; insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_table_constraint_type; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_indices;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_foreign_keys; insert into dump_sta
tements select current_size_dump_statements() + rank() over(), stmt from
sys.dump_partition_tables; insert into dump_statements select
current_size_dump_statements() + rank() over(), stmt from sys.dump_triggers;
insert into dump_statements select current_size_dump_statements() + rank()
over(), stmt from sys.dump_comments; insert into dump_statements values
(current_size_dump_statements() + 1, 'TRUNCATE sys.privileges;'); insert into
dump_statements select current_size_dump_statements() + rank() over(), stmt
from sys.dump_privileges; if not describe then call dump_table_data(); end if;
insert into dump_statements values (current_size_dump_statements() + 1,
'COMMIT;'); return dump_statements; end;", "user", "SQL", "Function
returning a table", false, false, false, true, "o", "int", 32,
0, "out", "stmt", "clob", 0, 0, "out", "describe",
"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, NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
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", "dump_table_data", "SYSTEM", "create
procedure sys.dump_table_data() begin declare i int; set i = (select min(t.id)
from sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system); if i is not null then declare m
int; set m = (select max(t.id) from sys.tables t, sys.table_types ts where
t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not t.system);
declare sch string; declare tbl string; while i < m do set sch = (select s.name
from sys.tables t, sys.schemas s where s.id = t.schema_id and t.id = i); set
tbl = (select t.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); call _dump_table_data(sch, tbl); set i = (select min(t.id) from
sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system and t.id > i); end while; set sch
= (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id and
t.id
= i); set tbl = (select t.name from sys.tables t, sys.schemas s where s.id =
t.schema_id and t.id = i); call _dump_table_data(sch, tbl); end if; end;",
"user", "SQL", "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", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "char", 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", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "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 ]
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
@@ -5019,6 +5019,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5093,6 +5093,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -5019,6 +5019,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
@@ -4424,6 +4424,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
@@ -5093,6 +5093,8 @@ BEGIN
CALL dump_table_data();
END IF;
+ INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1,
'COMMIT;');
+
RETURN dump_statements;
END;
UPDATE sys.functions f SET system = true WHERE
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
