Changeset: fd21012bba5f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd21012bba5f
Modified Files:
sql/test/analytics/Tests/analytics11.sql
Branch: grouping-analytics
Log Message:
Updated test
diffs (28 lines):
diff --git a/sql/test/analytics/Tests/analytics11.sql
b/sql/test/analytics/Tests/analytics11.sql
--- a/sql/test/analytics/Tests/analytics11.sql
+++ b/sql/test/analytics/Tests/analytics11.sql
@@ -187,15 +187,21 @@ FROM another_T
GROUP BY ROLLUP(col1);
SELECT
+ GROUPING(col1, col2, col5, col8),
col1 IN (SELECT ColID + col2 FROM tbl_ProductSales),
col1 < ANY (SELECT MAX(ColID + col2) FROM tbl_ProductSales),
col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MIN(col8) IS NULL),
EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID =
another_T.col1),
col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales),
- SUM(DISTINCT CASE WHEN col5 - col8 = (SELECT MIN(ColID / col2) FROM
tbl_ProductSales) THEN col2 - 5 ELSE ABS(col1) END),
- (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER
(PARTITION BY AVG(col5))
+ CAST(SUM(DISTINCT CASE WHEN col5 - col8 = (SELECT MIN(ColID / col2) FROM
tbl_ProductSales) THEN col2 - 5 ELSE ABS(col1) END) AS BIGINT),
+ (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER
(PARTITION BY AVG(DISTINCT col5)),
+ GROUPING(col1, col5, col8) * MIN(col8) OVER (PARTITION BY col5 ORDER BY
col1 ROWS UNBOUNDED PRECEDING) evil,
+ MAX(col3) / 10 + GROUPING(col1, col5, col2) * 10,
+ GROUP_CONCAT(CAST(col4 AS VARCHAR(32)), '-sep-') || ' plus ' ||
GROUPING(col1),
+ NTILE(col1) OVER (ORDER BY col8 DESC),
+ col2 * NULL
FROM another_T
-GROUP BY CUBE(col1, col2, col5, col8);
+GROUP BY CUBE(col1, col2, col5, col8), GROUPING SETS (());
SELECT
col1 IN (SELECT ColID + col2 FROM tbl_ProductSales)
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
