Closed
Description
Describe the bug
When the query contains a group by clause, the result is wrong.
There are duplicate groups in result.
To Reproduce
Steps to reproduce the behavior:
- create a table with more than one partition
create table test (k1 int ,k2 int) partition by range(k1) (partition p1 values less than 1, partition p2 values less than 2)
distributed by hash(k1) buckets 32;
- insert into some values in both partitions
- query, duplicate results
select k1 from test group by k1;
- There is only one aggregation node in the plan tree. The aggregation node is wrongly evaluated as colocate.
explain select k1 from test group by k1;
Expected behavior
There is no duplicate k1 in result.
Version
Doris: 0.14.12
Activity