Changeset: aca7f8a4eea2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=aca7f8a4eea2
Modified Files:
sql/test/mapi/Tests/php_monetdb.stable.out
sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
Branch: Feb2013
Log Message:
Hand-approved output after 04ad0c9e2637.
diffs (24 lines):
diff --git a/sql/test/mapi/Tests/php_monetdb.stable.out
b/sql/test/mapi/Tests/php_monetdb.stable.out
--- a/sql/test/mapi/Tests/php_monetdb.stable.out
+++ b/sql/test/mapi/Tests/php_monetdb.stable.out
@@ -92,7 +92,7 @@ 5262 queryhistory 2000 0 true 0
false 0
5276 callhistory 2000 0 true 0 false 0
5293 querylog 2000 create view querylog asnselect qd.*, ql.ctime,
ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock,
ql.oublock from queryhistory qd, callhistory qlnwhere qd.id = ql.id; 1
true 0 false 0
6034 storagemodelinput 2000 0 true 0 false
0
-6075 tablestoragemodel 2000 -- A summary of the table storage
requirement is is available as a table view.n-- The auxillary column denotes
the maximum space if all non-sorted columnsn-- would be augmented with a hash
(rare situation)ncreate view tablestoragemodelnas select
"schema","table",max(count) as "count",ntsum(columnsize) as
columnsize,ntsum(heapsize) as heapsize,ntsum(indices) as indices,ntsum(case
when sorted = false then 8 * count else 0 end) as auxillarynfrom storagemodel()
group by "schema","table"; 1 true 0 false 0
+6075 tablestoragemodel 2000 -- A summary of the table storage
requirement is is available as a table view.n-- The auxillary column denotes
the maximum space if all non-sorted columnsn-- would be augmented with a hash
(rare situation)ncreate view sys.tablestoragemodelnas select
"schema","table",max(count) as "count",ntsum(columnsize) as
columnsize,ntsum(heapsize) as heapsize,ntsum(indices) as indices,ntsum(case
when sorted = false then 8 * count else 0 end) as auxillarynfrom
sys.storagemodel() group by "schema","table"; 1 true 0
false 0
6097 systemfunctions 2000 0 true 0 false 0
# 09:57:35 >
diff --git a/sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
b/sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
--- a/sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
+++ b/sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
@@ -92,7 +92,7 @@ 5262 queryhistory 2000 0 true 0
false 0
5276 callhistory 2000 0 true 0 false 0
5293 querylog 2000 create view querylog asnselect qd.*, ql.ctime,
ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock,
ql.oublock from queryhistory qd, callhistory qlnwhere qd.id = ql.id; 1
true 0 false 0
5834 storagemodelinput 2000 0 true 0 false
0
-5875 tablestoragemodel 2000 -- A summary of the table storage
requirement is is available as a table view.n-- The auxillary column denotes
the maximum space if all non-sorted columnsn-- would be augmented with a hash
(rare situation)ncreate view tablestoragemodelnas select
"schema","table",max(count) as "count",ntsum(columnsize) as
columnsize,ntsum(heapsize) as heapsize,ntsum(indices) as indices,ntsum(case
when sorted = false then 8 * count else 0 end) as auxillarynfrom storagemodel()
group by "schema","table"; 1 true 0 false 0
+5875 tablestoragemodel 2000 -- A summary of the table storage
requirement is is available as a table view.n-- The auxillary column denotes
the maximum space if all non-sorted columnsn-- would be augmented with a hash
(rare situation)ncreate view sys.tablestoragemodelnas select
"schema","table",max(count) as "count",ntsum(columnsize) as
columnsize,ntsum(heapsize) as heapsize,ntsum(indices) as indices,ntsum(case
when sorted = false then 8 * count else 0 end) as auxillarynfrom
sys.storagemodel() group by "schema","table"; 1 true 0
false 0
5897 systemfunctions 2000 0 true 0 false 0
# 09:57:35 >
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
