Changeset: 35cc1a5b221f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=35cc1a5b221f
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
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: Mar2018
Log Message:
Approve after changeset f74f0724d3b9.
diffs (truncated from 2457 to 300 lines):
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -5521,41 +5521,42 @@ SELECT k.table_id AS key_table_id, k.id
GRANT SELECT ON sys.dependency_keys_on_foreignkeys TO PUBLIC;
-CREATE VIEW sys.dependency_tables_on_procdures AS
-SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.name, p.type AS proc_type, dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_tables_on_procedures AS
+SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS t, sys.dependencies AS dep
WHERE t.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND t.type NOT IN (1, 11)
ORDER BY t.name, t.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_tables_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_tables_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_views_on_procdures AS
-SELECT v.name AS view_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_views_on_procedures AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS v, sys.dependencies AS dep
WHERE v.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND v.type IN (1, 11)
ORDER BY v.name, v.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_views_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_views_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_columns_on_procdures AS
-SELECT c.name AS column_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_columns_on_procedures AS
+SELECT c.table_id, c.id AS column_id, c.name AS column_name, p.id AS
procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.columns AS c, sys.dependencies AS dep
WHERE c.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
ORDER BY c.name, c.table_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_columns_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_columns_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_functions_on_procdures AS
-SELECT p.name AS proc_name, p.type AS proc_type, f2.name AS func_name, f2.type
AS func_type, dep.depend_type AS depend_type
- FROM sys.functions AS p, sys.functions AS f2, sys.dependencies AS dep
- WHERE f2.id = dep.id AND p.id = dep.depend_id
+CREATE VIEW sys.dependency_functions_on_procedures AS
+SELECT f.schema_id AS function_schema_id, f.id AS function_id, f.name AS
function_name, f.type AS function_type,
+ p.schema_id AS procedure_schema_id, p.id AS procedure_id, p.name AS
procedure_name, p.type AS procedure_type, dep.depend_type AS depend_type
+ FROM sys.functions AS p, sys.functions AS f, sys.dependencies AS dep
+ WHERE f.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
- ORDER BY p.name, p.id, f2.name, f2.id;
+ ORDER BY p.name, p.id, f.name, f.id;
-GRANT SELECT ON sys.dependency_functions_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_functions_on_procedures TO PUBLIC;
CREATE VIEW sys.dependency_columns_on_types AS
SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
dt.id AS type_id, dt.sqlname AS type_name, c.id AS column_id, c.name AS
column_name, dep.depend_type AS depend_type
@@ -5592,7 +5593,7 @@ UPDATE sys._tables SET system = true
'dependency_tables_on_triggers', 'dependency_columns_on_triggers',
'dependency_functions_on_triggers',
'dependency_tables_on_indexes', 'dependency_columns_on_indexes',
'dependency_tables_on_foreignkeys', 'dependency_keys_on_foreignkeys',
- 'dependency_tables_on_procdures', 'dependency_views_on_procdures',
'dependency_columns_on_procdures', 'dependency_functions_on_procdures',
+ 'dependency_tables_on_procedures', 'dependency_views_on_procedures',
'dependency_columns_on_procedures', 'dependency_functions_on_procedures',
'dependency_columns_on_types', 'dependency_functions_on_types',
'dependency_args_on_types')
AND schema_id IN (SELECT id FROM sys.schemas WHERE name = 'sys');
drop view sys.environment cascade;
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
@@ -5516,41 +5516,42 @@ SELECT k.table_id AS key_table_id, k.id
GRANT SELECT ON sys.dependency_keys_on_foreignkeys TO PUBLIC;
-CREATE VIEW sys.dependency_tables_on_procdures AS
-SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.name, p.type AS proc_type, dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_tables_on_procedures AS
+SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS t, sys.dependencies AS dep
WHERE t.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND t.type NOT IN (1, 11)
ORDER BY t.name, t.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_tables_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_tables_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_views_on_procdures AS
-SELECT v.name AS view_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_views_on_procedures AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS v, sys.dependencies AS dep
WHERE v.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND v.type IN (1, 11)
ORDER BY v.name, v.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_views_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_views_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_columns_on_procdures AS
-SELECT c.name AS column_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_columns_on_procedures AS
+SELECT c.table_id, c.id AS column_id, c.name AS column_name, p.id AS
procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.columns AS c, sys.dependencies AS dep
WHERE c.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
ORDER BY c.name, c.table_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_columns_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_columns_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_functions_on_procdures AS
-SELECT p.name AS proc_name, p.type AS proc_type, f2.name AS func_name, f2.type
AS func_type, dep.depend_type AS depend_type
- FROM sys.functions AS p, sys.functions AS f2, sys.dependencies AS dep
- WHERE f2.id = dep.id AND p.id = dep.depend_id
+CREATE VIEW sys.dependency_functions_on_procedures AS
+SELECT f.schema_id AS function_schema_id, f.id AS function_id, f.name AS
function_name, f.type AS function_type,
+ p.schema_id AS procedure_schema_id, p.id AS procedure_id, p.name AS
procedure_name, p.type AS procedure_type, dep.depend_type AS depend_type
+ FROM sys.functions AS p, sys.functions AS f, sys.dependencies AS dep
+ WHERE f.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
- ORDER BY p.name, p.id, f2.name, f2.id;
+ ORDER BY p.name, p.id, f.name, f.id;
-GRANT SELECT ON sys.dependency_functions_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_functions_on_procedures TO PUBLIC;
CREATE VIEW sys.dependency_columns_on_types AS
SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
dt.id AS type_id, dt.sqlname AS type_name, c.id AS column_id, c.name AS
column_name, dep.depend_type AS depend_type
@@ -5587,7 +5588,7 @@ UPDATE sys._tables SET system = true
'dependency_tables_on_triggers', 'dependency_columns_on_triggers',
'dependency_functions_on_triggers',
'dependency_tables_on_indexes', 'dependency_columns_on_indexes',
'dependency_tables_on_foreignkeys', 'dependency_keys_on_foreignkeys',
- 'dependency_tables_on_procdures', 'dependency_views_on_procdures',
'dependency_columns_on_procdures', 'dependency_functions_on_procdures',
+ 'dependency_tables_on_procedures', 'dependency_views_on_procedures',
'dependency_columns_on_procedures', 'dependency_functions_on_procedures',
'dependency_columns_on_types', 'dependency_functions_on_types',
'dependency_args_on_types')
AND schema_id IN (SELECT id FROM sys.schemas WHERE name = 'sys');
drop view sys.environment cascade;
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
@@ -4812,41 +4812,42 @@ SELECT k.table_id AS key_table_id, k.id
GRANT SELECT ON sys.dependency_keys_on_foreignkeys TO PUBLIC;
-CREATE VIEW sys.dependency_tables_on_procdures AS
-SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.name, p.type AS proc_type, dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_tables_on_procedures AS
+SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS t, sys.dependencies AS dep
WHERE t.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND t.type NOT IN (1, 11)
ORDER BY t.name, t.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_tables_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_tables_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_views_on_procdures AS
-SELECT v.name AS view_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_views_on_procedures AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS v, sys.dependencies AS dep
WHERE v.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND v.type IN (1, 11)
ORDER BY v.name, v.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_views_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_views_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_columns_on_procdures AS
-SELECT c.name AS column_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_columns_on_procedures AS
+SELECT c.table_id, c.id AS column_id, c.name AS column_name, p.id AS
procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.columns AS c, sys.dependencies AS dep
WHERE c.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
ORDER BY c.name, c.table_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_columns_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_columns_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_functions_on_procdures AS
-SELECT p.name AS proc_name, p.type AS proc_type, f2.name AS func_name, f2.type
AS func_type, dep.depend_type AS depend_type
- FROM sys.functions AS p, sys.functions AS f2, sys.dependencies AS dep
- WHERE f2.id = dep.id AND p.id = dep.depend_id
+CREATE VIEW sys.dependency_functions_on_procedures AS
+SELECT f.schema_id AS function_schema_id, f.id AS function_id, f.name AS
function_name, f.type AS function_type,
+ p.schema_id AS procedure_schema_id, p.id AS procedure_id, p.name AS
procedure_name, p.type AS procedure_type, dep.depend_type AS depend_type
+ FROM sys.functions AS p, sys.functions AS f, sys.dependencies AS dep
+ WHERE f.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
- ORDER BY p.name, p.id, f2.name, f2.id;
+ ORDER BY p.name, p.id, f.name, f.id;
-GRANT SELECT ON sys.dependency_functions_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_functions_on_procedures TO PUBLIC;
CREATE VIEW sys.dependency_columns_on_types AS
SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
dt.id AS type_id, dt.sqlname AS type_name, c.id AS column_id, c.name AS
column_name, dep.depend_type AS depend_type
@@ -4883,7 +4884,7 @@ UPDATE sys._tables SET system = true
'dependency_tables_on_triggers', 'dependency_columns_on_triggers',
'dependency_functions_on_triggers',
'dependency_tables_on_indexes', 'dependency_columns_on_indexes',
'dependency_tables_on_foreignkeys', 'dependency_keys_on_foreignkeys',
- 'dependency_tables_on_procdures', 'dependency_views_on_procdures',
'dependency_columns_on_procdures', 'dependency_functions_on_procdures',
+ 'dependency_tables_on_procedures', 'dependency_views_on_procedures',
'dependency_columns_on_procedures', 'dependency_functions_on_procedures',
'dependency_columns_on_types', 'dependency_functions_on_types',
'dependency_args_on_types')
AND schema_id IN (SELECT id FROM sys.schemas WHERE name = 'sys');
drop view sys.environment cascade;
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
@@ -4812,41 +4812,42 @@ SELECT k.table_id AS key_table_id, k.id
GRANT SELECT ON sys.dependency_keys_on_foreignkeys TO PUBLIC;
-CREATE VIEW sys.dependency_tables_on_procdures AS
-SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.name, p.type AS proc_type, dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_tables_on_procedures AS
+SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS t, sys.dependencies AS dep
WHERE t.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND t.type NOT IN (1, 11)
ORDER BY t.name, t.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_tables_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_tables_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_views_on_procdures AS
-SELECT v.name AS view_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_views_on_procedures AS
+SELECT v.schema_id AS view_schema_id, v.id AS view_id, v.name AS view_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS v, sys.dependencies AS dep
WHERE v.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND v.type IN (1, 11)
ORDER BY v.name, v.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_views_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_views_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_columns_on_procdures AS
-SELECT c.name AS column_name, p.name AS proc_name, p.type AS proc_type,
dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_columns_on_procedures AS
+SELECT c.table_id, c.id AS column_id, c.name AS column_name, p.id AS
procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.columns AS c, sys.dependencies AS dep
WHERE c.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
ORDER BY c.name, c.table_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_columns_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_columns_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_functions_on_procdures AS
-SELECT p.name AS proc_name, p.type AS proc_type, f2.name AS func_name, f2.type
AS func_type, dep.depend_type AS depend_type
- FROM sys.functions AS p, sys.functions AS f2, sys.dependencies AS dep
- WHERE f2.id = dep.id AND p.id = dep.depend_id
+CREATE VIEW sys.dependency_functions_on_procedures AS
+SELECT f.schema_id AS function_schema_id, f.id AS function_id, f.name AS
function_name, f.type AS function_type,
+ p.schema_id AS procedure_schema_id, p.id AS procedure_id, p.name AS
procedure_name, p.type AS procedure_type, dep.depend_type AS depend_type
+ FROM sys.functions AS p, sys.functions AS f, sys.dependencies AS dep
+ WHERE f.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2
- ORDER BY p.name, p.id, f2.name, f2.id;
+ ORDER BY p.name, p.id, f.name, f.id;
-GRANT SELECT ON sys.dependency_functions_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_functions_on_procedures TO PUBLIC;
CREATE VIEW sys.dependency_columns_on_types AS
SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
dt.id AS type_id, dt.sqlname AS type_name, c.id AS column_id, c.name AS
column_name, dep.depend_type AS depend_type
@@ -4883,7 +4884,7 @@ UPDATE sys._tables SET system = true
'dependency_tables_on_triggers', 'dependency_columns_on_triggers',
'dependency_functions_on_triggers',
'dependency_tables_on_indexes', 'dependency_columns_on_indexes',
'dependency_tables_on_foreignkeys', 'dependency_keys_on_foreignkeys',
- 'dependency_tables_on_procdures', 'dependency_views_on_procdures',
'dependency_columns_on_procdures', 'dependency_functions_on_procdures',
+ 'dependency_tables_on_procedures', 'dependency_views_on_procedures',
'dependency_columns_on_procedures', 'dependency_functions_on_procedures',
'dependency_columns_on_types', 'dependency_functions_on_types',
'dependency_args_on_types')
AND schema_id IN (SELECT id FROM sys.schemas WHERE name = 'sys');
drop view sys.environment cascade;
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
@@ -5571,41 +5571,42 @@ SELECT k.table_id AS key_table_id, k.id
GRANT SELECT ON sys.dependency_keys_on_foreignkeys TO PUBLIC;
-CREATE VIEW sys.dependency_tables_on_procdures AS
-SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.name, p.type AS proc_type, dep.depend_type AS depend_type
+CREATE VIEW sys.dependency_tables_on_procedures AS
+SELECT t.schema_id AS table_schema_id, t.id AS table_id, t.name AS table_name,
p.id AS procedure_id, p.name AS procedure_name, p.type AS procedure_type,
dep.depend_type AS depend_type
FROM sys.functions AS p, sys.tables AS t, sys.dependencies AS dep
WHERE t.id = dep.id AND p.id = dep.depend_id
AND dep.depend_type = 13 AND p.type = 2 AND t.type NOT IN (1, 11)
ORDER BY t.name, t.schema_id, p.name, p.id;
-GRANT SELECT ON sys.dependency_tables_on_procdures TO PUBLIC;
+GRANT SELECT ON sys.dependency_tables_on_procedures TO PUBLIC;
-CREATE VIEW sys.dependency_views_on_procdures AS
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
