SQL Modes for MariaDB Xpand 23.09
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 23.09
Topics on this page:
Overview
The supported SQL modes in MariaDB Xpand:
SQL Mode | Description |
---|---|
This mode allows the use of | |
This mode enables strict mode for all tables | |
This mode enables strict mode for all tables because all Xpand tables use transactional storage engines |
A SQL mode alias sets one or more alternate mode flags instead of putting its own name into the SQL mode string.
The aliased SQL modes in MariaDB Xpand 23.09:
SQL Mode | Description |
---|---|
This mode is an alias for STRICT_ |
Discarded SQL modes are accepted without error but have no effect on DB behavior and do not affect the SQL mode string.
The discarded SQL modes in MariaDB Xpand 23.09:
SQL Mode | Description |
---|---|
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded | |
Discarded |
Attempting to set SQL_MODE
to an unsupported value will result in a NULL value being set. Xpand does not warn on unsupported values for SQL_MODE