Changeset: a055cf0d0445 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a055cf0d0445
Modified Files:
sql/test/analytics/Tests/analytics11.sql
sql/test/analytics/Tests/analytics11.stable.out
Branch: grouping-analytics
Log Message:
Writing another test query
diffs (33 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,6 +187,17 @@ FROM another_T
GROUP BY ROLLUP(col1);
SELECT
+ 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))
+FROM another_T
+GROUP BY CUBE(col1, col2, col5, col8);
+
+SELECT
col1 IN (SELECT ColID + col2 FROM tbl_ProductSales)
FROM another_T
GROUP BY ROLLUP(col1); --error, col2 is not a grouping column
diff --git a/sql/test/analytics/Tests/analytics11.stable.out
b/sql/test/analytics/Tests/analytics11.stable.out
--- a/sql/test/analytics/Tests/analytics11.stable.out
+++ b/sql/test/analytics/Tests/analytics11.stable.out
@@ -324,7 +324,7 @@ stdout of test 'analytics11` in director
#INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88),
(111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888);
[ 4 ]
#SELECT
-# GROUPING(col1, col2, col3, col4, col5, col6, col7, col8)
+# col1 IN (SELECT ColID FROM tbl_ProductSales)
#FROM another_T
#GROUP BY ROLLUP(col1);
% .L10 # table_name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
