v.22.10New Feature
Add Support for SET setting_name = DEFAULT
Add support for SET setting_name = DEFAULT. #42187 (Filatenkov Artur).Why it matters
This feature allows users to explicitly revert any custom settings back to their original default values during a session or query execution, improving flexibility and control over configurations without needing to restart or manipulate settings externally.How to use it
Use theSET statement with the assignment to DEFAULT for any configurable setting. For example:SET max_threads = DEFAULT;