v.18.12New Feature
Added join_default_strictness Setting for JOIN Operations
Added thejoin_default_strictnesssetting (values:",'any','all'). This allows you to not specifyANYorALLforJOIN. #2982
Why it matters
This feature simplifies query writing by allowing users to define a default join strictness mode (ANY, ALL, or empty) globally or per session, reducing the need to repeat these keywords in every JOIN clause and preventing ambiguity or errors.How to use it
Set thejoin_default_strictness configuration setting in your users.xml, config.xml, or through a session setting to one of the values: "" (empty), 'any', or 'all'. Once set, JOIN statements without explicit strictness will use the specified default.