about optimization rules for over(partition by id, age order by id, age)

[key lou]

HI ALL :
   I have the following sql:
select name, row_number() over(partition by id, age order by id, age) rn
from t; In fact, it can be optimized into
select name ,row_number() over(partition by id,age) rn from t;
Remove order by because order by and partition by are repeated. Since they
are grouped according to the partition by field, the sorting is
meaningless. Is there such a solution in calcite? Optimize rules?
thanks.