SQL Modes for MariaDB Xpand 23.09

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

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

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