ClickHouse / ClickHouse/ClickHouse

Improperly formatted error when adding an index for nonexistent column.

Open
#62,580 1 comment 0 reactions 0 assignees View on GitHub
comp-skip-index unfinished code
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

**Describe the unexpected behaviour**
The error message when adding an index for a nonexistent column repeats the column name too many times.

**How to reproduce**
Any version
fiddle: https://fiddle.clickhouse.com/b11fc39f-e320-4dda-8821-41e17bb6d612

```
ALTER TABLE users ADD INDEX heightidx height TYPE bloom_filter;

Received exception from server (version 24.3.2):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'height' while processing query: 'height', required columns: 'height' 'height'. (UNKNOWN_IDENTIFIER)
(query: ALTER TABLE users ADD INDEX heightidx height TYPE bloom_filter;)
```
'height' appears 4 times in the above message, twice in a row at the end.

**Expected behavior**
Error message should be formatted better.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.