According to the mariadb.com reference guide to system variables, it should be possible to set the system variable check_constraint_checks via the command-line ("--check-constraint-checks=VALUE").
However, according to another page (https://mariadb.com/docs/skysql-new-release-dbaas/ref/mdb/system-variables/check_constraint_checks), this parameter cannot be set via command-line option or config file, but only via SET [GLOBAL|SESSION] at runtime:
Testing (with MariaDB 10.6.12)shows that the parameter cannot be set from command-line or config-file:
- How did we end up with the "SkySQL" docs correct, but the knowledge base reference is incorrect?
- Why are some (global) system variables not settable via CLI/config-file?
- This certainly does not simplify the end users' interface or expectations for configuring the engine.
- Is there some internal benefit, perhaps in terms of simplifying code structure, to not allowing these variables to be set via CLI/config-file?