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