Skip to content

GROUPING function argument is not in GROUP BY keys for typles with enable_analyzer=1 #79326

@dancing-elf

Description

@dancing-elf

Company or project name

No response

Describe what's wrong

https://fiddle.clickhouse.com/a4f845df-81e3-4f49-9747-a1bbfbfa9712

SELECT
    grouping(tt),
    (number, number) AS tt,
    count()
FROM numbers(10)
GROUP BY
    GROUPING SETS (
        (),
        (tt))
SETTINGS enable_analyzer = 1

DB::Exception: GROUPING function argument (number, number) AS tt is not in GROUP BY keys.

With enable_analyzer=0 this query works fine.

Looks like tuples in some sense are not compatible with grouping function with new analyzer.

There is simple workaround. It is possible to replace tt in grouping and GROUPING SETS with tuple parameters: https://fiddle.clickhouse.com/a09e4073-7467-4e1b-b31b-bd13197225f4

But in any case, it looks like a bug.

Does it reproduce on the most recent release?

Yes

How to reproduce

Any recent ClickHouse, link to ClickHouse Playground can be found above.

Expected behavior

No response

Error message and/or stacktrace

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

analyzerIssues and pull-requests related to new analyzerbugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions