Update of /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4764/src/benchmarks/tpch/Tests
Modified Files:
01-22.stable.out 01.stable.out 17.stable.out
Log Message:
For avg we now always first change to doubles.
With this we can now rewrite all 'avg's into sum/cnt.
approved slight rounding changes
approved output after changes on the optimizers
approved tests which changed because of number of default functions changed
U 17.stable.out
Index: 17.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/17.stable.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- 17.stable.out 8 Dec 2008 22:44:35 -0000 1.11
+++ 17.stable.out 4 Jun 2009 20:27:54 -0000 1.12
@@ -27,7 +27,7 @@
% sys. # table_name
% avg_yearly # name
% decimal # type
-% 19 # length
+% 20 # length
[ NULL ]
% .stats, .stats # table_name
% rewrite, count # name
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.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- 01-22.stable.out 14 Mar 2009 14:48:00 -0000 1.20
+++ 01-22.stable.out 4 Jun 2009 20:27:54 -0000 1.21
@@ -29,14 +29,14 @@
# 11:48:05 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
# 11:48:05 >
-% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys.lineitem, sys., sys., sys.lineitem # table_name
+% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys., sys., sys., sys.lineitem # table_name
% l_returnflag, l_linestatus, sum_qty, sum_base_price,
sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc,
count_order # name
% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, wrd # type
% 1, 1, 6, 17, 21, 21, 22, 22, 22, 5 #
length
-[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937351, 0.050081339069642378, 14876
]
-[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908051, 0.047758620689655168, 348
]
-[ "N", "O", 742802, 1041502841.45, 989737518.6346, 1029418531.523350,
25.454987834549879, 35691.129209074395, 0.049931119564099929, 29181
]
-[ "R", "F", 381449, 534594445.35, 507996454.4067, 528524219.358903,
25.597168165346933, 35874.006532680178, 0.049827539927526504, 14902
]
+[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937235, 0.050081339069639651, 14876
]
+[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908036, 0.04775862068965505, 348
]
+[ "N", "O", 742802, 1041502841.45, 989737518.6346, 1029418531.523350,
25.454987834549879, 35691.129209074323, 0.049931119564084421, 29181
]
+[ "R", "F", 381449, 534594445.35, 507996454.4067, 528524219.358903,
25.597168165346933, 35874.006532680083, 0.049827539927524055, 14902
]
% .stats, .stats # table_name
% rewrite, count # name
% clob, int # type
@@ -1176,7 +1176,7 @@
% sys. # table_name
% avg_yearly # name
% decimal # type
-% 19 # length
+% 20 # length
[ NULL ]
% .stats, .stats # table_name
% rewrite, count # name
U 01.stable.out
Index: 01.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/01.stable.out,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- 01.stable.out 28 Feb 2009 13:00:44 -0000 1.14
+++ 01.stable.out 4 Jun 2009 20:27:54 -0000 1.15
@@ -24,14 +24,14 @@
# 11:47:55 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < 01.sql
# 11:47:55 >
-% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys.lineitem, sys., sys., sys.lineitem # table_name
+% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys., sys., sys., sys.lineitem # table_name
% l_returnflag, l_linestatus, sum_qty, sum_base_price,
sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc,
count_order # name
% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, wrd # type
% 1, 1, 6, 17, 21, 21, 22, 22, 22, 5 #
length
-[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937351, 0.050081339069642378, 14876
]
-[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908051, 0.047758620689655168, 348
]
-[ "N", "O", 742802, 1041502841.45, 989737518.6346, 1029418531.523350,
25.454987834549879, 35691.129209074395, 0.049931119564099929, 29181
]
-[ "R", "F", 381449, 534594445.35, 507996454.4067, 528524219.358903,
25.597168165346933, 35874.006532680178, 0.049827539927526504, 14902
]
+[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937235, 0.050081339069639651, 14876
]
+[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908036, 0.04775862068965505, 348
]
+[ "N", "O", 742802, 1041502841.45, 989737518.6346, 1029418531.523350,
25.454987834549879, 35691.129209074323, 0.049931119564084421, 29181
]
+[ "R", "F", 381449, 534594445.35, 507996454.4067, 528524219.358903,
25.597168165346933, 35874.006532680083, 0.049827539927524055, 14902
]
% .stats, .stats # table_name
% rewrite, count # name
% clob, int # type
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
