Changeset: cea2aeb6e8f7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/cea2aeb6e8f7
Modified Files:
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
Branch: default
Log Message:
Approve powerpc upgrade.
diffs (92 lines):
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
@@ -70,27 +70,27 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'filter' and schema_id = (select id from sys.schemas where name = 'json') and
type = 1;
Running database upgrade commands:
-drop procedure if exists wlc.master();
-drop procedure if exists wlc.master(string);
-drop procedure if exists wlc.stop();
-drop procedure if exists wlc.flush();
-drop procedure if exists wlc.beat(int);
-drop function if exists wlc.clock();
-drop function if exists wlc.tick();
-drop procedure if exists wlr.master(string);
-drop procedure if exists wlr.stop();
-drop procedure if exists wlr.accept();
-drop procedure if exists wlr.replicate();
-drop procedure if exists wlr.replicate(timestamp);
-drop procedure if exists wlr.replicate(tinyint);
-drop procedure if exists wlr.replicate(smallint);
-drop procedure if exists wlr.replicate(integer);
-drop procedure if exists wlr.replicate(bigint);
-drop procedure if exists wlr.beat(integer);
-drop function if exists wlr.clock();
-drop function if exists wlr.tick();
-drop schema if exists wlc;
-drop schema if exists wlr;
+drop procedure if exists wlc.master() cascade;
+drop procedure if exists wlc.master(string) cascade;
+drop procedure if exists wlc.stop() cascade;
+drop procedure if exists wlc.flush() cascade;
+drop procedure if exists wlc.beat(int) cascade;
+drop function if exists wlc.clock() cascade;
+drop function if exists wlc.tick() cascade;
+drop procedure if exists wlr.master(string) cascade;
+drop procedure if exists wlr.stop() cascade;
+drop procedure if exists wlr.accept() cascade;
+drop procedure if exists wlr.replicate() cascade;
+drop procedure if exists wlr.replicate(timestamp) cascade;
+drop procedure if exists wlr.replicate(tinyint) cascade;
+drop procedure if exists wlr.replicate(smallint) cascade;
+drop procedure if exists wlr.replicate(integer) cascade;
+drop procedure if exists wlr.replicate(bigint) cascade;
+drop procedure if exists wlr.beat(integer) cascade;
+drop function if exists wlr.clock() cascade;
+drop function if exists wlr.tick() cascade;
+drop schema if exists wlc cascade;
+drop schema if exists wlr cascade;
Running database upgrade commands:
create function sys.regexp_replace(ori string, pat string, rep string, flg
string)
@@ -105,17 +105,17 @@ grant execute on function regexp_replace
update sys.functions set system = true where system <> true and name =
'regexp_replace' and schema_id = 2000 and type = 1;
Running database upgrade commands:
-drop function if exists sys.dump_database(boolean);
-drop procedure if exists sys.dump_table_data();
-drop procedure if exists sys.dump_table_data(string, string);
-drop view if exists sys.dump_tables;
-drop view if exists sys.dump_comments;
-drop function if exists sys.prepare_esc(string, string);
-drop view if exists sys.dump_partition_tables;
-drop view if exists sys.dump_create_users;
-drop view if exists sys.describe_tables;
-drop function if exists sys.get_remote_table_expressions(string, string);
-drop function if exists sys.sq(string);
+drop function if exists sys.dump_database(boolean) cascade;
+drop procedure if exists sys.dump_table_data() cascade;
+drop procedure if exists sys.dump_table_data(string, string) cascade;
+drop view if exists sys.dump_tables cascade;
+drop view if exists sys.dump_comments cascade;
+drop function if exists sys.prepare_esc(string, string) cascade;
+drop view if exists sys.dump_partition_tables cascade;
+drop view if exists sys.dump_create_users cascade;
+drop view if exists sys.describe_tables cascade;
+drop function if exists sys.get_remote_table_expressions(string, string)
cascade;
+drop function if exists sys.sq(string) cascade;
CREATE FUNCTION sys.SQ (s STRING) RETURNS STRING BEGIN RETURN '''' ||
sys.replace(s,'''','''''') || ''''; END;
CREATE FUNCTION sys.get_remote_table_expressions(s STRING, t STRING) RETURNS
STRING BEGIN
RETURN SELECT ' ON ' || sys.SQ(uri) || ' WITH USER ' || sys.SQ(username) || '
ENCRYPTED PASSWORD ' || sys.SQ("hash") FROM sys.remote_table_credentials(s
||'.' || t);
@@ -302,8 +302,8 @@ update sys.functions set system = true w
GRANT SELECT ON sys.describe_tables TO PUBLIC;
Running database upgrade commands:
-drop view if exists sys.dependency_tables_on_functions;
-drop view if exists sys.dependency_views_on_functions;
+drop view if exists sys.dependency_tables_on_functions cascade;
+drop view if exists sys.dependency_views_on_functions cascade;
CREATE VIEW sys.dependency_tables_on_functions AS
SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
f.id AS function_id, f.name AS function_name, f.type AS function_type,
dep.depend_type AS depend_type
FROM sys.functions AS f, sys.tables AS t, sys.dependencies AS dep
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
