v.25.9New Feature

Boolean settings can be specified without arguments

Boolean settings can be specified without arguments, e.g., SET use_query_cache;, which is equivalent to setting it to true. #85800 (thraeka).
Boolean settings can now be specified without explicit arguments, allowing shorthand syntax like SET use_query_cache; to enable the setting by default (equivalent to SET use_query_cache = 1;).

Why it matters

This feature simplifies query syntax and improves user experience by allowing boolean settings to be enabled with a shorter, cleaner command. It eliminates the need to specify the value explicitly when setting a boolean to true, reducing potential errors and speeding up query writing.

How to use it

To enable a boolean setting using this feature, simply use the SET statement followed by the setting name without any value, for example:
SET use_query_cache;

This command sets use_query_cache to true implicitly.