Skip to content

CREATE STATEMENT altered after ALTER when using add_minmax_index_for_xxx flags #87286

@SmitaRKulkarni

Description

@SmitaRKulkarni

Company or project name

No response

Describe the unexpected behaviour

When minmax indices are added using the flags add_minmax_index_for_numeric_columns or add_minmax_index_for_string_columns, they are created implicitly and not added to CREATE statement.

But when ALTER is used for the table, the implicitly created indices appear in the CREATE statement

Which ClickHouse versions are affected?

25.9

How to reproduce

https://fiddle.clickhouse.com/6fa176f1-862e-4bc9-a884-3a995729674c

Expected behavior

The indices should not appear in the CREATE statement

Error message and/or stacktrace

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

comp-skip-indexSkipping indexes (minmax, set, bloom) and their evaluation.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions