SQL Modes

Dolt supports a subset of SQL modes that MySQL supports. SQL modes are added upon request, so please file an issue if a SQL mode you need is missing.

Currently supporting 4 of 18 MySQL SQL Modes.

Mode	Supported	Notes and limitations
ALLOW_INVALID_DATES	❌
ANSI_QUOTES	✅
ERROR_FOR_DIVISION_BY_ZERO	❌
HIGH_NOT_PRECEDENCE	❌
IGNORE_SPACE	❌
NO_AUTO_VALUE_ON_ZERO	✅
NO_BACKSLASH_ESCAPES	❌
NO_DIR_IN_CREATE	❌
NO_ENGINE_SUBSTITUION	❌
NO_UNSIGNED_SUBTRACTION	❌
NO_ZERO_IN_DATE	❌
ONLY_FULL_GROUP_BY	✅
PAD_CHAR_TO_FULL_LENGTH	❌
PIPES_AS_CONCAT	✅
REAL_AS_FLOAT	❌
STRICT_ALL_TABLES	🟠	Partial implementation
STRICT_TRANS_TABLES	🟠	Partial implementation
TIME_TRUNCATE_FRACTIONAL	❌
ANSI	🟠	Partial implementation
TRADITIONAL	🟠	Partial implementation