Changeset: 51ed8acdebfe for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=51ed8acdebfe Modified Files: sql/test/sciql2sql/Tests/vector_fixed_tiles.sql Branch: SciQL-2 Log Message:
A simple and fast window aggregate. diffs (29 lines): diff --git a/sql/test/sciql2sql/Tests/vector_fixed_tiles.sql b/sql/test/sciql2sql/Tests/vector_fixed_tiles.sql --- a/sql/test/sciql2sql/Tests/vector_fixed_tiles.sql +++ b/sql/test/sciql2sql/Tests/vector_fixed_tiles.sql @@ -60,11 +60,24 @@ SELECT A.x, A.v+B.v FROM vector as A, vector as B WHERE A.x-1 = B.x; --- more elaborate slices +-- a more elaborate slices SELECT x, sum(v) FROM array1D GROUP BY array1D[x : 1 : x+4]; +-- alternative for simple range +SELECT A.beg, (SELECT sum(vector.v) FROM vector WHERE vector.x >= A.beg AND vector.x < A.lim) +FROM (SELECT x AS beg, x+4 AS lim FROM vector) AS A; + +-- a more elaborate slices +SELECT x, sum(v) +FROM array1D +GROUP BY array1D[x : 2 : x+4]; + +-- alternative for simple range +SELECT A.beg, (SELECT sum(vector.v) FROM vector WHERE vector.x >= A.beg AND vector.x < A.lim AND ((vector.x - A.beg) % 2) = 0) +FROM (SELECT x AS beg, x+4 AS lim FROM vector) AS A; + -- casting a more generic predicate into relational -- use a relative offset map to indicate group elements -- RUNTIME ERROR, produces NULL sums !! _______________________________________________ checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
