[Subtask]: Rollup using Sort

Open

#20,653 opened on Dec 9, 2024 1 comment 0 reactions 1 assignee Claimed by @iamlinjunhong View on GitHub

kind/subtask priority/p0

Description

### Parent Issue

#20650

### Detail of Subtask

select c1, c2, avg(x) from T group by roll up (c1, c2);

The query plan should be Scan T -> Order by C1, C2 -> Rollup Agg

select

### Describe implementation you've considered

_No response_

### Additional information

_No response_

This issue has not been assessed yet.