Changeset: 7ad22f2e4b8b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7ad22f2e4b8b
Modified Files:
sql/test/emptydb/Tests/check.stable.out
Branch: default
Log Message:
Approve non-int128 output.
diffs (12 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
@@ -536,7 +536,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "function_types", NULL, "TABLE",
true, "COMMIT", "READONLY", NULL ]
[ "sys._tables", "sys", "functions", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "geometry_columns", "create view
sys.geometry_columns as select cast(null as varchar(1)) as f_table_catalog,
s.name as f_table_schema, t.name as f_table_name, c.name as f_geometry_column,
cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer) as
coord_dimension, c.type_scale as srid, get_type(c.type_digits, 0) as
geometry_type from sys.columns c, sys.tables t, sys.schemas s where c.table_id
= t.id and t.schema_id = s.id and c.type in (select sqlname from sys.types
where systemname in ('wkb', 'wkba'));", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
-[ "sys._tables", "sys", "ids", "create view sys.ids (id, name,
schema_id, table_id, table_name, obj_type, sys_table, system) as select id,
name, cast(null as int) as schema_id, cast(null as int) as table_id, cast(null
as varchar(124)) as table_name, 'author' as obj_type, 'sys.auths' as sys_table,
(name in ('public','sysadmin','monetdb','.snapshot')) as system from sys.auths
union all select id, name, cast(null as int) as schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, ifthenelse(system, 'system
schema', 'schema'), 'sys.schemas', system from sys.schemas union all select
t.id, name, t.schema_id, t.id as table_id, t.name as table_name,
cast(lower(tt.table_type_name) as varchar(40)), 'sys.tables', t.system from
sys.tables t left outer join sys.table_types tt on t.type = tt.table_type_id
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name,
ifthenelse(t.system, 'system column', 'column'), 'sys._columns', t.system from
sys._colum
ns c join sys._tables t on c.table_id = t.id union all select c.id, c.name,
t.schema_id, c.table_id, t.name as table_name, 'column', 'tmp._columns',
t.system from tmp._columns c join tmp._tables t on c.table_id = t.id union all
select k.id, k.name, t.schema_id, k.table_id, t.name as table_name,
ifthenelse(t.system, 'system key', 'key'), 'sys.keys', t.system from sys.keys k
join sys._tables t on k.table_id = t.id union all select k.id, k.name,
t.schema_id, k.table_id, t.name as table_name, 'key', 'tmp.keys', t.system from
tmp.keys k join tmp._tables t on k.table_id = t.id union all select i.id,
i.name, t.schema_id, i.table_id, t.name as table_name, ifthenelse(t.system,
'system index', 'index'), 'sys.idxs', t.system from sys.idxs i join sys._tables
t on i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id,
t.name as table_name, 'index' , 'tmp.idxs', t.system from tmp.idxs i join
tmp._tables t on i.table_id = t.id union all select g.id, g.name, t.schema_id,
g.table_
id, t.name as table_name, ifthenelse(t.system, 'system trigger', 'trigger'),
'sys.triggers', t.system from sys.triggers g join sys._tables t on g.table_id =
t.id union all select g.id, g.name, t.schema_id, g.table_id, t.name as
table_name, 'trigger', 'tmp.triggers', t.system from tmp.triggers g join
tmp._tables t on g.table_id = t.id union all select f.id, f.name, f.schema_id,
cast(null as int) as table_id, cast(null as varchar(124)) as table_name,
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) as
varchar(40)), 'sys.functions', f.system from sys.functions f left outer join
sys.function_types ft on f.type = ft.function_type_id union all select a.id,
a.name, f.schema_id, a.func_id as table_id, f.name as table_name,
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) ||
' arg' as varchar(44)), 'sys.args', f.system from sys.args a join sys.functions
f on a.func_id = f.id left outer join sys.function_types ft on f.type =
ft.function_ty
pe_id union all select id, name, schema_id, cast(null as int) as table_id,
cast(null as varchar(124)) as table_name, 'sequence', 'sys.sequences', false
from sys.sequences union all select o.id, o.name, pt.schema_id, pt.id, pt.name,
'partition of merge table', 'sys.objects', false from sys.objects o join
sys._tables pt on o.sub = pt.id join sys._tables mt on o.nr = mt.id where
mt.type = 3 union all select id, sqlname, schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, 'type', 'sys.types',
(sqlname in ('inet','json','url','uuid')) from sys.types where id > 2000 order
by id;", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "ids", "create view sys.ids (id, name,
schema_id, table_id, table_name, obj_type, sys_table, system) as select id,
name, cast(null as int) as schema_id, cast(null as int) as table_id, cast(null
as varchar(124)) as table_name, 'author' as obj_type, 'sys.auths' as sys_table,
(name in ('public','sysadmin','monetdb','.snapshot')) as system from sys.auths
union all select id, name, cast(null as int) as schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, ifthenelse(system, 'system
schema', 'schema'), 'sys.schemas', system from sys.schemas union all select
t.id, name, t.schema_id, t.id as table_id, t.name as table_name,
cast(lower(tt.table_type_name) as varchar(40)), 'sys.tables', t.system from
sys.tables t left outer join sys.table_types tt on t.type = tt.table_type_id
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name,
ifthenelse(t.system, 'system column', 'column'), 'sys._columns', t.system from
sys._colum
ns c join sys._tables t on c.table_id = t.id union all select c.id, c.name,
t.schema_id, c.table_id, t.name as table_name, 'column', 'tmp._columns',
t.system from tmp._columns c join tmp._tables t on c.table_id = t.id union all
select k.id, k.name, t.schema_id, k.table_id, t.name as table_name,
ifthenelse(t.system, 'system key', 'key'), 'sys.keys', t.system from sys.keys k
join sys._tables t on k.table_id = t.id union all select k.id, k.name,
t.schema_id, k.table_id, t.name as table_name, 'key', 'tmp.keys', t.system from
tmp.keys k join tmp._tables t on k.table_id = t.id union all select i.id,
i.name, t.schema_id, i.table_id, t.name as table_name, ifthenelse(t.system,
'system index', 'index'), 'sys.idxs', t.system from sys.idxs i join sys._tables
t on i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id,
t.name as table_name, 'index' , 'tmp.idxs', t.system from tmp.idxs i join
tmp._tables t on i.table_id = t.id union all select g.id, g.name, t.schema_id,
g.table_
id, t.name as table_name, ifthenelse(t.system, 'system trigger', 'trigger'),
'sys.triggers', t.system from sys.triggers g join sys._tables t on g.table_id =
t.id union all select g.id, g.name, t.schema_id, g.table_id, t.name as
table_name, 'trigger', 'tmp.triggers', t.system from tmp.triggers g join
tmp._tables t on g.table_id = t.id union all select f.id, f.name, f.schema_id,
cast(null as int) as table_id, cast(null as varchar(124)) as table_name,
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) as
varchar(40)), 'sys.functions', f.system from sys.functions f left outer join
sys.function_types ft on f.type = ft.function_type_id union all select a.id,
a.name, f.schema_id, a.func_id as table_id, f.name as table_name,
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) ||
' arg' as varchar(44)), 'sys.args', f.system from sys.args a join sys.functions
f on a.func_id = f.id left outer join sys.function_types ft on f.type =
ft.function_ty
pe_id union all select id, name, schema_id, cast(null as int) as table_id,
cast(null as varchar(124)) as table_name, 'sequence', 'sys.sequences', false
from sys.sequences union all select o.id, o.name, pt.schema_id, pt.id, pt.name,
'partition of merge table', 'sys.objects', false from sys.objects o join
sys._tables pt on o.sub = pt.id join sys._tables mt on o.nr = mt.id where
mt.type = 3 union all select id, sqlname, schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, 'type', 'sys.types',
(sqlname in ('inet','json','url','uuid')) from sys.types order by id;",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "idxs", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "index_types", NULL, "TABLE", true,
"COMMIT", "READONLY", NULL ]
[ "sys._tables", "sys", "key_types", NULL, "TABLE", true,
"COMMIT", "READONLY", NULL ]
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
