Changeset: 8c8f092f2b43 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8c8f092f2b43 Modified Files: clients/Tests/SQL-dump.SQL.py clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: Jun2016 Log Message:
Add dependency type in output. diffs (truncated from 7146 to 300 lines): diff --git a/clients/Tests/SQL-dump.SQL.py b/clients/Tests/SQL-dump.SQL.py --- a/clients/Tests/SQL-dump.SQL.py +++ b/clients/Tests/SQL-dump.SQL.py @@ -81,15 +81,15 @@ select server, port, db, db_alias, user, -- 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 from sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where 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 from sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 from sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 from schemas s1, functions f1, schemas s2, _tables t2, dependencies d where 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 from schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where 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 from schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where 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 from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where 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 from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where 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 from types t, functions f, schemas s, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, functions f1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from types t, functions f, schemas s, dependencies d where 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 diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -1211,15 +1211,15 @@ select server, port, db, db_alias, user, -- 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 from sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where 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 from sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 from sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 from schemas s1, functions f1, schemas s2, _tables t2, dependencies d where 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 from schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where 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 from schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where 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 from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where 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 from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where 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 from types t, functions f, schemas s, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, functions f1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from schemas s1, _tables t1, _columns c1, schemas s2, _tables t2, dependencies d where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where 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, case d.depend_type when 1 then 'SCHEMA_DEPENDENCY' when 2 then 'TABLE_DEPENDENCY' when 3 then 'COLUMN_DEPENDENCY' when 4 then 'KEY_DEPENDENCY' when 5 then 'VIEW_DEPENDENCY' when 6 then 'USER_DEPENDENCY' when 7 then 'FUNC_DEPENDENCY' when 8 then 'TRIGGER_DEPENDENCY' when 9 then 'OWNER_DEPENDENCY' when 10 then 'INDEX_DEPENDENCY' when 11 then 'FKEY_DEPENDENCY' when 12 then 'SEQ_DEPENDENCY' when 13 then 'PROC_DEPENDENCY' when 14 then 'BEDROPPED_DEPENDENCY' when 15 then 'TYPE_DEPENDENCY' end from types t, functions f, schemas s, dependencies d where 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 @@ -7961,358 +7961,358 @@ 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 from sys.dependencies d, sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where 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 # table_name -% name, name, name, name # name -% varchar, varchar, varchar, varchar # type -% 3, 17, 3, 31 # length -[ "sys", "=", "sys", "columnsize" ] -[ "sys", "left_shift", "sys", "columnsize" ] -[ "sys", "sql_mul", "sys", "columnsize" ] -[ "sys", "pi", "sys", "degrees" ] -[ "sys", "sql_div", "sys", "degrees" ] -[ "sys", "sql_mul", "sys", "degrees" ] -[ "sys", "=", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "hash", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "rotate_xor_hash", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "=", "sys", "dependencies_columns_on_keys" ] -[ "sys", "hash", "sys", "dependencies_columns_on_keys" ] -[ "sys", "rotate_xor_hash", "sys", "dependencies_columns_on_keys" ] -[ "sys", "sql_neg", "sys", "dependencies_columns_on_keys" ] -[ "sys", "zero_or_one", "sys", "getproj4" ] -[ "sys", "=", "sys", "hashsize" ] -[ "sys", "sql_mul", "sys", "hashsize" ] -[ "sys", "<>", "sys", "heapsize" ] -[ "sys", "and", "sys", "heapsize" ] -[ "sys", "sql_add", "sys", "heapsize" ] -[ "sys", "sql_mul", "sys", "heapsize" ] -[ "sys", "=", "sys", "imprintsize" ] -[ "sys", "or", "sys", "imprintsize" ] -[ "sys", "sql_mul", "sys", "imprintsize" ] -[ "sys", "=", "sys", "ms_round" ] -[ "sys", "isnull", "sys", "ms_round" ] -[ "sys", "ms_trunc", "sys", "ms_round" ] -[ "sys", "not", "sys", "ms_round" ] -[ "sys", "or", "sys", "ms_round" ] -[ "sys", "round", "sys", "ms_round" ] -[ "sys", "<", "sys", "ms_stuff" ] -[ "sys", ">", "sys", "ms_stuff" ] -[ "sys", "concat", "sys", "ms_stuff" ] -[ "sys", "length", "sys", "ms_stuff" ] -[ "sys", "or", "sys", "ms_stuff" ] -[ "sys", "sql_add", "sys", "ms_stuff" ] -[ "sys", "sql_sub", "sys", "ms_stuff" ] -[ "sys", "substring", "sys", "ms_stuff" ] -[ "sys", "pi", "sys", "radians" ] -[ "sys", "sql_div", "sys", "radians" ] -[ "sys", "sql_mul", "sys", "radians" ] -[ "sys", "st_numgeometries", "sys", "st_numpatches" ] -[ "sys", "st_geometryn", "sys", "st_patchn" ] -[ "sys", "getproj4", "sys", "st_transform" ] -[ "sys", "internaltransform", "sys", "st_transform" ] -[ "sys", "isnull", "sys", "st_transform" ] -[ "sys", "not", "sys", "st_transform" ] -[ "sys", "or", "sys", "st_transform" ] -[ "sys", "st_srid", "sys", "st_transform" ] -[ "sys", "columnsize", "sys", "storagemodel" ] -[ "sys", "hashsize", "sys", "storagemodel" ] -[ "sys", "heapsize", "sys", "storagemodel" ] -[ "sys", "imprintsize", "sys", "storagemodel" ] -#select s1.name, t.name, s2.name, f.name from sys.dependencies d, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 # table_name -% name, name, name, name # name -% varchar, varchar, varchar, varchar # type -% 3, 17, 3, 35 # length -[ "sys", "columns", "sys", "dependencies_columns_on_functions" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_functions" ] -[ "sys", "functions", "sys", "dependencies_columns_on_functions" ] -[ "sys", "columns", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "idxs", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "keys", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "objects", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "columns", "sys", "dependencies_columns_on_keys" ] -[ "sys", "keys", "sys", "dependencies_columns_on_keys" ] -[ "sys", "objects", "sys", "dependencies_columns_on_keys" ] -[ "sys", "columns", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "triggers", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "columns", "sys", "dependencies_columns_on_views" ] -[ "sys", "dependencies", "sys", "dependencies_columns_on_views" ] -[ "sys", "tables", "sys", "dependencies_columns_on_views" ] -[ "sys", "dependencies", "sys", "dependencies_functions_on_functions" ] -[ "sys", "functions", "sys", "dependencies_functions_on_functions" ] -[ "sys", "dependencies", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "functions", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "triggers", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "keys", "sys", "dependencies_keys_on_foreignkeys" ] -[ "sys", "auths", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "schemas", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "schemas", "sys", "dependencies_schemas_on_users" ] -[ "sys", "users", "sys", "dependencies_schemas_on_users" ] -[ "sys", "keys", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "tables", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_functions" ] -[ "sys", "functions", "sys", "dependencies_tables_on_functions" ] -[ "sys", "tables", "sys", "dependencies_tables_on_functions" ] -[ "sys", "idxs", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "keys", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "tables", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "tables", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "triggers", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "dependencies", "sys", "dependencies_tables_on_views" ] -[ "sys", "tables", "sys", "dependencies_tables_on_views" ] -[ "sys", "dependencies", "sys", "dependencies_views_on_functions" ] -[ "sys", "functions", "sys", "dependencies_views_on_functions" ] -[ "sys", "tables", "sys", "dependencies_views_on_functions" ] -[ "sys", "dependencies", "sys", "dependencies_views_on_triggers" ] -[ "sys", "tables", "sys", "dependencies_views_on_triggers" ] -[ "sys", "triggers", "sys", "dependencies_views_on_triggers" ] -[ "sys", "spatial_ref_sys", "sys", "getproj4" ] -[ "sys", "storagemodelinput", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "sys", "storagemodelinit" ] -#select s1.name, t.name, c.name, s2.name, f.name from sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where 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 # table_name -% name, name, name, name, name # name -% varchar, varchar, varchar, varchar, varchar # type -% 3, 17, 11, 3, 35 # length -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_functions" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_functions" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions" ] -[ "sys", "functions", "id", "sys", "dependencies_columns_on_functions" ] -[ "sys", "functions", "name", "sys", "dependencies_columns_on_functions" ] -[ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "idxs", "name", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes" ] -[ "sys", "keys", "id", "sys", "dependencies_columns_on_keys" ] -[ "sys", "keys", "name", "sys", "dependencies_columns_on_keys" ] -[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_keys" ] -[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys" ] -[ "sys", "objects", "id", "sys", "dependencies_columns_on_keys" ] -[ "sys", "objects", "name", "sys", "dependencies_columns_on_keys" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_views" ] -[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_views" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_functions" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_on_functions" ] -[ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions" ] -[ "sys", "functions", "id", "sys", "dependencies_functions_on_functions" ] -[ "sys", "functions", "name", "sys", "dependencies_functions_on_functions" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "dependencies", "id", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "functions", "id", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "functions", "name", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "triggers", "id", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "triggers", "name", "sys", "dependencies_functions_os_triggers" ] -[ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys" ] -[ "sys", "keys", "name", "sys", "dependencies_keys_on_foreignkeys" ] -[ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys" ] -[ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas" ] -[ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users" ] -[ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users" ] -[ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "keys", "name", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "keys", "rkey", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "keys", "table_id", "sys", "dependencies_tables_on_foreignkeys" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_functions" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_functions" ] -[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_functions" ] -[ "sys", "functions", "id", "sys", "dependencies_tables_on_functions" ] -[ "sys", "functions", "name", "sys", "dependencies_tables_on_functions" ] -[ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "idxs", "table_id", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "triggers", "id", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "triggers", "name", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "triggers", "table_id", "sys", "dependencies_tables_on_triggers" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_views" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_views" ] -[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_views" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_functions" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_views_on_functions" ] -[ "sys", "dependencies", "id", "sys", "dependencies_views_on_functions" ] -[ "sys", "functions", "id", "sys", "dependencies_views_on_functions" ] -[ "sys", "functions", "name", "sys", "dependencies_views_on_functions" ] -[ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_triggers" ] -[ "sys", "dependencies", "depend_type", "sys", "dependencies_views_on_triggers" ] -[ "sys", "dependencies", "id", "sys", "dependencies_views_on_triggers" ] -[ "sys", "triggers", "id", "sys", "dependencies_views_on_triggers" ] -[ "sys", "triggers", "name", "sys", "dependencies_views_on_triggers" ] -[ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4" ] -[ "sys", "spatial_ref_sys", "srid", "sys", "getproj4" ] -[ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "column", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "count", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "distinct", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "reference", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "schema", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "sorted", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "table", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "type", "sys", "storagemodel" ] -[ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "column", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "count", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "sorted", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "table", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "type", "sys", "storagemodelinit" ] -[ "sys", "storagemodelinput", "typewidth", "sys", "storagemodelinit" ] -#select s1.name, f1.name, s2.name, t2.name from schemas s1, functions f1, schemas s2, _tables t2, dependencies d where 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; -% sys.s1, sys.f1, sys.s2, sys.t2 # table_name -% name, name, name, name # name -% varchar, varchar, varchar, varchar # type -% 3, 16, 3, 17 # length -[ "sys", "environment", "sys", "environment" ] -[ "sys", "get_type", "sys", "geometry_columns" ] -[ "sys", "has_m", "sys", "geometry_columns" ] -[ "sys", "has_z", "sys", "geometry_columns" ] -[ "sys", "sql_add", "sys", "geometry_columns" ] -[ "sys", "optimizers", "sys", "optimizers" ] -[ "sys", "querylog_calls", "sys", "querylog_calls" ] -[ "sys", "querylog_catalog", "sys", "querylog_catalog" ] -[ "sys", "querylog_calls", "sys", "querylog_history" ] -[ "sys", "querylog_catalog", "sys", "querylog_history" ] -[ "sys", "queue", "sys", "queue" ] -[ "sys", "rejects", "sys", "rejects" ] -[ "sys", "sessions", "sys", "sessions" ] -[ "sys", "storage", "sys", "storage" ] -[ "sys", "storagemodel", "sys", "storagemodel" ] -[ "sys", "=", "sys", "tablestoragemodel" ] -[ "sys", "ifthenelse", "sys", "tablestoragemodel" ] -[ "sys", "isnull", "sys", "tablestoragemodel" ] -[ "sys", "max", "sys", "tablestoragemodel" ] -[ "sys", "sql_mul", "sys", "tablestoragemodel" ] -[ "sys", "storagemodel", "sys", "tablestoragemodel" ] -[ "sys", "sum", "sys", "tablestoragemodel" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
