Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.0
Description
Currently exception types are checked via SQLSTATE which isn't accurate.
Instead depending on the error number the exception type should be chosen.
MariaDB.DataError:
- ER_DATA_TOO_LONG
- ER_DATETIME_FUNCTION_OVERFLOW
- ER_DIVISION_BY_ZERO
- ER_NO_DEFAULT
- ER_PRIMARY_CANT_HAVE_NULL
- ER_WARN_DATA_OUT_OF_RANGE
- WARN_DATA_TRUNCATED
Mariadb.ProgrammingError:
- CR_COMMANDS_OUT_OF_SYNC
- ER_CANT_DO_THIS_DURING_AN_TRANSACTION
- ER_DB_CREATE_EXISTS
- ER_FIELD_SPECIFIED_TWICE
- ER_INVALID_GROUP_FUNC_USE
- ER_NO_SUCH_INDEX
- ER_NO_SUCH_KEY_VALUE
- ER_NO_SUCH_TABLE
- ER_NO_SUCH_USER
- ER_PARSE_ERROR
- ER_SYNTAX_ERROR
- ER_TABLE_MUST_HAVE_COLUMNS
- ER_UNSUPPORTED_EXTENSION
- ER_WRONG_DB_NAME
- ER_WRONG_TABLE_NAME
Mariadb.IntegrityError:
- ER_CANNOT_ADD_FOREIGN
- ER_DUP_ENTRY
- ER_DUP_UNIQUE
- ER_NO_DEFAULT_FOR_FIELD
- ER_NO_REFERENCED_ROW
- ER_NO_REFERENCED_ROW_2
- ER_ROW_IS_REFERENCED
- ER_ROW_IS_REFERENCED_2
Mariadb.OperationError:
For errornumbers >= 1000 which aren't listed above
Mariadb.InternalError
For errornumbers < 1000 which aren't listed above
Attachments
Issue Links
- blocks
-
CONPY-77 Add mariadb dialect to sqlalchemy
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Currently exception types are checked via SQLSTATE which isn't accurate.
Instead depending on the error number the exception type should be chosen. * MariaDB.DataError*: * ER_DATA_TOO_LONG * ER_DATETIME_FUNCTION_OVERFLOW * ER_DIVISION_BY_ZERO * ER_NO_DEFAULT * ER_PRIMARY_CANT_HAVE_NULL * ER_WARN_DATA_OUT_OF_RANGE * WARN_DATA_TRUNCATED *Mariadb.ProgrammingError*: * CR_COMMANDS_OUT_OF_SYNC * ER_CANT_DO_THIS_DURING_AN_TRANSACTION * ER_DB_CREATE_EXISTS * ER_FIELD_SPECIFIED_TWICE * ER_INVALID_GROUP_FUNC_USE * ER_NO_SUCH_INDEX * ER_NO_SUCH_KEY_VALUE * ER_NO_SUCH_TABLE * ER_NO_SUCH_USER * ER_PARSE_ERROR * ER_SYNTAX_ERROR * ER_TABLE_MUST_HAVE_COLUMNS * ER_UNSUPPORTED_EXTENSION * ER_WRONG_DB_NAME * ER_WRONG_TABLE_NAME *Mariadb.IntegrityError*: * ER_CANNOT_ADD_FOREIGN * ER_DUP_ENTRY * ER_DUP_UNIQUE * ER_NO_DEFAULT_FOR_FIELD * ER_NO_REFERENCED_ROW * ER_NO_REFERENCED_ROW_2 * ER_ROW_IS_REFERENCED * ER_ROW_IS_REFERENCED_2 *Mariadb.OperationError*: For errornumbers >= 1000 which aren't listed above *Mariadb.InternalError* For errornumbers < 1000 which aren't listed above |
Currently exception types are checked via SQLSTATE which isn't accurate.
Instead depending on the error number the exception type should be chosen. *MariaDB.DataError*: * ER_DATA_TOO_LONG * ER_DATETIME_FUNCTION_OVERFLOW * ER_DIVISION_BY_ZERO * ER_NO_DEFAULT * ER_PRIMARY_CANT_HAVE_NULL * ER_WARN_DATA_OUT_OF_RANGE * WARN_DATA_TRUNCATED *Mariadb.ProgrammingError*: * CR_COMMANDS_OUT_OF_SYNC * ER_CANT_DO_THIS_DURING_AN_TRANSACTION * ER_DB_CREATE_EXISTS * ER_FIELD_SPECIFIED_TWICE * ER_INVALID_GROUP_FUNC_USE * ER_NO_SUCH_INDEX * ER_NO_SUCH_KEY_VALUE * ER_NO_SUCH_TABLE * ER_NO_SUCH_USER * ER_PARSE_ERROR * ER_SYNTAX_ERROR * ER_TABLE_MUST_HAVE_COLUMNS * ER_UNSUPPORTED_EXTENSION * ER_WRONG_DB_NAME * ER_WRONG_TABLE_NAME *Mariadb.IntegrityError*: * ER_CANNOT_ADD_FOREIGN * ER_DUP_ENTRY * ER_DUP_UNIQUE * ER_NO_DEFAULT_FOR_FIELD * ER_NO_REFERENCED_ROW * ER_NO_REFERENCED_ROW_2 * ER_ROW_IS_REFERENCED * ER_ROW_IS_REFERENCED_2 *Mariadb.OperationError*: For errornumbers >= 1000 which aren't listed above *Mariadb.InternalError* For errornumbers < 1000 which aren't listed above |
| issue.field.resolutiondate | 2020-08-14 12:47:13.0 | 2020-08-14 12:47:13.516 |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Labels | sqlalchemy |
| Workflow | MariaDB v3 [ 112443 ] | MariaDB v4 [ 135673 ] |
Fixed rev. e091edd54909f07e18875526debd5231bd444b5c