SQL Modes for MariaDB Xpand

The parent of this page is: Reference for MariaDB Xpand

Topics on this page:

Overview

A summary of SQL modes across MariaDB Xpand versions:

SQL Mode	In 23.09?	In 6.1?	In 6.0?	In 5.3?
ALLOW_INVALID_DATES	23.09	6.1	6.0	5.3
ANSI	23.09	6.1	6.0	5.3
ANSI_QUOTES	23.09	6.1	6.0	5.3
DB2	23.09	6.1	6.0	5.3
ERROR_FOR_DIVISION_BY_ZERO	23.09	6.1	6.0	5.3
HIGH_NOT_PRECEDENCE	23.09	6.1	6.0	5.3
IGNORE_SPACE	23.09	6.1	6.0	5.3
MAXDB	23.09	6.1	6.0	5.3
MSSQL	23.09	6.1	6.0	5.3
MYSQL40	23.09	6.1	6.0	5.3
MYSQL323	23.09	6.1	6.0	5.3
NO_AUTO_CREATE_USER	23.09	6.1	6.0	5.3
NO_AUTO_VALUE_ON_ZERO	23.09	6.1	6.0	5.3
NO_BACKSLASH_ESCAPES	23.09	6.1	6.0	5.3
NO_DIR_IN_CREATE	23.09	6.1	6.0	5.3
NO_ENGINE_SUBSTITUTION	23.09	6.1	6.0	5.3
NO_FIELD_OPTIONS	23.09	6.1	6.0	5.3
NO_KEY_OPTIONS	23.09	6.1	6.0	5.3
NO_TABLE_OPTIONS	23.09	6.1	6.0	5.3
NO_UNSIGNED_SUBTRACTION	23.09	6.1	6.0	5.3
NO_ZERO_DATE	23.09	6.1	6.0	5.3
NO_ZERO_IN_DATE	23.09	6.1	6.0	5.3
ONLY_FULL_GROUP_BY	23.09	6.1	6.0	5.3
ORACLE	23.09	6.1	6.0	5.3
PAD_CHAR_TO_FULL_LENGTH	23.09	6.1	6.0	5.3
PIPES_AS_CONCAT	23.09	6.1	6.0	5.3
POSTGRESQL	23.09	6.1	6.0	5.3
REAL_AS_FLOAT	23.09	6.1	6.0	5.3
STRICT_ALL_TABLES	23.09	6.1	6.0	5.3
STRICT_TRANS_TABLES	23.09	6.1	6.0	5.3
TRADITIONAL	23.09	6.1	6.0	5.3