Changeset: 7683c7c78e96 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7683c7c78e96
Modified Files:
sql/test/analytics/Tests/analytics13.sql
sql/test/analytics/Tests/analytics13.stable.out
Branch: default
Log Message:
No hugeint in the output
diffs (33 lines):
diff --git a/sql/test/analytics/Tests/analytics13.sql
b/sql/test/analytics/Tests/analytics13.sql
--- a/sql/test/analytics/Tests/analytics13.sql
+++ b/sql/test/analytics/Tests/analytics13.sql
@@ -141,12 +141,12 @@ SELECT
EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID =
another_T.col1) a6,
col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales) a7,
CAST(SUM(DISTINCT CASE WHEN col5 - col8 = (SELECT MIN(ColID / col2) FROM
tbl_ProductSales) THEN col2 - 5 ELSE ABS(col1) END) AS BIGINT) a8,
- (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER
(PARTITION BY AVG(DISTINCT col5)) a9,
+ CAST((SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER
(PARTITION BY AVG(DISTINCT col5)) AS BIGINT) a9,
GROUPING(col1, col5, col8) * MIN(col8) OVER (PARTITION BY col5 ORDER BY
col1 NULLS LAST ROWS UNBOUNDED PRECEDING) a10,
MAX(col3) / 10 + GROUPING(col1, col5, col2) * 10 a11,
GROUP_CONCAT(CAST(col4 AS VARCHAR(32)), '-sep-') || ' plus ' ||
GROUPING(col1) a12,
FIRST_VALUE(col1) OVER (ORDER BY col8 DESC NULLS FIRST) a13,
- col2 * NULL a14
+ CAST(col2 * NULL AS BIGINT) a14
FROM another_T
GROUP BY CUBE(col1, col2, col5, col8), GROUPING SETS (())
ORDER BY
diff --git a/sql/test/analytics/Tests/analytics13.stable.out
b/sql/test/analytics/Tests/analytics13.stable.out
--- a/sql/test/analytics/Tests/analytics13.stable.out
+++ b/sql/test/analytics/Tests/analytics13.stable.out
@@ -506,9 +506,9 @@ stdout of test 'analytics13` in director
# col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MIN(col8) IS NULL) a5,
# EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID =
another_T.col1) a6,
# col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales) a7,
-% .%1, .%60, ., ., ., ., ., .%13, ., .,
., ., ., . # table_name
+% .%1, .%62, ., ., ., ., ., .%13, ., .,
., ., ., . # table_name
% a1, a2, a3, a4, a5, a6, a7, a8, a9, a10,
a11, a12, a13, a14 # name
-% tinyint, boolean, boolean, int, boolean,
boolean, boolean, bigint, hugeint, bigint, bigint,
varchar, int, hugeint # type
+% tinyint, boolean, boolean, int, boolean,
boolean, boolean, bigint, bigint, bigint, bigint, varchar,
int, bigint # type
% 2, 5, 5, 4, 5, 5, 5, 4, 4, 5,
3, 32, 3, 1 # length
[ 0, false, true, 5555, true, false, false, 1111, 2226, 0,
333, "4444 plus 0", 111, NULL ]
[ 0, false, true, NULL, true, true, false, 1, 6, 0,
0, "4 plus 0", 111, NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
