[release-18.0] use aggregation engine over distinct engine when overlapping order by (#14359)

[release-18.0] use aggregation engine over distinct engine when overlapping order by (#14359) #27735