Hi, On 2019-06-17 17:23:11 +0800, Richard Guo wrote: > During the reorder of grouping sets into correct prefix order, if only > one aggregation pass is needed, we follow the order of the ORDER BY > clause to the extent possible, to minimize the chance that we add > unnecessary sorts. This is implemented in preprocess_grouping_sets --> > reorder_grouping_sets.
Thanks for finding! Andrew, could you take a look at that? - Andres