Tom Lane<tgl@sss.pgh.pa.us> 在 2025年1月3日 周五 0:04 写道：
"谭忠涛" <zhongtao.tan@seaboxdata.com> writes: > create table t1(a int, b int); > insert into t1 values(1,1),(1,2); > select a,b,sum(10) as s from t1 where a = 1 group by rollup(a,b) order by a, s desc;
Yeah. This is fixed in HEAD (v18-to-be) but the fix is too invasive to consider back-patching. Basically the problem is that older versions don't understand that the post-ROLLUP value of "a" can be different from the pre-ROLLUP value, so they think the "where a = 1" clause removes any need to sort by "a".
As a workaround you could write something like "order by a+0, s desc" to fool the optimizer into considering the ordering column to be different from the value that's constrained by WHERE.
