OceanBase Database

SQL - V4.4.2

Download PDF

innodb_strict_mode

Last Updated:2026-09-03 07:31:11

Note

This variable is available starting with V4.0.0.

Description

innodb_strict_mode specifies the SQL syntax check mode.

Privilege requirements

Query variables
- Global level
  
  sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle-compatible mode) or the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode) to obtain the value of a global system variable.
- Session level
  
  sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle-compatible mode) or the information_schema.SESSION_VARIABLES view (MySQL-compatible mode) to obtain the value of a session system variable.
Modify variables
- Global level
  - sys tenants can directly modify the value of a global system variable.
  - MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.
  - Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.
- Session level
  
  sys tenants and all user tenants can directly modify the value of a session system variable.

Attributes

Attribute	Description
Type	Bool
Default value	1
Value range	1: strict mode. When you execute the `CREATE TABLE`, `ALTER TABLE`, and `CREATE INDEX` statements, no warning is returned for errors in specific scenarios (such as unsupported `ROW_FORMAT`). Instead, an error is returned. 0: non-strict mode. Lenient syntax checks are performed, and the default syntax is used to replace incorrect syntax.
Scope	Global Session
Modifiable	Yes. You can execute the `SET` statement to modify the value.

Examples

Set the SQL syntax check mode to 1.

Global level

obclient> SET GLOBAL innodb_strict_mode =1;

Session level
```
obclient> SET innodb_strict_mode =1;
```

Previous topic

innodb_stats_persistent

Next topic

interactive_timeout

innodb_strict_mode|V4.4.2|OceanBase Database|docs|OceanBase Documentations