SQL Modes for MariaDB Xpand 5.3

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Xpand 5.3

Topics on this page:

• Overview

Overview

The supported SQL modes in MariaDB Xpand:

SQL Mode	Description
NO_AUTO_VALUE_ON_ZERO	This mode allows the use of 0 as a valid ID value in an AUTO_INCREMENT column
STRICT_ALL_TABLES	This mode enables strict mode for all tables
STRICT_TRANS_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 5.3:

SQL Mode	Description
TRADITIONAL	This mode is an alias for STRICT_TRANS_TABLES, STRICT_ALL_TABLES

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 5.3:

SQL Mode	Description
ALLOW_INVALID_DATES	Discarded
ANSI	Discarded
ANSI_QUOTES	Discarded
DB2	Discarded
ERROR_FOR_DIVISION_BY_ZERO	Discarded
HIGH_NOT_PRECEDENCE	Discarded
IGNORE_SPACE	Discarded
MAXDB	Discarded
MSSQL	Discarded
MYSQL40	Discarded
MYSQL323	Discarded
NO_AUTO_CREATE_USER	Discarded
NO_BACKSLASH_ESCAPES	Discarded
NO_DIR_IN_CREATE	Discarded
NO_ENGINE_SUBSTITUTION	Discarded
NO_FIELD_OPTIONS	Discarded
NO_KEY_OPTIONS	Discarded
NO_TABLE_OPTIONS	Discarded
NO_UNSIGNED_SUBTRACTION	Discarded
NO_ZERO_DATE	Discarded
NO_ZERO_IN_DATE	Discarded
ONLY_FULL_GROUP_BY	Discarded
ORACLE	Discarded
PAD_CHAR_TO_FULL_LENGTH	Discarded
PIPES_AS_CONCAT	Discarded
POSTGRESQL	Discarded
REAL_AS_FLOAT	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