v.20.10Improvement
Support Semicolon as Data Terminator for Inline INSERTs in ClickHouse Client
For INSERTs with inline data in VALUES format in the script mode of clickhouse-client, support semicolon as the data terminator, in addition to the new line. Closes #12288. #13192 (Alexander Kuzmenkov).Why it matters
This feature allows users to more flexibly and clearly terminate inline data blocks withinINSERT statements, improving script readability and compatibility with existing SQL script conventions. It solves the problem where only newline characters were accepted as terminators, which could cause confusion or errors when scripting multiple statements.How to use it
When usingclickhouse-client in script mode, you can now terminate inline INSERT data written in VALUES format with a semicolon (;) instead of only a newline. This makes scripts easier to write and maintain, especially with multiple INSERT statements.