[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: Jan2022 - Window function on subquery crash. Looking in...
From:       Pedro_Ferreira <commits+pedro.ferreira=monetdbsolutions.com () mon
Date:       2022-01-31 12:44:52
Message-ID: hg.279bb626d40a.1643633092.4921093088525347765 () dev ! monetdb ! org
[Download RAW message or body]

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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list


[prev in list] [next in list] [prev in thread] [next in thread]