Skip to content

Remove "*" column from aggregation results with COUNT(*) #43

Description

@fupelaqu

Description

When performing an aggregation with COUNT(*) or similar expressions using *, the result set includes a literal * column alongside the aggregation result. This column is meaningless in the context of an aggregation and should not be returned.

Example

SELECT COUNT(*) FROM ecommerce

Current result set:

* COUNT(*)
20

Expected Behaviour

Only the aggregated columns should be returned:

COUNT(*)
20

Impact

Notes

This is related to but distinct from issue #42. Both the bucket_root and * columns should be suppressed for clean aggregation output.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions