Changeset: 5cee53421971 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5cee53421971
Modified Files:
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:
Apporove new view describe_accessible_tables.
diffs (225 lines):
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
@@ -480,6 +480,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "dependency_views_on_functions", "create
view sys.dependency_views_on_functions as select v.schema_id as view_schema_id,
v.id as view_id, v.name as view_name, f.id as function_id, f.name as
function_name, f.type as function_type, dep.depend_type as depend_type from
sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id =
dep.id and f.id = dep.depend_id and dep.depend_type = 7 and f.type <> 2 and
v.type in (1, 11) order by v.name, v.schema_id, f.name, f.id;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_procedures", "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;",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_views", "create view
sys.dependency_views_on_views as select v1.schema_id as view1_schema_id, v1.id
as view1_id, v1.name as view1_name, v2.schema_id as view2_schema_id, v2.id as
view2_id, v2.name as view2_name, dep.depend_type as depend_type from sys.tables
as v1, sys.tables as v2, sys.dependencies as dep where v1.id = dep.id and v2.id
= dep.depend_id and dep.depend_type = 5 and v1.type in (1, 11) and v2.type in
(1, 11) order by v1.schema_id, v1.name, v2.schema_id, v2.name;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "describe_accessible_tables", "create view
sys.describe_accessible_tables as select schemas.name as schema, tables.name as
table, table_types.table_type_name as table_type,
privilege_codes.privilege_code_name as privs, privileges.privileges as
privs_code from privileges join sys.roles on privileges.auth_id = roles.id join
sys.tables on privileges.obj_id = tables.id join sys.table_types on tables.type
= table_types.table_type_id join sys.schemas on tables.schema_id = schemas.id
join sys.privilege_codes on privileges.privileges =
privilege_codes.privilege_code_id where roles.name = current_role;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_column_defaults", "create view
sys.describe_column_defaults as select s.name sch, t.name tbl, c.name col,
c.\"default\" def from sys.schemas s, sys.tables t, sys.columns c where s.id =
t.schema_id and t.id = c.table_id and s.name <> 'tmp' and not t.system and
c.\"default\" is not null;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "describe_comments", "create view
sys.describe_comments as select o.id id, o.tpe tpe, o.nme fqn, c.remark rem
from (select id, 'SCHEMA', sys.dq(name) from sys.schemas union all select t.id,
ifthenelse(ts.table_type_name = 'VIEW', 'VIEW', 'TABLE'), sys.fqn(s.name,
t.name) from sys.schemas s join sys.tables t on s.id = t.schema_id join
sys.table_types ts on t.type = ts.table_type_id where s.name <> 'tmp' union all
select c.id, 'COLUMN', sys.fqn(s.name, t.name) || '.' || sys.dq(c.name) from
sys.columns c, sys.tables t, sys.schemas s where c.table_id = t.id and
t.schema_id = s.id union all select idx.id, 'INDEX', sys.fqn(s.name, idx.name)
from sys.idxs idx, sys._tables t, sys.schemas s where idx.table_id = t.id and
t.schema_id = s.id union all select seq.id, 'SEQUENCE', sys.fqn(s.name,
seq.name) from sys.sequences seq, sys.schemas s where seq.schema_id = s.id
union all select f.id, ft.function_type_keyword, qf.nme from sys.functions f,
sys.function_types ft, sys.
schemas s, sys.fully_qualified_functions qf where f.type = ft.function_type_id
and f.schema_id = s.id and qf.id = f.id) as o(id, tpe, nme) join sys.comments c
on c.id = o.id;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "sys", "describe_constraints", "create view
sys.describe_constraints as select s.name sch, t.name tbl, kc.name col, k.name
con, case k.type when 0 then 'PRIMARY KEY' when 1 then 'UNIQUE' end tpe from
sys.schemas s, sys._tables t, sys.objects kc, sys.keys k where kc.id = k.id and
k.table_id = t.id and s.id = t.schema_id and t.system = false and k.type in (0,
1);", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
@@ -845,6 +846,11 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "dependency_views_on_views", "view2_id", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "view2_name",
"varchar", 1024, 0, NULL, true, 5, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "depend_type",
"smallint", 16, 0, NULL, true, 6, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "schema",
"varchar", 1024, 0, NULL, true, 0, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table",
"varchar", 1024, 0, NULL, true, 1, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table_type",
"varchar", 25, 0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs",
"varchar", 40, 0, NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs_code", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "sch", "varchar",
1024, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "tbl", "varchar",
1024, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "col", "varchar",
1024, 0, NULL, true, 2, NULL, NULL ]
@@ -3015,6 +3021,12 @@ select 'null in fkeys.delete_action', de
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_procedures", "VIEW" ]
[ "table used by view", "sys", "dependencies", "sys",
"dependency_views_on_views", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "table used by view", "sys", "privilege_codes", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "roles", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "schemas", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "table_types", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "tables", "sys",
"describe_accessible_tables", "VIEW" ]
[ "table used by view", "sys", "columns", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "schemas", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"describe_column_defaults", "VIEW" ]
@@ -3413,6 +3425,21 @@ select 'null in fkeys.delete_action', de
[ "column used by view", "sys", "tables", "name", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "schema_id", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "type", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_id", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_name", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "auth_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "obj_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_id",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_name",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "schema_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "type", "sys",
"describe_accessible_tables", "VIEW" ]
[ "column used by view", "sys", "columns", "default", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "name", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "table_id", "sys",
"describe_column_defaults", "VIEW" ]
@@ -4144,6 +4171,7 @@ select 'null in fkeys.delete_action', de
[ "grant on table", "dependency_views_on_functions", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_procedures", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_views", "public",
"SELECT", "monetdb", 0 ]
+[ "grant on table", "describe_accessible_tables", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_column_defaults", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_comments", "public", "SELECT",
"monetdb", 0 ]
[ "grant on table", "describe_constraints", "public", "SELECT",
"monetdb", 0 ]
@@ -4982,7 +5010,7 @@ select 'null in fkeys.delete_action', de
% .%1, .function_languages, .function_languages # table_name
% %1, language_name, language_keyword # name
% char, varchar, varchar # type
-% 22, 14, 11 # length
+% 22, 10, 7 # length
[ "sys.function_languages", "Internal C", NULL ]
[ "sys.function_languages", "MAL", NULL ]
[ "sys.function_languages", "SQL", NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -480,6 +480,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "dependency_views_on_functions", "create
view sys.dependency_views_on_functions as select v.schema_id as view_schema_id,
v.id as view_id, v.name as view_name, f.id as function_id, f.name as
function_name, f.type as function_type, dep.depend_type as depend_type from
sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id =
dep.id and f.id = dep.depend_id and dep.depend_type = 7 and f.type <> 2 and
v.type in (1, 11) order by v.name, v.schema_id, f.name, f.id;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_procedures", "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;",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_views", "create view
sys.dependency_views_on_views as select v1.schema_id as view1_schema_id, v1.id
as view1_id, v1.name as view1_name, v2.schema_id as view2_schema_id, v2.id as
view2_id, v2.name as view2_name, dep.depend_type as depend_type from sys.tables
as v1, sys.tables as v2, sys.dependencies as dep where v1.id = dep.id and v2.id
= dep.depend_id and dep.depend_type = 5 and v1.type in (1, 11) and v2.type in
(1, 11) order by v1.schema_id, v1.name, v2.schema_id, v2.name;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "describe_accessible_tables", "create view
sys.describe_accessible_tables as select schemas.name as schema, tables.name as
table, table_types.table_type_name as table_type,
privilege_codes.privilege_code_name as privs, privileges.privileges as
privs_code from privileges join sys.roles on privileges.auth_id = roles.id join
sys.tables on privileges.obj_id = tables.id join sys.table_types on tables.type
= table_types.table_type_id join sys.schemas on tables.schema_id = schemas.id
join sys.privilege_codes on privileges.privileges =
privilege_codes.privilege_code_id where roles.name = current_role;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_column_defaults", "create view
sys.describe_column_defaults as select s.name sch, t.name tbl, c.name col,
c.\"default\" def from sys.schemas s, sys.tables t, sys.columns c where s.id =
t.schema_id and t.id = c.table_id and s.name <> 'tmp' and not t.system and
c.\"default\" is not null;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "describe_comments", "create view
sys.describe_comments as select o.id id, o.tpe tpe, o.nme fqn, c.remark rem
from (select id, 'SCHEMA', sys.dq(name) from sys.schemas union all select t.id,
ifthenelse(ts.table_type_name = 'VIEW', 'VIEW', 'TABLE'), sys.fqn(s.name,
t.name) from sys.schemas s join sys.tables t on s.id = t.schema_id join
sys.table_types ts on t.type = ts.table_type_id where s.name <> 'tmp' union all
select c.id, 'COLUMN', sys.fqn(s.name, t.name) || '.' || sys.dq(c.name) from
sys.columns c, sys.tables t, sys.schemas s where c.table_id = t.id and
t.schema_id = s.id union all select idx.id, 'INDEX', sys.fqn(s.name, idx.name)
from sys.idxs idx, sys._tables t, sys.schemas s where idx.table_id = t.id and
t.schema_id = s.id union all select seq.id, 'SEQUENCE', sys.fqn(s.name,
seq.name) from sys.sequences seq, sys.schemas s where seq.schema_id = s.id
union all select f.id, ft.function_type_keyword, qf.nme from sys.functions f,
sys.function_types ft, sys.
schemas s, sys.fully_qualified_functions qf where f.type = ft.function_type_id
and f.schema_id = s.id and qf.id = f.id) as o(id, tpe, nme) join sys.comments c
on c.id = o.id;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "sys", "describe_constraints", "create view
sys.describe_constraints as select s.name sch, t.name tbl, kc.name col, k.name
con, case k.type when 0 then 'PRIMARY KEY' when 1 then 'UNIQUE' end tpe from
sys.schemas s, sys._tables t, sys.objects kc, sys.keys k where kc.id = k.id and
k.table_id = t.id and s.id = t.schema_id and t.system = false and k.type in (0,
1);", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
@@ -845,6 +846,11 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "dependency_views_on_views", "view2_id", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "view2_name",
"varchar", 1024, 0, NULL, true, 5, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "depend_type",
"smallint", 16, 0, NULL, true, 6, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "schema",
"varchar", 1024, 0, NULL, true, 0, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table",
"varchar", 1024, 0, NULL, true, 1, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table_type",
"varchar", 25, 0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs",
"varchar", 40, 0, NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs_code", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "sch", "varchar",
1024, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "tbl", "varchar",
1024, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "col", "varchar",
1024, 0, NULL, true, 2, NULL, NULL ]
@@ -3015,6 +3021,12 @@ select 'null in fkeys.delete_action', de
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_procedures", "VIEW" ]
[ "table used by view", "sys", "dependencies", "sys",
"dependency_views_on_views", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "table used by view", "sys", "privilege_codes", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "roles", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "schemas", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "table_types", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "tables", "sys",
"describe_accessible_tables", "VIEW" ]
[ "table used by view", "sys", "columns", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "schemas", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"describe_column_defaults", "VIEW" ]
@@ -3413,6 +3425,21 @@ select 'null in fkeys.delete_action', de
[ "column used by view", "sys", "tables", "name", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "schema_id", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "type", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_id", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_name", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "auth_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "obj_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_id",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_name",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "schema_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "type", "sys",
"describe_accessible_tables", "VIEW" ]
[ "column used by view", "sys", "columns", "default", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "name", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "table_id", "sys",
"describe_column_defaults", "VIEW" ]
@@ -4144,6 +4171,7 @@ select 'null in fkeys.delete_action', de
[ "grant on table", "dependency_views_on_functions", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_procedures", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_views", "public",
"SELECT", "monetdb", 0 ]
+[ "grant on table", "describe_accessible_tables", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_column_defaults", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_comments", "public", "SELECT",
"monetdb", 0 ]
[ "grant on table", "describe_constraints", "public", "SELECT",
"monetdb", 0 ]
@@ -4982,7 +5010,7 @@ select 'null in fkeys.delete_action', de
% .%1, .function_languages, .function_languages # table_name
% %1, language_name, language_keyword # name
% char, varchar, varchar # type
-% 22, 14, 11 # length
+% 22, 10, 7 # length
[ "sys.function_languages", "Internal C", NULL ]
[ "sys.function_languages", "MAL", NULL ]
[ "sys.function_languages", "SQL", NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -480,6 +480,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "dependency_views_on_functions", "create
view sys.dependency_views_on_functions as select v.schema_id as view_schema_id,
v.id as view_id, v.name as view_name, f.id as function_id, f.name as
function_name, f.type as function_type, dep.depend_type as depend_type from
sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id =
dep.id and f.id = dep.depend_id and dep.depend_type = 7 and f.type <> 2 and
v.type in (1, 11) order by v.name, v.schema_id, f.name, f.id;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_procedures", "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;",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dependency_views_on_views", "create view
sys.dependency_views_on_views as select v1.schema_id as view1_schema_id, v1.id
as view1_id, v1.name as view1_name, v2.schema_id as view2_schema_id, v2.id as
view2_id, v2.name as view2_name, dep.depend_type as depend_type from sys.tables
as v1, sys.tables as v2, sys.dependencies as dep where v1.id = dep.id and v2.id
= dep.depend_id and dep.depend_type = 5 and v1.type in (1, 11) and v2.type in
(1, 11) order by v1.schema_id, v1.name, v2.schema_id, v2.name;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "describe_accessible_tables", "create view
sys.describe_accessible_tables as select schemas.name as schema, tables.name as
table, table_types.table_type_name as table_type,
privilege_codes.privilege_code_name as privs, privileges.privileges as
privs_code from privileges join sys.roles on privileges.auth_id = roles.id join
sys.tables on privileges.obj_id = tables.id join sys.table_types on tables.type
= table_types.table_type_id join sys.schemas on tables.schema_id = schemas.id
join sys.privilege_codes on privileges.privileges =
privilege_codes.privilege_code_id where roles.name = current_role;", "VIEW",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_column_defaults", "create view
sys.describe_column_defaults as select s.name sch, t.name tbl, c.name col,
c.\"default\" def from sys.schemas s, sys.tables t, sys.columns c where s.id =
t.schema_id and t.id = c.table_id and s.name <> 'tmp' and not t.system and
c.\"default\" is not null;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "describe_comments", "create view
sys.describe_comments as select o.id id, o.tpe tpe, o.nme fqn, c.remark rem
from (select id, 'SCHEMA', sys.dq(name) from sys.schemas union all select t.id,
ifthenelse(ts.table_type_name = 'VIEW', 'VIEW', 'TABLE'), sys.fqn(s.name,
t.name) from sys.schemas s join sys.tables t on s.id = t.schema_id join
sys.table_types ts on t.type = ts.table_type_id where s.name <> 'tmp' union all
select c.id, 'COLUMN', sys.fqn(s.name, t.name) || '.' || sys.dq(c.name) from
sys.columns c, sys.tables t, sys.schemas s where c.table_id = t.id and
t.schema_id = s.id union all select idx.id, 'INDEX', sys.fqn(s.name, idx.name)
from sys.idxs idx, sys._tables t, sys.schemas s where idx.table_id = t.id and
t.schema_id = s.id union all select seq.id, 'SEQUENCE', sys.fqn(s.name,
seq.name) from sys.sequences seq, sys.schemas s where seq.schema_id = s.id
union all select f.id, ft.function_type_keyword, qf.nme from sys.functions f,
sys.function_types ft, sys.
schemas s, sys.fully_qualified_functions qf where f.type = ft.function_type_id
and f.schema_id = s.id and qf.id = f.id) as o(id, tpe, nme) join sys.comments c
on c.id = o.id;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "sys", "describe_constraints", "create view
sys.describe_constraints as select s.name sch, t.name tbl, kc.name col, k.name
con, case k.type when 0 then 'PRIMARY KEY' when 1 then 'UNIQUE' end tpe from
sys.schemas s, sys._tables t, sys.objects kc, sys.keys k where kc.id = k.id and
k.table_id = t.id and s.id = t.schema_id and t.system = false and k.type in (0,
1);", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
@@ -845,6 +846,11 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "dependency_views_on_views", "view2_id", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "view2_name",
"varchar", 1024, 0, NULL, true, 5, NULL, NULL ]
[ "sys._columns", "dependency_views_on_views", "depend_type",
"smallint", 16, 0, NULL, true, 6, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "schema",
"varchar", 1024, 0, NULL, true, 0, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table",
"varchar", 1024, 0, NULL, true, 1, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "table_type",
"varchar", 25, 0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs",
"varchar", 40, 0, NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "describe_accessible_tables", "privs_code", "int",
32, 0, NULL, true, 4, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "sch", "varchar",
1024, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "tbl", "varchar",
1024, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "describe_column_defaults", "col", "varchar",
1024, 0, NULL, true, 2, NULL, NULL ]
@@ -3126,6 +3132,12 @@ select 'null in fkeys.delete_action', de
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_procedures", "VIEW" ]
[ "table used by view", "sys", "dependencies", "sys",
"dependency_views_on_views", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "table used by view", "sys", "privilege_codes", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "roles", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "schemas", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "table_types", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "table used by view", "sys", "tables", "sys",
"describe_accessible_tables", "VIEW" ]
[ "table used by view", "sys", "columns", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "schemas", "sys",
"describe_column_defaults", "VIEW" ]
[ "table used by view", "sys", "tables", "sys",
"describe_column_defaults", "VIEW" ]
@@ -3524,6 +3536,21 @@ select 'null in fkeys.delete_action', de
[ "column used by view", "sys", "tables", "name", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "schema_id", "sys",
"dependency_views_on_views", "VIEW" ]
[ "column used by view", "sys", "tables", "type", "sys",
"dependency_views_on_views", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_id", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privilege_codes",
"privilege_code_name", "sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "auth_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "obj_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "privileges", "privileges", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "roles", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "schemas", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_id",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "table_types", "table_type_name",
"sys", "describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "name", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "schema_id", "sys",
"describe_accessible_tables", "VIEW" ]
+[ "column used by view", "sys", "tables", "type", "sys",
"describe_accessible_tables", "VIEW" ]
[ "column used by view", "sys", "columns", "default", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "name", "sys",
"describe_column_defaults", "VIEW" ]
[ "column used by view", "sys", "columns", "table_id", "sys",
"describe_column_defaults", "VIEW" ]
@@ -4256,6 +4283,7 @@ select 'null in fkeys.delete_action', de
[ "grant on table", "dependency_views_on_functions", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_procedures", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "dependency_views_on_views", "public",
"SELECT", "monetdb", 0 ]
+[ "grant on table", "describe_accessible_tables", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_column_defaults", "public",
"SELECT", "monetdb", 0 ]
[ "grant on table", "describe_comments", "public", "SELECT",
"monetdb", 0 ]
[ "grant on table", "describe_constraints", "public", "SELECT",
"monetdb", 0 ]
@@ -5115,7 +5143,7 @@ select 'null in fkeys.delete_action', de
% .%1, .function_languages, .function_languages # table_name
% %1, language_name, language_keyword # name
% char, varchar, varchar # type
-% 22, 14, 11 # length
+% 22, 10, 7 # length
[ "sys.function_languages", "Internal C", NULL ]
[ "sys.function_languages", "MAL", NULL ]
[ "sys.function_languages", "SQL", NULL ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
