Skip to content
This repository was archived by the owner on Jan 28, 2021. It is now read-only.

Support DISTINCT and multiple expressions on aggregation functionsΒ #162

Closed
@erizocosmico

Description

@erizocosmico

According to MySQL documentation aggregation functions support DISTINCT clause and COUNT supports multiple expressions. We don't support neither.

I have been trying to implement the DISTINCT in a simple way by creating a DISTINCT aggregation node to pass to the aggregation functions instead but it's a bit complicated to do for aggregations this way so it ended up nowhere and this can't be done with query rewriting.

We should think more about how to implement this correctly.

Labeling as bug because right now it parses but produces wrong results.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions