Changeset: 24f28be566d5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/24f28be566d5
Modified Files:
sql/server/rel_select.c
sql/test/subquery/Tests/subquery3.test
Branch: Jan2022
Log Message:
Disable get frame group by expression inside window function calls (they are
unrelated)
diffs (32 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -5110,7 +5110,7 @@ rel_value_exp2(sql_query *query, sql_rel
if (rel && *rel && (*rel)->card == CARD_AGGR) { /* group by expression
case, handle it before */
sql_exp *exp = NULL;
- if (!is_sql_aggr(f))
+ if (!is_sql_aggr(f) && !is_sql_window(f))
exp = frame_get_groupby_expression(sql, se);
if (sql->errstr[0] != '\0')
return NULL;
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
@@ -181,6 +181,16 @@ 2.500
query I nosort
SELECT
+ (SELECT RANK() OVER (PARTITION BY 2 ORDER BY 2) FROM tbl_ProductSales
GROUP BY t1.col1)
+FROM another_T t1
+----
+1
+1
+1
+1
+
+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
----
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
