Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Duplicate
-
Affects Version/s: 1.5.2
-
Fix Version/s: 6.1.1
-
Component/s: ExeMgr
-
Labels:
-
Environment:Ubuntu 20.04.1 LTS
-
Sprint:2021-4, 2021-5
Description
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;
返回:
--------------------+
id | sv | id | sv |
--------------------+
1 | 14.70 | 1 | 14.70 |
--------------------+
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;