Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv17983/src/test/BugTracker-2009/Tests
Modified Files:
AVG_ReturnsNoLines.SF-2596084.sql
Log Message:
propagated changes of Friday Mar 05 2010 - Wednesday Mar 10 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/03/05 - sjoerd:
src/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.sql,1.2.8.1
CRLF -> LF.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: AVG_ReturnsNoLines.SF-2596084.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- AVG_ReturnsNoLines.SF-2596084.sql 15 Feb 2009 12:43:20 -0000 1.2
+++ AVG_ReturnsNoLines.SF-2596084.sql 10 Mar 2010 14:30:06 -0000 1.3
@@ -1,59 +1,59 @@
-CREATE TABLE x (
-x DOUBLE
-)
-;
-
-INSERT INTO x VALUES (1);
-INSERT INTO x VALUES (2);
-INSERT INTO x VALUES (3);
-
--- does not return records
-SELECT AVG(x) AS avgx, AVG(x) AS avgx2
-FROM x;
-
-SELECT AVG(x) AS avgx, SUM(x) AS sumx
-FROM x;
-
-SELECT AVG(x) AS avgx, COUNT(x) AS countx
-FROM x;
-
-
--- fine
-SELECT AVG(x) AS avgx, COUNT(*) AS countstar
-FROM x;
-
-SELECT AVG(x) AS avgx, MIN(x) AS minx
-FROM x;
-
-SELECT AVG(x) AS avgx, MAX(x) AS maxx
-FROM x;
-
-SELECT SUM(x) AS sumx, MIN(x) AS minx, MAX(x) AS maxx, COUNT(x) AS countx,
COUNT(*) AS countstar
-FROM x;
-
-
--- one pass standard deviation: numerically less stable than the same
caluclation in R
-SELECT COUNT(x) AS n1, sum(x)/count(x) as m1, sqrt( sum(x*x)/count(x) -
(sum(x)/count(x))*(sum(x)/count(x)) ) as sd1
-FROM x;
-
--- two pass standard deviation with inner count (FAILS due to the AGGREGATION
BUG)
-SELECT MIN(n) AS n2, MIN(m) AS m2, SQRT(SUM((x-m)*(x-m))/MIN(n)) AS sd2
-FROM
-(
- SELECT AVG(x) AS m, COUNT(x) AS n
- FROM x
-) pass1
-, x
-;
-
--- two pass standard deviation with outer count (works in MonetDB)
-SELECT COUNT(x) AS n2, MIN(m) AS m2, SQRT(SUM((x-m)*(x-m))/COUNT(x)) AS sd2
-FROM
-(
- SELECT AVG(x) AS m
- FROM x
-) agg
-, x
-;
-
-drop table x;
+CREATE TABLE x (
+x DOUBLE
+)
+;
+
+INSERT INTO x VALUES (1);
+INSERT INTO x VALUES (2);
+INSERT INTO x VALUES (3);
+
+-- does not return records
+SELECT AVG(x) AS avgx, AVG(x) AS avgx2
+FROM x;
+
+SELECT AVG(x) AS avgx, SUM(x) AS sumx
+FROM x;
+
+SELECT AVG(x) AS avgx, COUNT(x) AS countx
+FROM x;
+
+
+-- fine
+SELECT AVG(x) AS avgx, COUNT(*) AS countstar
+FROM x;
+
+SELECT AVG(x) AS avgx, MIN(x) AS minx
+FROM x;
+
+SELECT AVG(x) AS avgx, MAX(x) AS maxx
+FROM x;
+
+SELECT SUM(x) AS sumx, MIN(x) AS minx, MAX(x) AS maxx, COUNT(x) AS countx,
COUNT(*) AS countstar
+FROM x;
+
+
+-- one pass standard deviation: numerically less stable than the same
caluclation in R
+SELECT COUNT(x) AS n1, sum(x)/count(x) as m1, sqrt( sum(x*x)/count(x) -
(sum(x)/count(x))*(sum(x)/count(x)) ) as sd1
+FROM x;
+
+-- two pass standard deviation with inner count (FAILS due to the AGGREGATION
BUG)
+SELECT MIN(n) AS n2, MIN(m) AS m2, SQRT(SUM((x-m)*(x-m))/MIN(n)) AS sd2
+FROM
+(
+ SELECT AVG(x) AS m, COUNT(x) AS n
+ FROM x
+) pass1
+, x
+;
+
+-- two pass standard deviation with outer count (works in MonetDB)
+SELECT COUNT(x) AS n2, MIN(m) AS m2, SQRT(SUM((x-m)*(x-m))/COUNT(x)) AS sd2
+FROM
+(
+ SELECT AVG(x) AS m
+ FROM x
+) agg
+, x
+;
+
+drop table x;
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
