Update of /cvsroot/monetdb/sql/src/benchmarks/viam/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4764/src/benchmarks/viam/Tests
Modified Files:
viam.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 viam.stable.out
Index: viam.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/viam/Tests/viam.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- viam.stable.out 19 May 2009 12:03:44 -0000 1.6
+++ viam.stable.out 4 Jun 2009 20:27:54 -0000 1.7
@@ -29,75 +29,75 @@
% framenumber, L1 # name
% int, double # type
% 2, 22 # length
-[ 0, 0.30695294662260675 ]
-[ 10, 0.34215974026038998 ]
-[ 1, 0.31133796146937781 ]
-[ 2, 0.31584908305734827 ]
-[ 3, 0.32029031304752126 ]
-[ 4, 0.32489776611328125 ]
-[ 5, 0.32922236124674481 ]
-[ 6, 0.33303991464468147 ]
-[ 7, 0.33666583895683289 ]
-[ 8, 0.33938613770500065 ]
-[ 9, 0.34158032940280053 ]
-[ 11, 0.3414149284362793 ]
-[ 12, 0.33826388342905855 ]
-[ 13, 0.33573798475594357 ]
-[ 14, 0.33305609853644119 ]
-[ 15, 0.3304450511932373 ]
-[ 16, 0.32665918523615056 ]
-[ 17, 0.32401106092664933 ]
-[ 18, 0.32026470832104953 ]
-[ 19, 0.31680826040414661 ]
-[ 20, 0.31580734252929688 ]
-[ 21, 0.31546594619750978 ]
-[ 22, 0.31392023514728157 ]
-[ 23, 0.31344342231750488 ]
-[ 24, 0.31303939413517079 ]
-[ 25, 0.31352478524912958 ]
-[ 35, 0.30002869500054252 ]
-[ 26, 0.31288666195339626 ]
-[ 27, 0.31368268619884143 ]
-[ 28, 0.31432167319364324 ]
-[ 29, 0.31539074579874676 ]
-[ 30, 0.31412336302966604 ]
-[ 31, 0.31138606071472169 ]
-[ 32, 0.30901219294621396 ]
-[ 33, 0.30601227910895096 ]
-[ 34, 0.30280208587646484 ]
-[ 36, 0.29600227900913784 ]
-[ 37, 0.29091349770041075 ]
-[ 38, 0.28351434071858722 ]
-[ 39, 0.27877286076545715 ]
-[ 40, 0.27311918812413372 ]
-[ 41, 0.27115430831909182 ]
-[ 42, 0.26799287467167293 ]
-[ 43, 0.26751933779035297 ]
-[ 44, 0.26730593928584345 ]
-[ 45, 0.26559316194974458 ]
-[ 46, 0.26078170776367188 ]
-[ 47, 0.25835843880971271 ]
-[ 48, 0.25673953346584155 ]
-[ 49, 0.25190258026123047 ]
-[ 50, 0.24933456239246188 ]
-[ 60, 0.28343489964803059 ]
-[ 51, 0.24969205856323243 ]
-[ 52, 0.24868099313033254 ]
-[ 53, 0.25191232893202042 ]
-[ 54, 0.26048239539651308 ]
-[ 55, 0.27104237675666809 ]
-[ 61, 0.29858572142464773 ]
-[ 62, 0.31546867810762846 ]
-[ 63, 0.30967815717061359 ]
+[ 0, 0.30695301364656552 ]
+[ 10, 0.34215982588099653 ]
+[ 1, 0.3113380552700879 ]
+[ 2, 0.31584915478268394 ]
+[ 3, 0.32029039529152215 ]
+[ 4, 0.324897847458053 ]
+[ 5, 0.32922245573365327 ]
+[ 6, 0.33304000577101339 ]
+[ 7, 0.33666592778172344 ]
+[ 8, 0.33938622817633646 ]
+[ 9, 0.34158040931628597 ]
+[ 11, 0.34141500654319923 ]
+[ 12, 0.33826395578808705 ]
+[ 13, 0.33573804140604774 ]
+[ 14, 0.33305609500721883 ]
+[ 15, 0.33044506090560127 ]
+[ 16, 0.32665917128324506 ]
+[ 17, 0.3240110450596721 ]
+[ 18, 0.32026470677470259 ]
+[ 19, 0.31680825882806229 ]
+[ 20, 0.31580730293895681 ]
+[ 21, 0.31546590879559516 ]
+[ 22, 0.31392019272458799 ]
+[ 23, 0.31344336348896223 ]
+[ 24, 0.31303934990725618 ]
+[ 25, 0.31352472710220708 ]
+[ 35, 0.30002867782281506 ]
+[ 26, 0.31288660979933208 ]
+[ 27, 0.31368266943503509 ]
+[ 28, 0.31432166158459907 ]
+[ 29, 0.31539072468876839 ]
+[ 30, 0.31412332759397787 ]
+[ 31, 0.31138603556901218 ]
+[ 32, 0.30901219008060604 ]
+[ 33, 0.30601227381511736 ]
+[ 34, 0.30280206513565938 ]
+[ 36, 0.29600226900407245 ]
+[ 37, 0.29091348301838427 ]
+[ 38, 0.28351431656064408 ]
+[ 39, 0.27877282653935254 ]
+[ 40, 0.2731191758667269 ]
+[ 41, 0.27115428174535433 ]
+[ 42, 0.26799284307093457 ]
+[ 43, 0.26751930186791079 ]
+[ 44, 0.26730590534430965 ]
+[ 45, 0.26559313243398297 ]
+[ 46, 0.26078169733285905 ]
+[ 47, 0.25835839317490655 ]
+[ 48, 0.25673949750869168 ]
+[ 49, 0.25190256569873204 ]
+[ 50, 0.24933454571735292 ]
+[ 60, 0.2834349046150843 ]
+[ 51, 0.24969202317297459 ]
+[ 52, 0.2486809715628624 ]
+[ 53, 0.25191230368283057 ]
+[ 54, 0.26048238049535188 ]
+[ 55, 0.27104236697778106 ]
+[ 61, 0.29858571184532984 ]
+[ 62, 0.31546868957006013 ]
+[ 63, 0.30967816462119419 ]
[ 64, 0.3105892701582475 ]
-[ 65, 0.30352048873901366 ]
-[ 66, 0.30165598127577042 ]
-[ 67, 0.29831510782241821 ]
-[ 68, 0.30489427702767508 ]
-[ 69, 0.31504048903783161 ]
-[ 70, 0.32884438037872316 ]
+[ 65, 0.3035204976797104 ]
+[ 66, 0.30165599783261615 ]
+[ 67, 0.29831512272357941 ]
+[ 68, 0.30489428128514973 ]
+[ 69, 0.31504049400488537 ]
+[ 70, 0.32884439229965212 ]
[ 71, 0.34047374129295349 ]
-[ 72, 0.35729098320007324 ]
+[ 72, 0.35729099313418072 ]
[ 73, 0.36034649610519409 ]
[ 74, 0.3620469868183136 ]
------------------------------------------------------------------------------
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
