Changeset: 92b89db830bd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/92b89db830bd
Modified Files:
sql/server/rel_select.c
Branch: Jun2023
Log Message:
Window functions partition by clause subqueries are not allowed atm.
(grafted from 44096ae7c955ce20c0c6d76032d5323cca16ad2b)
diffs (20 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
@@ -4479,12 +4479,15 @@ rel_partition_groupings(sql_query *query
return NULL;
}
}
- if (exp_is_rel(e))
+
+ if (exp_has_rel(e))
return sql_error(sql, 02, SQLSTATE(42000) "PARTITION
BY: subqueries not allowed in PARTITION BY clause");
+
if (e->type != e_column) { /* store group by expressions in the
stack */
if (!frame_push_groupby_expression(sql, grp, e))
return NULL;
}
+
if (e->card > CARD_AGGR)
e->card = CARD_AGGR;
append(exps, e);
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
