Hi After AggregateExpandDistinctAggregatesRule, I got a plan like this: The $10 in the project node is $g=[GROUPING($0, $1, $2, $3, $4, $5, $6, $7, $8)]) and we can see it is compared with value 1/2/3, but I check the def of grouping(), both pg and oracle, the value of grouping is 0 or 1.
pg:https://www.postgresqltutorial.com/postgresql-grouping-sets/ oracle: https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions064.htm#SQLRF00647 ``` EnumerableProject(xx=[$0], xx=[$1], xx=[$2], xx=[$3], xx=[$4], xx=[$5], xx=[$6], $f7=[$7], $f8=[$8], gid=[$9], $g_1=[=($10, 1)], $g_2=[=($10, 2)], $g_3=[=($10, 3)]) EnumerableHashAggregate(group=[{0, 1, 2, 3, 4, 5, 6, 7, 8}], groups=[[{0, 1, 2, 3, 4, 5, 6, 7}, {0, 1, 2, 3, 4, 5, 6, 8}, {0, 1, 2, 3, 4, 5, 6}]], dim_type=[grouping_id()], $g=[GROUPING($0, $1, $2, $3, $4, $5, $6, $7, $8)]) ``` Regards! Aron Tao