Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.2.2
-
Fix Version/s: 1.2.4
-
Component/s: ExeMgr
-
Labels:None
-
Sprint:2019-04
Description
The query
select c1,count(distinct c2) as c2,count(distinct c3) as c3, avg_mode(c4) as c4 from t1 group by c1; |
returns the error
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in TupleAggregateSte
|
.
Here are the steps to reproduce:
create table t1 (c1 int, c2 int, c3 int, c4 int)engine=columnstore;
|
insert into t1 values (1,2,3,4),(1,2,3,4),(1,2,3,4),(1,2,3,4);
|
select c1,count(distinct c2) as c2,count(distinct c3) as c3, avg_mode(c4) as c4 from t1 group by c1;
|