Skip to content

Skipping indexes for alias columns do not work. #2015

Description

@voipadm1

I checked the Altinity Stable Builds lifecycle table, and the Altinity Stable Build version I'm using is still supported.

altinity/clickhouse-server:26.3.16.10001.altinitystable-alpine

Type of problem

Bug report - something's broken

Skipping indexes for alias columns do not work.

Describe the situation

Index aliasing fails to function in version 26.3.16.10001.altinitystable-alpine, as demonstrated in the demo (https://fiddle.clickhouse.com/3cc61f3f-978e-4056-91a6-eff719645aa3).
The index is correctly utilized when enable_analyzer is set to 0. See the reproduction example here: https://fiddle.clickhouse.com/f3295ac9-14d0-418c-aab2-62ac6487d2e9

Metadata

Metadata

Assignees

No one assigned

    Labels

    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