v.21.1Improvements

Fix SETTINGS Clause Parsing in INSERT ... SELECT Query

Official CH changelog text
Fix parsing of SETTINGS clause of the INSERT ... SELECT ... SETTINGS query. #17414 (Azat Khuzhin).
Fix parsing of the SETTINGS clause in INSERT ... SELECT ... SETTINGS queries to ensure correct interpretation and application of settings within such statements.

Why it matters

The fix solves issues related to incorrect parsing of the SETTINGS clause when used in INSERT ... SELECT queries, allowing users to reliably customize query settings for these statements and improve query execution control.

How to use it

Users can now append the SETTINGS clause directly to INSERT ... SELECT queries as follows:

INSERT INTO table_name SELECT ... FROM ... SETTINGS setting_name = value;

Related resources

PreviousNext