Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.2
-
None
-
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;
|