Changeset: bcb7c0fc067d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bcb7c0fc067d
Modified Files:
sql/test/subquery/Tests/subquery3.sql
Branch: default
Log Message:
Window function call with subqueries crashing
diffs (18 lines):
diff --git a/sql/test/subquery/Tests/subquery3.sql
b/sql/test/subquery/Tests/subquery3.sql
--- a/sql/test/subquery/Tests/subquery3.sql
+++ b/sql/test/subquery/Tests/subquery3.sql
@@ -291,6 +291,14 @@ SELECT
(SELECT SUM(t1.col1) OVER (PARTITION BY (VALUES(1)) ROWS UNBOUNDED
PRECEDING) FROM tbl_ProductSales)
FROM another_T t1; --error, subqueries not allowed inside PARTITION BY
+SELECT
+ (SELECT SUM(t1.col1) OVER (ORDER BY (VALUES(1)) ROWS UNBOUNDED PRECEDING)
FROM tbl_ProductSales)
+FROM another_T t1;
+
+SELECT
+ (SELECT SUM(t1.col1) OVER (ORDER BY (SELECT SUM(t1.col1 + t2.col1) FROM
another_T t2) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales)
+FROM another_T t1;
+
/* We shouldn't allow the following internal functions/procedures to be called
from regular queries */
--SELECT "identity"(col1) FROM another_T;
--SELECT "rowid"(col1) FROM another_T;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
