'Clickhouse: Difference in row results between 2 versions

In version 19.13.3.26 the following query returns 1 row:

select   -1 as brandidTotal, toDecimal64(Sum(CostpriceSEK),2) as costprice
  from mytable
  where Stylenumber = 'a row which does not exist'  
  group by brandidTotal

But in version 22.2.2.1 it returns an empty result (which i can understand, since where does not find any rows)

It seems like the aggregate function SUM has changed behaviour. (if second column is removed, both returns an empty set)

Is it possible to make version 22X handle it like 19x does?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source