Doris2.0.3版本ROUND函数四舍五入偶发性错误

Viewed 13

Doris版本:2.0.3
最小复现sql:

with a as (
select 5/8 as rate -- 结果错误
union all
select 3/8 -- 结果正确
union all
select 2/3  -- 结果正确
)
select rate, round(rate, 2) FROM a;

执行结果:

rate round(rate, 2)
0.625 0.62
0.375 0.38
0.6666666666666667 0.67

期望结果:

rate round(rate, 2)
0.625 0.63
0.375 0.38
0.6666666666666667 0.67
1 Answers

这个问题在新版本修复了,建议升级到2.1.11