Changeset: 92ad0ec9c048 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=92ad0ec9c048 Modified Files: sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 Branch: default Log Message:
Use schema extensions table. diffs (truncated from 3049 to 300 lines): diff --git a/sql/test/emptydb/Tests/check.SQL.py b/sql/test/emptydb/Tests/check.SQL.py --- a/sql/test/emptydb/Tests/check.SQL.py +++ b/sql/test/emptydb/Tests/check.SQL.py @@ -99,22 +99,21 @@ for i in range(0, MAXARGS): out += ";" # substring used a bunch of time in the queries below -depvals = "(values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name)" out += ''' -- auths select name, grantor from sys.auths; -- db_user_info select u.name, u.fullname, s.name from sys.db_user_info u left outer join sys.schemas s on u.default_schema = s.id order by u.name; -- dependencies -select s1.name, f1.name, s2.name, f2.name, dt.name from %s, sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.id and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name; -select s1.name, t.name, s2.name, f.name, dt.name from %s, sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; -select s1.name, t.name, c.name, s2.name, f.name, dt.name from %s, sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; -select s1.name, f1.name, s2.name, t2.name, dt.name from %s, schemas s1, functions f1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, f1.name; -select s1.name, t1.name, s2.name, t2.name, dt.name from %s, schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, dt.name from %s, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.name from %s, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.depend_type = dt.id and d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, dt.name from %s, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.depend_type = dt.id and d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name, c1.name; -select t.systemname, t.sqlname, s.name, f.name, dt.name from %s, types t, functions f, schemas s, dependencies d where d.depend_type = dt.id and d.id = t.id and d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname; +select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name; +select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; +select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; +select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, functions f1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, f1.name; +select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name, c1.name; +select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from sys.dependency_types dt, types t, functions f, schemas s, dependencies d where d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname; -- idxs select t.name, i.name, i.type from sys.idxs i left outer join sys._tables t on t.id = i.table_id order by t.name, i.name; -- keys @@ -152,7 +151,7 @@ select table_type_id, table_type_name fr select dependency_type_id, dependency_type_name from sys.dependency_types order by dependency_type_id, dependency_type_name; -- drop helper function drop function pcre_replace(string, string, string, string); -''' % ((depvals,)*9) +''' sys.stdout.write(out) diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -1237,15 +1237,15 @@ select name, grantor from sys.auths; -- db_user_info select u.name, u.fullname, s.name from sys.db_user_info u left outer join sys.schemas s on u.default_schema = s.id order by u.name; -- dependencies -select s1.name, f1.name, s2.name, f2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.id and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name; -select s1.name, t.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; -select s1.name, t.name, c.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; -select s1.name, f1.name, s2.name, t2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), schemas s1, functions f1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, f1.name; -select s1.name, t1.name, s2.name, t2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.depend_type = dt.id and d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; -select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.depend_type = dt.id and d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name, c1.name; -select t.systemname, t.sqlname, s.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), types t, functions f, schemas s, dependencies d where d.depend_type = dt.id and d.id = t.id and d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname; +select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name; +select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; +select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from sys.dependency_types dt, sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; +select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, functions f1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, f1.name; +select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependency_types dt, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; +select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name, c1.name; +select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from sys.dependency_types dt, types t, functions f, schemas s, dependencies d where d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname; -- idxs select t.name, i.name, i.type from sys.idxs i left outer join sys._tables t on t.id = i.table_id order by t.name, i.name; -- keys @@ -3372,489 +3372,489 @@ drop function pcre_replace(string, strin % varchar, varchar, varchar # type % 7, 13, 3 # length [ "monetdb", "MonetDB Admin", "sys" ] -#select s1.name, f1.name, s2.name, f2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.id and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name; -% sys.s1, sys.f1, sys.s2, sys.f2, .dt # table_name -% name, name, name, name, name # name -% varchar, varchar, varchar, varchar, char # type -% 3, 17, 3, 13, 20 # length -[ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNC_DEPENDENCY" ] -[ "sys", "st_geometryn", "sys", "st_patchn", "FUNC_DEPENDENCY" ] -[ "sys", "getproj4", "sys", "st_transform", "FUNC_DEPENDENCY" ] -[ "sys", "internaltransform", "sys", "st_transform", "FUNC_DEPENDENCY" ] -[ "sys", "st_srid", "sys", "st_transform", "FUNC_DEPENDENCY" ] -[ "sys", "columnsize", "sys", "storagemodel", "FUNC_DEPENDENCY" ] -[ "sys", "hashsize", "sys", "storagemodel", "FUNC_DEPENDENCY" ] -[ "sys", "heapsize", "sys", "storagemodel", "FUNC_DEPENDENCY" ] -[ "sys", "imprintsize", "sys", "storagemodel", "FUNC_DEPENDENCY" ] -#select s1.name, t.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; -% sys.s1, sys.t, sys.s2, sys.f, .dt # table_name -% name, name, name, name, name # name -% varchar, varchar, varchar, varchar, char # type -% 3, 17, 3, 35, 20 # length -[ "sys", "comments", "sys", "comment_on", "PROC_DEPENDENCY" ] -[ "sys", "columns", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "columns", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "columns", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "columns", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "columns", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "auths", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "users", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_tables_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "tables", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNC_DEPENDENCY" ] -[ "sys", "storagemodelinput", "sys", "storagemodel", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] -[ "sys", "objects", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] -[ "sys", "schemas", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] -[ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] -[ "sys", "tables", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] -#select s1.name, t.name, c.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; -% sys.s1, sys.t, sys.c, sys.s2, sys.f, .dt # table_name -% name, name, name, name, name, name # name -% varchar, varchar, varchar, varchar, varchar, char # type -% 3, 17, 13, 3, 35, 20 # length -[ "sys", "comments", "id", "sys", "comment_on", "PROC_DEPENDENCY" ] -[ "sys", "comments", "remark", "sys", "comment_on", "PROC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "func", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "language", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "mod", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "name", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "schema_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "side_effect", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "vararg", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "varres", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "action", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "nr", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "action", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "type", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "objects", "nr", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "condition", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "event", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "new_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "old_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "orientation", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "statement", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "table_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "time", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "func", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "language", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "mod", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "name", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "schema_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "side_effect", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "vararg", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "varres", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "func", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "language", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "mod", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "schema_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "side_effect", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "vararg", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "varres", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "condition", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "event", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "new_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "old_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "orientation", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "statement", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "table_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "time", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "action", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "name", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "table_id", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "type", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "auths", "grantor", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "authorization", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "system", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "authorization", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "owner", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "schemas", "system", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "action", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "name", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "rkey", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "table_id", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "type", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "func", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "language", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "mod", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "name", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "schema_id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "side_effect", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "type", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "vararg", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "functions", "varres", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "table_id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "idxs", "type", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "action", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "rkey", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "table_id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "keys", "type", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "condition", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "event", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "new_name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "old_name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] -[ "sys", "triggers", "orientation", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
