Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.1.0
-
None
-
2017-16, 2017-17, 2017-18
Description
An aggregate query where the group by column is a char or varchar with dictionary storage appears to be about twice as slow as in 1.0. Normal columns like numbers or inline strings e.g. char(8) are not affected. For example:
select col2, sum(val), count(*) from sample1 group by 1 order by 1;
|
if col2 is say char(255)