Changeset: b64326ed7356 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b64326ed7356
Modified Files:
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
Branch: Sep2022
Log Message:
Approve upgrade output.
diffs (212 lines):
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -16,10 +16,10 @@ update sys.db_user_info u set max_memory
-- and copying passwords
Running database upgrade commands:
-drop view sys.dependency_schemas_on_users;
-drop view sys.roles;
-drop view sys.users;
-drop function sys.db_users();
+drop view sys.dependency_schemas_on_users cascade;
+drop view sys.roles cascade;
+drop view sys.users cascade;
+drop function sys.db_users() cascade;
CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE
a.name NOT IN (SELECT u.name FROM sys.db_user_info u);
GRANT SELECT ON sys.roles TO PUBLIC;
CREATE VIEW sys.users AS SELECT name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role FROM sys.db_user_info;
@@ -35,20 +35,20 @@ update sys._tables set system = true whe
update sys.functions set system = true where system <> true and name in
('db_users') and schema_id = 2000 and type = 5;
Running database upgrade commands:
-drop function sys.dump_database(boolean);
-drop procedure sys.dump_table_data();
-drop procedure sys.dump_table_data(string, string);
-drop view sys.dump_partition_tables;
-drop view sys.describe_partition_tables;
-drop view sys.dump_sequences;
-drop view sys.dump_start_sequences;
-drop view sys.dump_tables;
-drop view sys.describe_tables;
-drop view sys.dump_create_users;
-drop view sys.dump_functions;
-drop view sys.dump_triggers;
-drop function sys.schema_guard;
-drop function sys.replace_first(string, string, string, string);
+drop function sys.dump_database(boolean) cascade;
+drop procedure sys.dump_table_data() cascade;
+drop procedure sys.dump_table_data(string, string) cascade;
+drop view sys.dump_partition_tables cascade;
+drop view sys.describe_partition_tables cascade;
+drop view sys.dump_sequences cascade;
+drop view sys.dump_start_sequences cascade;
+drop view sys.dump_tables cascade;
+drop view sys.describe_tables cascade;
+drop view sys.dump_create_users cascade;
+drop view sys.dump_functions cascade;
+drop view sys.dump_triggers cascade;
+drop function sys.schema_guard cascade;
+drop function sys.replace_first(string, string, string, string) cascade;
CREATE FUNCTION sys.schema_guard(sch STRING, nme STRING, stmt STRING) RETURNS
STRING BEGIN
RETURN
SELECT 'SET SCHEMA ' || sys.dq(sch) || '; ' || stmt;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -10,10 +10,10 @@ update sys.db_user_info u set max_memory
-- and copying passwords
Running database upgrade commands:
-drop view sys.dependency_schemas_on_users;
-drop view sys.roles;
-drop view sys.users;
-drop function sys.db_users();
+drop view sys.dependency_schemas_on_users cascade;
+drop view sys.roles cascade;
+drop view sys.users cascade;
+drop function sys.db_users() cascade;
CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE
a.name NOT IN (SELECT u.name FROM sys.db_user_info u);
GRANT SELECT ON sys.roles TO PUBLIC;
CREATE VIEW sys.users AS SELECT name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role FROM sys.db_user_info;
@@ -29,20 +29,20 @@ update sys._tables set system = true whe
update sys.functions set system = true where system <> true and name in
('db_users') and schema_id = 2000 and type = 5;
Running database upgrade commands:
-drop function sys.dump_database(boolean);
-drop procedure sys.dump_table_data();
-drop procedure sys.dump_table_data(string, string);
-drop view sys.dump_partition_tables;
-drop view sys.describe_partition_tables;
-drop view sys.dump_sequences;
-drop view sys.dump_start_sequences;
-drop view sys.dump_tables;
-drop view sys.describe_tables;
-drop view sys.dump_create_users;
-drop view sys.dump_functions;
-drop view sys.dump_triggers;
-drop function sys.schema_guard;
-drop function sys.replace_first(string, string, string, string);
+drop function sys.dump_database(boolean) cascade;
+drop procedure sys.dump_table_data() cascade;
+drop procedure sys.dump_table_data(string, string) cascade;
+drop view sys.dump_partition_tables cascade;
+drop view sys.describe_partition_tables cascade;
+drop view sys.dump_sequences cascade;
+drop view sys.dump_start_sequences cascade;
+drop view sys.dump_tables cascade;
+drop view sys.describe_tables cascade;
+drop view sys.dump_create_users cascade;
+drop view sys.dump_functions cascade;
+drop view sys.dump_triggers cascade;
+drop function sys.schema_guard cascade;
+drop function sys.replace_first(string, string, string, string) cascade;
CREATE FUNCTION sys.schema_guard(sch STRING, nme STRING, stmt STRING) RETURNS
STRING BEGIN
RETURN
SELECT 'SET SCHEMA ' || sys.dq(sch) || '; ' || stmt;
diff --git a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -16,10 +16,10 @@ update sys.db_user_info u set max_memory
-- and copying passwords
Running database upgrade commands:
-drop view sys.dependency_schemas_on_users;
-drop view sys.roles;
-drop view sys.users;
-drop function sys.db_users();
+drop view sys.dependency_schemas_on_users cascade;
+drop view sys.roles cascade;
+drop view sys.users cascade;
+drop function sys.db_users() cascade;
CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE
a.name NOT IN (SELECT u.name FROM sys.db_user_info u);
GRANT SELECT ON sys.roles TO PUBLIC;
CREATE VIEW sys.users AS SELECT name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role FROM sys.db_user_info;
@@ -35,20 +35,20 @@ update sys._tables set system = true whe
update sys.functions set system = true where system <> true and name in
('db_users') and schema_id = 2000 and type = 5;
Running database upgrade commands:
-drop function sys.dump_database(boolean);
-drop procedure sys.dump_table_data();
-drop procedure sys.dump_table_data(string, string);
-drop view sys.dump_partition_tables;
-drop view sys.describe_partition_tables;
-drop view sys.dump_sequences;
-drop view sys.dump_start_sequences;
-drop view sys.dump_tables;
-drop view sys.describe_tables;
-drop view sys.dump_create_users;
-drop view sys.dump_functions;
-drop view sys.dump_triggers;
-drop function sys.schema_guard;
-drop function sys.replace_first(string, string, string, string);
+drop function sys.dump_database(boolean) cascade;
+drop procedure sys.dump_table_data() cascade;
+drop procedure sys.dump_table_data(string, string) cascade;
+drop view sys.dump_partition_tables cascade;
+drop view sys.describe_partition_tables cascade;
+drop view sys.dump_sequences cascade;
+drop view sys.dump_start_sequences cascade;
+drop view sys.dump_tables cascade;
+drop view sys.describe_tables cascade;
+drop view sys.dump_create_users cascade;
+drop view sys.dump_functions cascade;
+drop view sys.dump_triggers cascade;
+drop function sys.schema_guard cascade;
+drop function sys.replace_first(string, string, string, string) cascade;
CREATE FUNCTION sys.schema_guard(sch STRING, nme STRING, stmt STRING) RETURNS
STRING BEGIN
RETURN
SELECT 'SET SCHEMA ' || sys.dq(sch) || '; ' || stmt;
diff --git a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
@@ -10,10 +10,10 @@ update sys.db_user_info u set max_memory
-- and copying passwords
Running database upgrade commands:
-drop view sys.dependency_schemas_on_users;
-drop view sys.roles;
-drop view sys.users;
-drop function sys.db_users();
+drop view sys.dependency_schemas_on_users cascade;
+drop view sys.roles cascade;
+drop view sys.users cascade;
+drop function sys.db_users() cascade;
CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE
a.name NOT IN (SELECT u.name FROM sys.db_user_info u);
GRANT SELECT ON sys.roles TO PUBLIC;
CREATE VIEW sys.users AS SELECT name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role FROM sys.db_user_info;
@@ -29,20 +29,20 @@ update sys._tables set system = true whe
update sys.functions set system = true where system <> true and name in
('db_users') and schema_id = 2000 and type = 5;
Running database upgrade commands:
-drop function sys.dump_database(boolean);
-drop procedure sys.dump_table_data();
-drop procedure sys.dump_table_data(string, string);
-drop view sys.dump_partition_tables;
-drop view sys.describe_partition_tables;
-drop view sys.dump_sequences;
-drop view sys.dump_start_sequences;
-drop view sys.dump_tables;
-drop view sys.describe_tables;
-drop view sys.dump_create_users;
-drop view sys.dump_functions;
-drop view sys.dump_triggers;
-drop function sys.schema_guard;
-drop function sys.replace_first(string, string, string, string);
+drop function sys.dump_database(boolean) cascade;
+drop procedure sys.dump_table_data() cascade;
+drop procedure sys.dump_table_data(string, string) cascade;
+drop view sys.dump_partition_tables cascade;
+drop view sys.describe_partition_tables cascade;
+drop view sys.dump_sequences cascade;
+drop view sys.dump_start_sequences cascade;
+drop view sys.dump_tables cascade;
+drop view sys.describe_tables cascade;
+drop view sys.dump_create_users cascade;
+drop view sys.dump_functions cascade;
+drop view sys.dump_triggers cascade;
+drop function sys.schema_guard cascade;
+drop function sys.replace_first(string, string, string, string) cascade;
CREATE FUNCTION sys.schema_guard(sch STRING, nme STRING, stmt STRING) RETURNS
STRING BEGIN
RETURN
SELECT 'SET SCHEMA ' || sys.dq(sch) || '; ' || stmt;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
