-
Notifications
You must be signed in to change notification settings - Fork 8.3k
CREATE STATEMENT altered after ALTER when using add_minmax_index_for_xxx flags #87286
Copy link
Copy link
Closed
Closed
Copy link
Labels
comp-skip-indexSkipping indexes (minmax, set, bloom) and their evaluation.Skipping indexes (minmax, set, bloom) and their evaluation.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
Description
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
Expected behavior
The indices should not appear in the CREATE statement
Error message and/or stacktrace
No response
Additional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-skip-indexSkipping indexes (minmax, set, bloom) and their evaluation.Skipping indexes (minmax, set, bloom) and their evaluation.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.