Available on crate features
mariadb_backend or mysql_backend only.Expand description
The SQLSTATE codes MySQL 8.4 and MariaDB 11.8 report, taken from
messages_to_clients.txt
and errmsg-utf8.txt.
use sqlstate::{SqlState, mysql_like};
let code: SqlState = "40001".parse().unwrap();
assert!(matches!(code, mysql_like::SERIALIZATION_FAILURE));Constantsยง
- ACTIVE_
SQL_ TRANSACTION 25001, active SQL transaction.- BASE_
TABLE_ OR_ VIEW_ ALREADY_ EXISTS 42S01, base table or view already exists.- BASE_
TABLE_ OR_ VIEW_ NOT_ FOUND 42S02, base table or view not found.- CANT_
MODIFY_ SRID_ 0 SR000, SRID 0 cannot be modified. MySQL only.- CANT_
MODIFY_ SRS_ USED_ BY_ COLUMN SR005, SRS used by a column. MySQL only.- CARDINALITY_
VIOLATION 21000, cardinality violation.- CASE_
NOT_ FOUND 20000, case not found for case statement.- COLUMN_
ALREADY_ EXISTS 42S21, column already exists.- COLUMN_
NOT_ FOUND 42S22, column not found.- COMMUNICATION_
LINK_ FAILURE 08S01, communication link failure.- DATETIME_
FIELD_ OVERFLOW 22008, datetime field overflow.- DIVISION_
BY_ ZERO 22012, division by zero.- FEATURE_
NOT_ SUPPORTED 0A000, feature not supported.- FUNCTION_
EXECUTED_ NO_ RETURN_ STATEMENT 2F005, function executed no return statement.- GENERAL_
ERROR HY000, general error.- GIS_
DIFFERENT_ SRIDS_ AGGREGATION 22S05, aggregate over different SRIDs. MySQL only.- INDEX_
NOT_ FOUND 42S12, index not found.- INSERT_
VALUE_ LIST_ DOES_ NOT_ MATCH_ COLUMN_ LIST 21S01, insert value list does not match column list.- INTEGRITY_
CONSTRAINT_ VIOLATION 23000, integrity constraint violation.- INVALID_
ARGUMENT_ FOR_ LOGARITHM 2201E, invalid argument for natural logarithm.- INVALID_
AUTHORIZATION_ SPECIFICATION 28000, invalid authorization specification.- INVALID_
CAST_ POLYGON_ RING_ DIRECTION 22S04, invalid polygon ring direction. MySQL only.- INVALID_
CATALOG_ NAME 3D000, invalid catalog name.- INVALID_
CHARACTER_ VALUE_ FOR_ CAST 22018, invalid character value for cast. MySQL only.- INVALID_
CONDITION_ NUMBER 35000, invalid condition number.- INVALID_
CURSOR_ STATE 24000, invalid cursor state.- INVALID_
DATETIME_ FORMAT 22007, invalid datetime format.- INVALID_
GRANTOR 0L000, invalid grantor. MariaDB only.- INVALID_
JSON_ TEXT 22032, invalid JSON text. MySQL only.- INVALID_
PARAMETER_ VALUE 22023, invalid parameter value.- INVALID_
ROLE OP000, invalid role specification. MariaDB only.- INVALID_
SRS_ ATTRIBUTE SR006, invalid SRS attribute. MySQL only.- INVALID_
SRS_ DEFINITION SR002, invalid SRS definition. MySQL only.- INVALID_
TABLESAMPLE_ ARGUMENT 2202H, invalid tablesample argument. MySQL only.- INVALID_
TRANSACTION_ STATE 25000, invalid transaction state.- LATITUDE_
OUT_ OF_ RANGE 22S03, latitude out of range. MySQL only.- LONGITUDE_
OUT_ OF_ RANGE 22S02, longitude out of range. MySQL only.- MEMORY_
ALLOCATION_ ERROR HY001, memory allocation error.- MORE_
THAN_ ONE_ SQL_ JSON_ ITEM 22034, more than one SQL/JSON item. MySQL only.- NO_DATA
02000, no data.- NO_
SQL_ JSON_ ITEM 22035, no SQL/JSON item. MySQL only.- NO_
SUCH_ DB 42Y07, unknown database. MySQL only.- NULL_
VALUE_ NOT_ ALLOWED 22004, null value not allowed.- NUMERIC_
VALUE_ OUT_ OF_ RANGE 22003, numeric value out of range.- OPERATION_
ABORTED 70100, operation aborted.- PROHIBITED_
SQL_ STATEMENT_ ATTEMPTED 2F003, prohibited SQL statement attempted.- READ_
ONLY_ SQL_ TRANSACTION 25006, read-only SQL transaction.- RESIGNAL_
WHEN_ HANDLER_ NOT_ ACTIVE 0K000, resignal when handler not active.- SERIALIZATION_
FAILURE 40001, serialization failure.- SQLSERVER_
REJECTED_ ESTABLISHMENT_ OF_ SQLCONNECTION 08004, SQL server rejected establishment of SQL connection.- SQL_
JSON_ SCALAR_ REQUIRED 2203F, SQL/JSON scalar required. MySQL only.- SRS_
ID_ ALREADY_ EXISTS SR004, SRS ID already exists. MySQL only.- SRS_
NOT_ FOUND SR001, SRS not found. MySQL only.- SRS_
NOT_ SUPPORTED 22S00, unsupported SRS operation. MySQL only.- SRS_
PROJ_ PARAMETER_ MISSING SR003, missing SRS projection parameter. MySQL only.- STACKED_
DIAGNOSTICS_ ACCESSED_ WITHOUT_ ACTIVE_ HANDLER 0Z002, stacked diagnostics accessed without active handler.- STRING_
DATA_ RIGHT_ TRUNCATION 22001, string data, right truncation.- SYNTAX_
ERROR_ OR_ ACCESS_ RULE_ VIOLATION 42000, syntax error or access rule violation.- TRANSACTION_
ROLLBACK 40000, transaction rollback. MySQL only.- UNEXPECTED_
GEOMETRY_ TYPE 22S01, unexpected geometry type. MySQL only.- UNIT_
NOT_ FOUND SU001, unknown unit. MySQL only.- WARNING
01000, warning.- WARN_
RESERVED_ SRID_ RANGE 01S01, reserved SRID range warning. MySQL only.- WARN_
SRS_ ID_ ALREADY_ EXISTS 01S00, SRS ID already exists warning. MySQL only.- WITH_
CHECK_ OPTION_ VIOLATION 44000, with check option violation. MariaDB only.- XAER_
DUPID XAE08, XID already exists.- XAER_
INVAL XAE05, invalid XA arguments.- XAER_
NOTA XAE04, unknown XID.- XAER_
OUTSIDE XAE09, work outside the XA transaction.- XAER_
RMERR XAE03, XA resource manager error.- XAER_
RMFAIL XAE07, XA command not allowed in this state.- XA_
RBDEADLOCK XA102, XA branch rolled back after a deadlock.- XA_
RBROLLBACK XA100, XA branch rolled back.- XA_
RBTIMEOUT XA106, XA branch rolled back after a timeout.