jayzhan211 commented on issue #15818:
URL: https://github.com/apache/datafusion/issues/15818#issuecomment-2823740436
> There's no `SortExec` in the query plan. Maybe it was removed by the
optimizer? In this query plan, the `agg.child` is not sorted by the GROUP BY
key.
>
> >
>
UBarney commented on issue #15818:
URL: https://github.com/apache/datafusion/issues/15818#issuecomment-2822958433
There's no `SortExec` in the query plan. Maybe it was removed by the
optimizer?
>
```
query TT
explain select sum(a) from (select a from t order by a) group by a;
jayzhan211 opened a new issue, #15818:
URL: https://github.com/apache/datafusion/issues/15818
### Is your feature request related to a problem or challenge?
```
statement ok
create table t(a int, b int) as values (1, 2), (2, 3);
query I
select sum(a) from (select a from
