--! qt:dataset:src
select sum(a) from (
  select cast(1.1 as decimal) a from src tablesample (1 rows)
  union all
  select cast(null as decimal) a from src tablesample (1 rows)
) t;

select sum(a) from (
  select cast(1 as tinyint) a from src tablesample (1 rows)
  union all
  select cast(null as tinyint) a from src tablesample (1 rows)
  union all
  select cast(1.1 as decimal) a from src tablesample (1 rows)
) t;

select sum(a) from (
  select cast(1 as smallint) a from src tablesample (1 rows)
  union all
  select cast(null as smallint) a from src tablesample (1 rows)
  union all
  select cast(1.1 as decimal) a from src tablesample (1 rows)
) t;

select sum(a) from (
  select cast(1 as int) a from src tablesample (1 rows)
  union all
  select cast(null as int) a from src tablesample (1 rows)
  union all
  select cast(1.1 as decimal) a from src tablesample (1 rows)
) t;

select sum(a) from (
  select cast(1 as bigint) a from src tablesample (1 rows)
  union all
  select cast(null as bigint) a from src tablesample (1 rows)
  union all
  select cast(1.1 as decimal) a from src tablesample (1 rows)
) t;