Changeset: 279bb626d40a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/279bb626d40a
Modified Files:
sql/test/subquery/Tests/subquery3.test
Branch: Jan2022
Log Message:
Window function on subquery crash. Looking into it
diffs (20 lines):
diff --git a/sql/test/subquery/Tests/subquery3.test
b/sql/test/subquery/Tests/subquery3.test
--- a/sql/test/subquery/Tests/subquery3.test
+++ b/sql/test/subquery/Tests/subquery3.test
@@ -179,6 +179,16 @@ 2.500
2.500
2.500
+query I nosort
+SELECT
+ (SELECT SUM(1) OVER (PARTITION BY 2 ORDER BY 2 ROWS UNBOUNDED PRECEDING)
FROM tbl_ProductSales GROUP BY t1.col1)
+FROM another_T t1
+----
+1
+1
+1
+1
+
query R nosort
SELECT
(SELECT SUM(AVG(ColID + col1)) OVER (PARTITION BY SUM(ColID + col3) ORDER
BY MAX(ColID) * col4 ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales GROUP BY
t1.col1)
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
