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	Parsed	Supported
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	❌	❌
STRICT_TRANS_TABLES	✅	❌
TIME_TRUNCATE_FRACTIONAL	❌	❌