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