[CALCITE-3088] Multi-groupsets query failed due to data type preservation check

[DonnyZone]

The issue is described in CALCITE-3088. This kind of query is supported, for example, the case in agg.iq

# ROLLUP on 1 column
select deptno + 1, count(*) as c
from emp
group by rollup(deptno);

However, nullifyType in AggregatingSelectScope only checks the SqlNode itself, we need to take more cases into consideration.

[hsyuan]

I will find time to take a look.