innodb_strict_mode specifies the check mode for SQL statements with specific syntax.
Note
This variable was introduced in OceanBase Database V4.0.0.
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | 1 |
| Value range | 1: The strict mode is used. When an error occurs during the execution of CREATE TABLE, ALTER TABLE, or CREATE INDEX statement in specific scenarios, such as when ROW_FORMAT is not supported, the error message is displayed without giving an alert.0: The non-strict mode is used. In non-strict mode, a less strict syntax check is performed, and the incorrect syntax is replaced by the default syntax. |
| Effective scope | |
| Involved in serialization | No |
| Plan generation affected | No |
| Nullable | No |
| Modifiable | Yes |