v.21.7Improvement

Use Global Settings for VIEW Queries to Avoid Errors

Official CH changelog text
Use global settings for query to VIEW. Fixed the behavior when queries to VIEW use local settings, that leads to errors if setting on CREATE VIEW and SELECT were different. As for now, VIEW won't use these modified settings, but you can still pass additional settings in SETTINGS section of CREATE VIEW query. Close #20551. #24095 (Vladimir).
Use global settings for queries to VIEW to ensure consistent execution.

Why it matters

This feature fixes issues caused by local settings applied during SELECT queries on VIEW objects, which previously led to errors if settings differed between CREATE VIEW and SELECT executions. It ensures stability and predictable behavior by always using global settings for queries to VIEW.

How to use it

Users do not need to change their queries, as VIEW now automatically uses global settings during execution. Additional settings can still be specified explicitly within the SETTINGS clause of the CREATE VIEW statement if needed.

Related resources

PreviousNext