Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.0.15, 1.1.6, 1.2.2
-
Fix Version/s: 1.4.0
-
Component/s: ExeMgr
-
Labels:None
-
Sprint:2019-06
Description
If the group_concat contains distinct together with sorting over non-distinct column CS concatenates distinct values multiple times.
Here is the setting:
create table cs1 (i bigint, a bigint) engine=columnstore;
|
insert into cs1 values (1,2),(1,3),(2,5),(1,42);
|
MariaDB [tpch1]> select group_concat(distinct i order by a) s from cs1; |
+---------+ |
| s |
|
+---------+ |
| 1,1,2,1 |
|
+---------+ |
1 row in set (0.031 sec) |