Update of /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16754/Tests
Modified Files:
01-22.stable.out 07.stable.out 19.stable.out
Log Message:
we expect less joinidx usage now that we use or instead of union
U 01-22.stable.out
Index: 01-22.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/01-22.stable.out,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- 01-22.stable.out 28 Feb 2009 13:00:40 -0000 1.19
+++ 01-22.stable.out 14 Mar 2009 14:48:00 -0000 1.20
@@ -142,7 +142,7 @@
# 11:48:05 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
# 11:48:05 >
-% .shipping, .shipping, .shipping, .shipping # table_name
+% sys.shipping, sys.shipping, sys.shipping, sys.shipping #
table_name
% supp_nation, cust_nation, l_year, revenue # name
% varchar, varchar, int, decimal # type
% 7, 7, 4, 21 # length
@@ -153,8 +153,8 @@
% .stats, .stats # table_name
% rewrite, count # name
% clob, int # type
-% 7, 2 # length
-[ "joinidx", 10 ]
+% 7, 1 # length
+[ "joinidx", 5 ]
# 11:48:06 >
# 11:48:06 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
@@ -1204,7 +1204,7 @@
# 11:48:06 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
# 11:48:06 >
-% . # table_name
+% sys. # table_name
% revenue # name
% decimal # type
% 21 # length
@@ -1213,7 +1213,7 @@
% rewrite, count # name
% clob, int # type
% 7, 1 # length
-[ "joinidx", 3 ]
+[ "joinidx", 1 ]
# 11:48:06 >
# 11:48:06 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
U 07.stable.out
Index: 07.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/07.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- 07.stable.out 30 Dec 2008 19:19:05 -0000 1.10
+++ 07.stable.out 14 Mar 2009 14:48:00 -0000 1.11
@@ -25,7 +25,7 @@
# 11:47:57 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < 07.sql
# 11:47:57 >
-% .shipping, .shipping, .shipping, .shipping # table_name
+% sys.shipping, sys.shipping, sys.shipping, sys.shipping #
table_name
% supp_nation, cust_nation, l_year, revenue # name
% varchar, varchar, int, decimal # type
% 7, 7, 4, 21 # length
@@ -36,8 +36,8 @@
% .stats, .stats # table_name
% rewrite, count # name
% clob, int # type
-% 7, 2 # length
-[ "joinidx", 10 ]
+% 7, 1 # length
+[ "joinidx", 5 ]
# 09:17:14 >
# 09:17:14 > Done.
U 19.stable.out
Index: 19.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/19.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- 19.stable.out 30 Dec 2008 19:19:06 -0000 1.10
+++ 19.stable.out 14 Mar 2009 14:48:00 -0000 1.11
@@ -25,7 +25,7 @@
# 11:48:04 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < 19.sql
# 11:48:04 >
-% . # table_name
+% sys. # table_name
% revenue # name
% decimal # type
% 21 # length
@@ -34,7 +34,7 @@
% rewrite, count # name
% clob, int # type
% 7, 1 # length
-[ "joinidx", 3 ]
+[ "joinidx", 1 ]
# 09:17:20 >
# 09:17:20 > Done.
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
