framework/resources/Functional/aggregates/aggregation/group_by_case/case_with_c_bigint_types.sql

select 
	count(*),
	case when a.c_integer is null then cast(100.0 as decimal(38,2)) else cast(a.c_integer as decimal(38,2)) end,
	case when a.c_bigint is null then cast(100.0 as decimal(38,2)) else cast(a.c_bigint as decimal(38,2)) end
from                                            
	alltypes a   left outer join alltypes b on (a.c_integer = b.c_integer)                         
		     left outer join alltypes c on (b.c_integer = c.c_integer)                 
group by
	case when a.c_integer is null then cast(100.0 as decimal(38,2)) else cast(a.c_integer as decimal(38,2)) end,
	case when a.c_bigint is null then cast(100.0 as decimal(38,2)) else cast(a.c_bigint as decimal(38,2)) end
order by
	case when a.c_integer is null then cast(100.0 as decimal(38,2)) else cast(a.c_integer as decimal(38,2)) end,
	case when a.c_bigint is null then cast(100.0 as decimal(38,2)) else cast(a.c_bigint as decimal(38,2)) end