Aggregated DOUBLES (AVG and SUM) do not compare properly, especially with constants and non aggregated doubles.

BUG测试
create table test_t
(
id int,
sv dec(10,2)
)ENGINE=ColumnStore;

create table test_t1
(
id int,
sv dec(10,2)
)ENGINE=ColumnStore;
insert into test_t(id,sv) values(1,4.90);
insert into test_t(id,sv) values(1,4.90);
insert into test_t(id,sv) values(1,4.90);
insert into test_t1(id,sv) values(1,14.70);

select * from (select id,sum(sv) sv from test_t group by 1) a,
(select id,sum(sv) sv from test_t1 group by 1) b
where a.id=b.id and a.sv<>b.sv;

返回:
--------------------+

--------------------+

--------------------+
1 row in set (0.09 sec)

修改引擎为innodb后正常
alter table test_t engine=innodb;
alter table test_t1 engine=innodb;
再改为columnstore后bug再现
alter table test_t engine=columnstore;
alter table test_t1 engine=columnstore;