Changeset: 56597d75e5a3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=56597d75e5a3
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:
Dump comments table (should be empty).
diffs (179 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
@@ -105,6 +105,13 @@ out += ";"
out += '''
-- auths
select name, grantor from sys.auths;
+-- comments
+select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
-- 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
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
@@ -1234,6 +1234,13 @@ with x(name,func,schema_id) as (select n
select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, fl.language_name, ft.function_type_name, f.side_effect, f.varres,
f.vararg, a0.name as name0, a0.type as type0, a0.type_digits as type_digits0,
a0.type_scale as type_scale0, case a0.inout when 0 then 'out' when 1 then 'in'
end as inout0, a1.name as name1, a1.type as type1, a1.type_digits as
type_digits1, a1.type_scale as type_scale1, case a1.inout when 0 then 'out'
when 1 then 'in' end as inout1, a2.name as name2, a2.type as type2,
a2.type_digits as type_digits2, a2.type_scale as type_scale2, case a2.inout
when 0 then 'out' when 1 then 'in' end as inout2, a3.name as name3, a3.type as
type3, a3.type_digits as type_digits3, a3.type_scale as type_scale3, case
a3.inout when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4,
a4.type as type4, a4.type_digits as type_digits4, a4.type_scale as type_
scale4, case a4.inout when 0 then 'out' when 1 then 'in' end as inout4,
a5.name as name5, a5.type as type5, a5.type_digits as type_digits5,
a5.type_scale as type_scale5, case a5.inout when 0 then 'out' when 1 then 'in'
end as inout5, a6.name as name6, a6.type as type6, a6.type_digits as
type_digits6, a6.type_scale as type_scale6, case a6.inout when 0 then 'out'
when 1 then 'in' end as inout6, a7.name as name7, a7.type as type7,
a7.type_digits as type_digits7, a7.type_scale as type_scale7, case a7.inout
when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8, a8.type as
type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8, case
a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as name9,
a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as type_scale9,
case a9.inout when 0 then 'out' when 1 then 'in' end as inout9, a10.name as
name10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.
inout when 0 then 'out' when 1 then 'in' end as inout10, a11.name as name11,
a11.type as type11, a11.type_digits as type_digits11, a11.type_scale as
type_scale11, case a11.inout when 0 then 'out' when 1 then 'in' end as inout11,
a12.name as name12, a12.type as type12, a12.type_digits as type_digits12,
a12.type_scale as type_scale12, case a12.inout when 0 then 'out' when 1 then
'in' end as inout12, a13.name as name13, a13.type as type13, a13.type_digits as
type_digits13, a13.type_scale as type_scale13, case a13.inout when 0 then 'out'
when 1 then 'in' end as inout13, a14.name as name14, a14.type as type14,
a14.type_digits as type_digits14, a14.type_scale as type_scale14, case
a14.inout when 0 then 'out' when 1 then 'in' end as inout14, a15.name as
name15, a15.type as type15, a15.type_digits as type_digits15, a15.type_scale as
type_scale15, case a15.inout when 0 then 'out' when 1 then 'in' end as inout15
from sys.functions f left outer join sys.schemas s on f.schema_id = s.id left
out
er join sys.function_types as ft on f.type = ft.function_type_id left outer
join sys.function_languages fl on f.language = fl.language_id left outer join
sys.args a0 on a0.func_id = f.id and a0.number = 0 left outer join sys.args a1
on a1.func_id = f.id and a1.number = 1 left outer join sys.args a2 on
a2.func_id = f.id and a2.number = 2 left outer join sys.args a3 on a3.func_id =
f.id and a3.number = 3 left outer join sys.args a4 on a4.func_id = f.id and
a4.number = 4 left outer join sys.args a5 on a5.func_id = f.id and a5.number =
5 left outer join sys.args a6 on a6.func_id = f.id and a6.number = 6 left outer
join sys.args a7 on a7.func_id = f.id and a7.number = 7 left outer join
sys.args a8 on a8.func_id = f.id and a8.number = 8 left outer join sys.args a9
on a9.func_id = f.id and a9.number = 9 left outer join sys.args a10 on
a10.func_id = f.id and a10.number = 10 left outer join sys.args a11 on
a11.func_id = f.id and a11.number = 11 left outer join sys.args a12 on
a12.func_id = f
.id and a12.number = 12 left outer join sys.args a13 on a13.func_id = f.id and
a13.number = 13 left outer join sys.args a14 on a14.func_id = f.id and
a14.number = 14 left outer join sys.args a15 on a15.func_id = f.id and
a15.number = 15 order by s.name, f.name, query, name0, type0, type_digits0,
type_scale0, inout0, name1, type1, type_digits1, type_scale1, inout1, name2,
type2, type_digits2, type_scale2, inout2, name3, type3, type_digits3,
type_scale3, inout3, name4, type4, type_digits4, type_scale4, inout4, name5,
type5, type_digits5, type_scale5, inout5, name6, type6, type_digits6,
type_scale6, inout6, name7, type7, type_digits7, type_scale7, inout7, name8,
type8, type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10, inout10,
name11, type11, type_digits11, type_scale11, inout11, name12, type12,
type_digits12, type_scale12, inout12, name13, type13, type_digits13,
type_scale13, inout13, name14, type14, type_d
igits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15;
-- auths
select name, grantor from sys.auths;
+-- comments
+select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
-- 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
@@ -3367,6 +3374,36 @@ drop function pcre_replace(string, strin
[ "public", 0 ]
[ "sysadmin", 0 ]
[ "monetdb", 0 ]
+#select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+% sys.s, sys.c # table_name
+% name, remark # name
+% varchar, varchar # type
+% 0, 0 # length
+#select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+% sys.s, sys.t, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+% sys.s, sys.t, sys.col, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+% sys.s, sys.t, sys.i, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+% sys.s, sys.q, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
+% sys.s, sys.f, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
#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;
% .u, .u, .s # table_name
% name, fullname, name # name
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
@@ -1238,6 +1238,13 @@ with x(name,func,schema_id) as (select n
select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, fl.language_name, ft.function_type_name, f.side_effect, f.varres,
f.vararg, a0.name as name0, a0.type as type0, a0.type_digits as type_digits0,
a0.type_scale as type_scale0, case a0.inout when 0 then 'out' when 1 then 'in'
end as inout0, a1.name as name1, a1.type as type1, a1.type_digits as
type_digits1, a1.type_scale as type_scale1, case a1.inout when 0 then 'out'
when 1 then 'in' end as inout1, a2.name as name2, a2.type as type2,
a2.type_digits as type_digits2, a2.type_scale as type_scale2, case a2.inout
when 0 then 'out' when 1 then 'in' end as inout2, a3.name as name3, a3.type as
type3, a3.type_digits as type_digits3, a3.type_scale as type_scale3, case
a3.inout when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4,
a4.type as type4, a4.type_digits as type_digits4, a4.type_scale as type_
scale4, case a4.inout when 0 then 'out' when 1 then 'in' end as inout4,
a5.name as name5, a5.type as type5, a5.type_digits as type_digits5,
a5.type_scale as type_scale5, case a5.inout when 0 then 'out' when 1 then 'in'
end as inout5, a6.name as name6, a6.type as type6, a6.type_digits as
type_digits6, a6.type_scale as type_scale6, case a6.inout when 0 then 'out'
when 1 then 'in' end as inout6, a7.name as name7, a7.type as type7,
a7.type_digits as type_digits7, a7.type_scale as type_scale7, case a7.inout
when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8, a8.type as
type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8, case
a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as name9,
a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as type_scale9,
case a9.inout when 0 then 'out' when 1 then 'in' end as inout9, a10.name as
name10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.
inout when 0 then 'out' when 1 then 'in' end as inout10, a11.name as name11,
a11.type as type11, a11.type_digits as type_digits11, a11.type_scale as
type_scale11, case a11.inout when 0 then 'out' when 1 then 'in' end as inout11,
a12.name as name12, a12.type as type12, a12.type_digits as type_digits12,
a12.type_scale as type_scale12, case a12.inout when 0 then 'out' when 1 then
'in' end as inout12, a13.name as name13, a13.type as type13, a13.type_digits as
type_digits13, a13.type_scale as type_scale13, case a13.inout when 0 then 'out'
when 1 then 'in' end as inout13, a14.name as name14, a14.type as type14,
a14.type_digits as type_digits14, a14.type_scale as type_scale14, case
a14.inout when 0 then 'out' when 1 then 'in' end as inout14, a15.name as
name15, a15.type as type15, a15.type_digits as type_digits15, a15.type_scale as
type_scale15, case a15.inout when 0 then 'out' when 1 then 'in' end as inout15
from sys.functions f left outer join sys.schemas s on f.schema_id = s.id left
out
er join sys.function_types as ft on f.type = ft.function_type_id left outer
join sys.function_languages fl on f.language = fl.language_id left outer join
sys.args a0 on a0.func_id = f.id and a0.number = 0 left outer join sys.args a1
on a1.func_id = f.id and a1.number = 1 left outer join sys.args a2 on
a2.func_id = f.id and a2.number = 2 left outer join sys.args a3 on a3.func_id =
f.id and a3.number = 3 left outer join sys.args a4 on a4.func_id = f.id and
a4.number = 4 left outer join sys.args a5 on a5.func_id = f.id and a5.number =
5 left outer join sys.args a6 on a6.func_id = f.id and a6.number = 6 left outer
join sys.args a7 on a7.func_id = f.id and a7.number = 7 left outer join
sys.args a8 on a8.func_id = f.id and a8.number = 8 left outer join sys.args a9
on a9.func_id = f.id and a9.number = 9 left outer join sys.args a10 on
a10.func_id = f.id and a10.number = 10 left outer join sys.args a11 on
a11.func_id = f.id and a11.number = 11 left outer join sys.args a12 on
a12.func_id = f
.id and a12.number = 12 left outer join sys.args a13 on a13.func_id = f.id and
a13.number = 13 left outer join sys.args a14 on a14.func_id = f.id and
a14.number = 14 left outer join sys.args a15 on a15.func_id = f.id and
a15.number = 15 order by s.name, f.name, query, name0, type0, type_digits0,
type_scale0, inout0, name1, type1, type_digits1, type_scale1, inout1, name2,
type2, type_digits2, type_scale2, inout2, name3, type3, type_digits3,
type_scale3, inout3, name4, type4, type_digits4, type_scale4, inout4, name5,
type5, type_digits5, type_scale5, inout5, name6, type6, type_digits6,
type_scale6, inout6, name7, type7, type_digits7, type_scale7, inout7, name8,
type8, type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10, inout10,
name11, type11, type_digits11, type_scale11, inout11, name12, type12,
type_digits12, type_scale12, inout12, name13, type13, type_digits13,
type_scale13, inout13, name14, type14, type_d
igits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15;
-- auths
select name, grantor from sys.auths;
+-- comments
+select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
-- 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
@@ -3371,6 +3378,36 @@ drop function pcre_replace(string, strin
[ "public", 0 ]
[ "sysadmin", 0 ]
[ "monetdb", 0 ]
+#select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+% sys.s, sys.c # table_name
+% name, remark # name
+% varchar, varchar # type
+% 0, 0 # length
+#select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+% sys.s, sys.t, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+% sys.s, sys.t, sys.col, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+% sys.s, sys.t, sys.i, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+% sys.s, sys.q, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
+% sys.s, sys.f, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
#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;
% .u, .u, .s # table_name
% name, fullname, name # name
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
@@ -1248,6 +1248,13 @@ with x(name,func,schema_id) as (select n
select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, fl.language_name, ft.function_type_name, f.side_effect, f.varres,
f.vararg, a0.name as name0, a0.type as type0, a0.type_digits as type_digits0,
a0.type_scale as type_scale0, case a0.inout when 0 then 'out' when 1 then 'in'
end as inout0, a1.name as name1, a1.type as type1, a1.type_digits as
type_digits1, a1.type_scale as type_scale1, case a1.inout when 0 then 'out'
when 1 then 'in' end as inout1, a2.name as name2, a2.type as type2,
a2.type_digits as type_digits2, a2.type_scale as type_scale2, case a2.inout
when 0 then 'out' when 1 then 'in' end as inout2, a3.name as name3, a3.type as
type3, a3.type_digits as type_digits3, a3.type_scale as type_scale3, case
a3.inout when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4,
a4.type as type4, a4.type_digits as type_digits4, a4.type_scale as type_
scale4, case a4.inout when 0 then 'out' when 1 then 'in' end as inout4,
a5.name as name5, a5.type as type5, a5.type_digits as type_digits5,
a5.type_scale as type_scale5, case a5.inout when 0 then 'out' when 1 then 'in'
end as inout5, a6.name as name6, a6.type as type6, a6.type_digits as
type_digits6, a6.type_scale as type_scale6, case a6.inout when 0 then 'out'
when 1 then 'in' end as inout6, a7.name as name7, a7.type as type7,
a7.type_digits as type_digits7, a7.type_scale as type_scale7, case a7.inout
when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8, a8.type as
type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8, case
a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as name9,
a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as type_scale9,
case a9.inout when 0 then 'out' when 1 then 'in' end as inout9, a10.name as
name10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.
inout when 0 then 'out' when 1 then 'in' end as inout10, a11.name as name11,
a11.type as type11, a11.type_digits as type_digits11, a11.type_scale as
type_scale11, case a11.inout when 0 then 'out' when 1 then 'in' end as inout11,
a12.name as name12, a12.type as type12, a12.type_digits as type_digits12,
a12.type_scale as type_scale12, case a12.inout when 0 then 'out' when 1 then
'in' end as inout12, a13.name as name13, a13.type as type13, a13.type_digits as
type_digits13, a13.type_scale as type_scale13, case a13.inout when 0 then 'out'
when 1 then 'in' end as inout13, a14.name as name14, a14.type as type14,
a14.type_digits as type_digits14, a14.type_scale as type_scale14, case
a14.inout when 0 then 'out' when 1 then 'in' end as inout14, a15.name as
name15, a15.type as type15, a15.type_digits as type_digits15, a15.type_scale as
type_scale15, case a15.inout when 0 then 'out' when 1 then 'in' end as inout15
from sys.functions f left outer join sys.schemas s on f.schema_id = s.id left
out
er join sys.function_types as ft on f.type = ft.function_type_id left outer
join sys.function_languages fl on f.language = fl.language_id left outer join
sys.args a0 on a0.func_id = f.id and a0.number = 0 left outer join sys.args a1
on a1.func_id = f.id and a1.number = 1 left outer join sys.args a2 on
a2.func_id = f.id and a2.number = 2 left outer join sys.args a3 on a3.func_id =
f.id and a3.number = 3 left outer join sys.args a4 on a4.func_id = f.id and
a4.number = 4 left outer join sys.args a5 on a5.func_id = f.id and a5.number =
5 left outer join sys.args a6 on a6.func_id = f.id and a6.number = 6 left outer
join sys.args a7 on a7.func_id = f.id and a7.number = 7 left outer join
sys.args a8 on a8.func_id = f.id and a8.number = 8 left outer join sys.args a9
on a9.func_id = f.id and a9.number = 9 left outer join sys.args a10 on
a10.func_id = f.id and a10.number = 10 left outer join sys.args a11 on
a11.func_id = f.id and a11.number = 11 left outer join sys.args a12 on
a12.func_id = f
.id and a12.number = 12 left outer join sys.args a13 on a13.func_id = f.id and
a13.number = 13 left outer join sys.args a14 on a14.func_id = f.id and
a14.number = 14 left outer join sys.args a15 on a15.func_id = f.id and
a15.number = 15 order by s.name, f.name, query, name0, type0, type_digits0,
type_scale0, inout0, name1, type1, type_digits1, type_scale1, inout1, name2,
type2, type_digits2, type_scale2, inout2, name3, type3, type_digits3,
type_scale3, inout3, name4, type4, type_digits4, type_scale4, inout4, name5,
type5, type_digits5, type_scale5, inout5, name6, type6, type_digits6,
type_scale6, inout6, name7, type7, type_digits7, type_scale7, inout7, name8,
type8, type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10, inout10,
name11, type11, type_digits11, type_scale11, inout11, name12, type12,
type_digits12, type_scale12, inout12, name13, type13, type_digits13,
type_scale13, inout13, name14, type14, type_d
igits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15;
-- auths
select name, grantor from sys.auths;
+-- comments
+select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
-- 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
@@ -3572,6 +3579,36 @@ drop function pcre_replace(string, strin
[ "public", 0 ]
[ "sysadmin", 0 ]
[ "monetdb", 0 ]
+#select s.name, c.remark from sys.comments c, sys.schemas s where s.id = c.id
order by s.name;
+% sys.s, sys.c # table_name
+% name, remark # name
+% varchar, varchar # type
+% 0, 0 # length
+#select s.name, t.name, c.remark from sys.schemas s, sys._tables t,
sys.comments c where s.id = t.schema_id and t.id = c.id order by s.name, t.name;
+% sys.s, sys.t, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, t.name, col.name, c.remark from sys.schemas s, sys._tables t,
sys._columns col, sys.comments c where s.id = t.schema_id and t.id =
col.table_id and col.id = c.id order by s.name, t.name, col.name;
+% sys.s, sys.t, sys.col, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, t.name, i.name, c.remark from sys.schemas s, sys._tables t,
sys.idxs i, sys.comments c where s.id = t.schema_id and t.id = i.table_id and
i.id = c.id order by s.name, t.name, i.name;
+% sys.s, sys.t, sys.i, sys.c # table_name
+% name, name, name, remark # name
+% varchar, varchar, varchar, varchar # type
+% 0, 0, 0, 0 # length
+#select s.name, q.name, c.remark from sys.schemas s, sys.sequences q,
sys.comments c where s.id = q.schema_id and q.id = c.id order by s.name, q.name;
+% sys.s, sys.q, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
+#select s.name, f.name, c.remark from sys.schemas s, sys.functions f,
sys.comments c where s.id = f.schema_id and f.id = c.id order by s.name, f.name;
+% sys.s, sys.f, sys.c # table_name
+% name, name, remark # name
+% varchar, varchar, varchar # type
+% 0, 0, 0 # length
#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;
% .u, .u, .s # table_name
% name, fullname, name # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
