ClickHouse: CLI is broken starting with v22.3
Cli is broken starting with v22.3-lts:
- When I try to copy-paste multiline sql query, clickhouse-client (launched with -m flag ofc) goes insane and breaks query:
CREATE TABLE test
(
Date Date,
user_id Nullable(UInt32),
custom_audience_id UInt32,
segment_id Nullable(UInt32),
)
ENGINE = MergeTree() partition by Date order by (Date, user_id);
2. When I press enter, query should kind of split and continue on a new line with prompt
:-]
as it was in previous versions, but starting with 22.3 I just get newline feed:
How to reproduce?
- Using your linux disro (ubuntu for instance) open any text editor, gedit for instance, and paste in it the query above:
- Using your mouse, select query and press
CTRL+C
on your keyboard. - Open your terminal emulator and launch
clickhouse-client -m
. I usealacritty
terminal emulator, but may be there are some more affected emulator. I also triedfoot
terminal – same result. - Press
CTRL+SHIFT+V
Expected behavior:Not expected behavior:
Does it reproduce on recent release?
yes, ClickHouse server version 22.3.2 revision 54455
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 2
- Comments: 15 (8 by maintainers)
I can reproduce with alacritty. It’s related to bracketed paste. Will investigate further.