Changeset: 701464c6121b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=701464c6121b
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:
Reapprove.
diffs (36 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
@@ -1270,7 +1270,7 @@ select name, authorization, owner, syste
select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
--- partitioned tables
+-- partitioned tables (these three should be empty)
select t.name, c.name, p.expression from sys.table_partitions p left outer
join sys._tables t on p.table_id = t.id left outer join sys._columns c on
p.column_id = c.id;
select t.name, p.expression, r.minimum, r.maximum, r.with_nulls from
sys.range_partitions r left outer join sys._tables t on t.id = r.table_id left
outer join sys.table_partitions p on r.partition_id = p.id;
select t.name, p.expression, v.value from sys.value_partitions v left outer
join sys._tables t on t.id = v.table_id left outer join sys.table_partitions p
on v.partition_id = p.id;
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
@@ -1270,7 +1270,7 @@ select name, authorization, owner, syste
select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
--- partitioned tables
+-- partitioned tables (these three should be empty)
select t.name, c.name, p.expression from sys.table_partitions p left outer
join sys._tables t on p.table_id = t.id left outer join sys._columns c on
p.column_id = c.id;
select t.name, p.expression, r.minimum, r.maximum, r.with_nulls from
sys.range_partitions r left outer join sys._tables t on t.id = r.table_id left
outer join sys.table_partitions p on r.partition_id = p.id;
select t.name, p.expression, v.value from sys.value_partitions v left outer
join sys._tables t on t.id = v.table_id left outer join sys.table_partitions p
on v.partition_id = p.id;
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
@@ -1280,7 +1280,7 @@ select name, authorization, owner, syste
select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
--- partitioned tables
+-- partitioned tables (these three should be empty)
select t.name, c.name, p.expression from sys.table_partitions p left outer
join sys._tables t on p.table_id = t.id left outer join sys._columns c on
p.column_id = c.id;
select t.name, p.expression, r.minimum, r.maximum, r.with_nulls from
sys.range_partitions r left outer join sys._tables t on t.id = r.table_id left
outer join sys.table_partitions p on r.partition_id = p.id;
select t.name, p.expression, v.value from sys.value_partitions v left outer
join sys._tables t on t.id = v.table_id left outer join sys.table_partitions p
on v.partition_id = p.id;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
