Skip to main content

innodb_strict_mode

This page is part of MariaDB's Enterprise Documentation.

The parent of this page is: System Variables for MariaDB Enterprise Server

Topics on this page:

Overview
DETAILS
- PARAMETERS
CHANGE HISTORY
EXTERNAL REFERENCES

Overview

Use strict mode when evaluating create options.

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

PARAMETERS

Command-line	--innodb_strict_mode[={OFF\|ON}]
Configuration file	Supported
Dynamic	Yes
Scope	Global, Session
Data Type	BOOLEAN (OFF, ON)
Default Value	ON

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.6 Community	Present starting in MariaDB Community Server 10.6.0.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.5 Community	Present starting in MariaDB Community Server 10.5.0.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.
10.4 Community	Present starting in MariaDB Community Server 10.4.0.
10.3 Enterprise	Present starting in MariaDB Enterprise Server 10.3.16-1.
10.3 Community	Present starting in MariaDB Community Server 10.3.0.
10.2 Enterprise	Present starting in MariaDB Enterprise Server 10.2.25-1.
10.2 Community	Present starting in MariaDB Community Server 10.2.0. Default value changed in MariaDB Community Server 10.2.2 from OFF to ON

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.

Information specific to MariaDB SkySQL can be found on the innodb_strict_mode page in the SkySQL Documentation.