-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Closed
Labels
area/colocatedIssues or PRs related to colocated tablesIssues or PRs related to colocated tablesarea/plannerIssues or PRs related to the query plannerIssues or PRs related to the query plannerkind/fixCategorizes issue or PR as related to a bug.Categorizes issue or PR as related to a bug.
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
area/colocatedIssues or PRs related to colocated tablesIssues or PRs related to colocated tablesarea/plannerIssues or PRs related to the query plannerIssues or PRs related to the query plannerkind/fixCategorizes issue or PR as related to a bug.Categorizes issue or PR as related to a bug.