v.22.10New Feature

Add Support for SET setting_name = DEFAULT

Add support for SET setting_name = DEFAULT. #42187 (Filatenkov Artur).
Add support for resetting session or query settings to their default values using the syntax SET setting_name = DEFAULT.

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 the SET statement with the assignment to DEFAULT for any configurable setting. For example:

SET max_threads = DEFAULT;