Changeset: 809fb8a9b884 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/809fb8a9b884
Modified Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
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.int128
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.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.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.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.int128
Branch: default
Log Message:
Approve upgrade.
diffs (truncated from 650 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -562,3 +562,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -562,3 +562,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -631,3 +631,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
diff --git
a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -556,3 +556,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -556,3 +556,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
@@ -625,3 +625,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -230,3 +230,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -230,3 +230,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -301,3 +301,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -301,3 +301,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -230,3 +230,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND t.type NOT IN (1, 11)
+ ORDER BY t.name, t.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_tables_on_functions TO PUBLIC;
+CREATE VIEW sys.dependency_views_on_functions AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_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 v, sys.dependencies AS dep
+ WHERE v.id = dep.id AND f.id = dep.depend_id
+ AND dep.depend_type = 7 AND f.type <> 2 AND v.type IN (1, 11)
+ ORDER BY v.name, v.schema_id, f.name, f.id;
+GRANT SELECT ON sys.dependency_views_on_functions TO PUBLIC;
+update sys._tables set system = true where system <> true and name in
('dependency_tables_on_functions','dependency_views_on_functions') and
schema_id = 2000;
+
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
@@ -230,3 +230,22 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'dump_database' and schema_id = 2000 and type = 5;
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;
+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
+ WHERE t.id = dep.id AND f.id = dep.depend_id
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
