v.18.12New Feature

Added join_default_strictness Setting for JOIN Operations

Added the join_default_strictness setting (values: ", 'any', 'all'). This allows you to not specify ANY or ALL for JOIN. #2982
Added the join_default_strictness setting to specify the default strictness of JOIN operations without explicitly using ANY or ALL keywords.

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 the join_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.