'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 |
|---|
