SQL State List
The following table lists the SQLSTATE classes and individual SQLSTATE codes.
SQLState | Description | Details |
---|---|---|
Class 00—Successful Completion | ||
00000 | ERRCODE_SUCCESSFUL_COMPLETION | |
Class 01—Warning | ||
01000 | ERRCODE_WARNING | associated warning messages |
01003 | ERRCODE_WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION | |
01004 | ERRCODE_WARNING_STRING_DATA_RIGHT_TRUNCATION | associated warning messages |
01006 | ERRCODE_WARNING_PRIVILEGE_NOT_REVOKED | associated warning messages |
01007 | ERRCODE_WARNING_PRIVILEGE_NOT_GRANTED | associated warning messages |
01008 | ERRCODE_WARNING_PRIVILEGE_ALREADY_GRANTED | |
01009 | ERRCODE_WARNING_PRIVILEGE_ALREADY_REVOKED | |
0100C | ERRCODE_WARNING_DYNAMIC_RESULT_SETS_RETURNED | |
01V01 | ERRCODE_WARNING_DEPRECATED_FEATURE | associated warning messages |
01V02 | ERRCODE_WARNING_QUERY_RETRIED | |
Class 02—No Data | ||
02000 | ERRCODE_NO_DATA | |
02001 | ERRCODE_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED | |
Class 03—SQL Statement Not Yet Complete | ||
03000 | ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE | |
Class 08—Client Connection Exception | ||
08000 | ERRCODE_CONNECTION_EXCEPTION | associated error messages |
08001 | ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION | associated error messages |
08003 | ERRCODE_CONNECTION_DOES_NOT_EXIST | associated error messages |
08004 | ERRCODE_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION | |
08006 | ERRCODE_CONNECTION_FAILURE | associated error messages |
08007 | ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN | |
08V01 | ERRCODE_PROTOCOL_VIOLATION | associated error messages |
Class 09—Triggered Action Exception | ||
09000 | ERRCODE_TRIGGERED_ACTION_EXCEPTION | associated error messages |
Class 0A—Feature Not Supported | ||
0A000 | ERRCODE_FEATURE_NOT_SUPPORTED | associated error messages |
0A005 | ERRCODE_PLAN_TO_SQL_NOT_SUPPORTED | associated error messages |
Class 0B—Invalid Transaction Initiation | ||
0B000 | ERRCODE_INVALID_TRANSACTION_INITIATION | associated error messages |
Class 0F—Locator Exception | ||
0F000 | ERRCODE_LOCATOR_EXCEPTION | |
0F001 | ERRCODE_L_E_INVALID_SPECIFICATION | |
Class 0L—Invalid Grantor | ||
0L000 | ERRCODE_INVALID_GRANTOR | |
0LV01 | ERRCODE_INVALID_GRANT_OPERATION | associated error messages |
Class 0P—Invalid Role Specification | ||
0P000 | ERRCODE_INVALID_ROLE_SPECIFICATION | |
Class 21—Cardinality Violation | ||
21000 | ERRCODE_CARDINALITY_VIOLATION | |
Class 22—Data Exception | ||
22000 | ERRCODE_DATA_EXCEPTION | associated error messages |
22001 | ERRCODE_STRING_DATA_RIGHT_TRUNCATION | associated error messages |
22002 | ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER | |
22003 | ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE | associated error messages |
22004 | ERRCODE_NULL_VALUE_NOT_ALLOWED | associated error messages |
22005 | ERRCODE_ERROR_IN_ASSIGNMENT | |
22007 | ERRCODE_INVALID_DATETIME_FORMAT | associated error messages |
22008 | ERRCODE_DATETIME_FIELD_OVERFLOW | associated error messages |
22009 | ERRCODE_INVALID_TIME_ZONE_DISPLACEMENT_VALUE | associated error messages |
2200B | ERRCODE_ESCAPE_CHARACTER_CONFLICT | associated error messages |
2200C | ERRCODE_INVALID_USE_OF_ESCAPE_CHARACTER | |
2200D | ERRCODE_INVALID_ESCAPE_OCTET | associated error messages |
2200F | ERRCODE_ZERO_LENGTH_CHARACTER_STRING | |
2200G | ERRCODE_MOST_SPECIFIC_TYPE_MISMATCH | |
22010 | ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE | |
22011 | ERRCODE_SUBSTRING_ERROR | associated error messages |
22012 | ERRCODE_DIVISION_BY_ZERO | associated error messages |
22015 | ERRCODE_INTERVAL_FIELD_OVERFLOW | associated error messages |
22018 | ERRCODE_INVALID_CHARACTER_VALUE_FOR_CAST | |
22019 | ERRCODE_INVALID_ESCAPE_CHARACTER | associated error messages |
2201B | ERRCODE_INVALID_REGULAR_EXPRESSION | associated error messages |
2201E | ERRCODE_INVALID_ARGUMENT_FOR_LOG | |
2201F | ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION | |
2201G | ERRCODE_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION | associated error messages |
22020 | ERRCODE_INVALID_LIMIT_VALUE | |
22021 | ERRCODE_CHARACTER_NOT_IN_REPERTOIRE | associated error messages |
22022 | ERRCODE_INDICATOR_OVERFLOW | |
22023 | ERRCODE_INVALID_PARAMETER_VALUE | associated error messages |
22024 | ERRCODE_UNTERMINATED_C_STRING | |
22025 | ERRCODE_INVALID_ESCAPE_SEQUENCE | associated error messages |
22026 | ERRCODE_STRING_DATA_LENGTH_MISMATCH | |
22027 | ERRCODE_TRIM_ERROR | |
2202E | ERRCODE_ARRAY_ELEMENT_ERROR | |
22906 | ERRCODE_NONSTANDARD_USE_OF_ESCAPE_CHARACTER | associated error messages |
22V01 | ERRCODE_FLOATING_POINT_EXCEPTION | |
22V02 | ERRCODE_INVALID_TEXT_REPRESENTATION | associated error messages |
22V03 | ERRCODE_INVALID_BINARY_REPRESENTATION | associated error messages |
22V04 | ERRCODE_BAD_COPY_FILE_FORMAT | associated error messages |
22V05 | ERRCODE_UNTRANSLATABLE_CHARACTER | |
22V0B | ERRCODE_ESCAPE_CHARACTER_ON_NOESCAPE | associated error messages |
22V21 | ERRCODE_INVALID_EPOCH | associated error messages |
22V22 | ERRCODE_PLPGSQL_ERROR | |
22V23 | ERRCODE_RAISE_EXCEPTION | associated error messages |
22V24 | ERRCODE_COPY_PARSE_ERROR | associated error messages |
Class 23—Integrity Constraint Violation | ||
23000 | ERRCODE_INTEGRITY_CONSTRAINT_VIOLATION | |
23001 | ERRCODE_RESTRICT_VIOLATION | |
23502 | ERRCODE_NOT_NULL_VIOLATION | associated error messages |
23503 | ERRCODE_FOREIGN_KEY_VIOLATION | associated error messages |
23505 | ERRCODE_UNIQUE_VIOLATION | associated error messages |
23514 | ERRCODE_CHECK_VIOLATION | associated error messages |
Class 24—Invalid Cursor State | ||
24000 | ERRCODE_INVALID_CURSOR_STATE | |
Class 25—Invalid Transaction State | ||
25000 | ERRCODE_INVALID_TRANSACTION_STATE | associated error messages |
25001 | ERRCODE_ACTIVE_SQL_TRANSACTION | |
25002 | ERRCODE_BRANCH_TRANSACTION_ALREADY_ACTIVE | |
25003 | ERRCODE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION | |
25004 | ERRCODE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION | |
25005 | ERRCODE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION | |
25006 | ERRCODE_READ_ONLY_SQL_TRANSACTION | |
25007 | ERRCODE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED | |
25008 | ERRCODE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL | |
25V01 | ERRCODE_NO_ACTIVE_SQL_TRANSACTION | associated error messages |
25V02 | ERRCODE_IN_FAILED_SQL_TRANSACTION | |
Class 26—Invalid SQL Statement Name | ||
26000 | ERRCODE_INVALID_SQL_STATEMENT_NAME | |
Class 27—Triggered Data Change Violation | ||
27000 | ERRCODE_TRIGGERED_DATA_CHANGE_VIOLATION | |
Class 28—Invalid Authorization Specification | ||
28000 | ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION | associated error messages |
28001 | ERRCODE_ACCOUNT_LOCKED | |
28002 | ERRCODE_PASSWORD_EXPIRED | |
28003 | ERRCODE_PASSWORD_IN_GRACE_PERIOD | |
Class 2B—Dependent Privilege Descriptors Still Exist | ||
2B000 | ERRCODE_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST | |
2BV01 | ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST | associated error messages |
Class 2D—Invalid Transaction Termination | ||
2D000 | ERRCODE_INVALID_TRANSACTION_TERMINATION | |
Class 2F—SQL Routine Exception | ||
2F000 | ERRCODE_SQL_ROUTINE_EXCEPTION | |
2F002 | ERRCODE_S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
2F003 | ERRCODE_S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
2F004 | ERRCODE_S_R_E_READING_SQL_DATA_NOT_PERMITTED | |
2F005 | ERRCODE_S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT | |
Class 34—Invalid Cursor Name | ||
34000 | ERRCODE_INVALID_CURSOR_NAME | |
Class 38—External Routine Exception | ||
38000 | ERRCODE_EXTERNAL_ROUTINE_EXCEPTION | |
38001 | ERRCODE_E_R_E_CONTAINING_SQL_NOT_PERMITTED | |
38002 | ERRCODE_E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
38003 | ERRCODE_E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
38004 | ERRCODE_E_R_E_READING_SQL_DATA_NOT_PERMITTED | associated error messages |
Class 39—External Routine Invocation Exception | ||
39000 | ERRCODE_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION | |
39001 | ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED | |
39004 | ERRCODE_E_R_I_E_NULL_VALUE_NOT_ALLOWED | |
39V01 | ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED | |
39V02 | ERRCODE_E_R_I_E_SRF_PROTOCOL_VIOLATED | |
Class 3B—Savepoint Exception | ||
3B000 | ERRCODE_SAVEPOINT_EXCEPTION | |
3B001 | ERRCODE_S_E_INVALID_SPECIFICATION | |
Class 3D—Invalid Catalog Name | ||
3D000 | ERRCODE_INVALID_CATALOG_NAME | |
Class 3F—Invalid Schema Name | ||
3F000 | ERRCODE_INVALID_SCHEMA_NAME | |
Class 40—Transaction Rollback | ||
40000 | ERRCODE_TRANSACTION_ROLLBACK | |
40001 | ERRCODE_T_R_SERIALIZATION_FAILURE | |
40002 | ERRCODE_T_R_INTEGRITY_CONSTRAINT_VIOLATION | |
40003 | ERRCODE_T_R_STATEMENT_COMPLETION_UNKNOWN | |
40V01 | ERRCODE_T_R_DEADLOCK_DETECTED | associated error messages |
Class 42—Syntax Error or Access Rule Violation | ||
42000 | ERRCODE_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION | |
42501 | ERRCODE_INSUFFICIENT_PRIVILEGE | associated error messages |
42601 | ERRCODE_SYNTAX_ERROR | associated error messages |
42602 | ERRCODE_INVALID_NAME | associated error messages |
42611 | ERRCODE_INVALID_COLUMN_DEFINITION | associated error messages |
42622 | ERRCODE_NAME_TOO_LONG | associated error messages |
42701 | ERRCODE_DUPLICATE_COLUMN | associated error messages |
42702 | ERRCODE_AMBIGUOUS_COLUMN | associated error messages |
42703 | ERRCODE_UNDEFINED_COLUMN | associated error messages |
42704 | ERRCODE_UNDEFINED_OBJECT | associated error messages |
42710 | ERRCODE_DUPLICATE_OBJECT | associated error messages |
42712 | ERRCODE_DUPLICATE_ALIAS | associated error messages |
42723 | ERRCODE_DUPLICATE_FUNCTION | associated error messages |
42725 | ERRCODE_AMBIGUOUS_FUNCTION | associated error messages |
42803 | ERRCODE_GROUPING_ERROR | associated error messages |
42804 | ERRCODE_DATATYPE_MISMATCH | associated error messages |
42809 | ERRCODE_WRONG_OBJECT_TYPE | associated error messages |
42830 | ERRCODE_INVALID_FOREIGN_KEY | associated error messages |
42846 | ERRCODE_CANNOT_COERCE | associated error messages |
42883 | ERRCODE_UNDEFINED_FUNCTION | associated error messages |
42939 | ERRCODE_RESERVED_NAME | associated error messages |
42P20 | ERRCODE_WINDOWING_ERROR | associated error messages |
42V01 | ERRCODE_UNDEFINED_TABLE | associated error messages |
42V02 | ERRCODE_UNDEFINED_PARAMETER | associated error messages |
42V03 | ERRCODE_DUPLICATE_CURSOR | associated error messages |
42V04 | ERRCODE_DUPLICATE_DATABASE | associated error messages |
42V05 | ERRCODE_DUPLICATE_PSTATEMENT | |
42V06 | ERRCODE_DUPLICATE_SCHEMA | associated error messages |
42V07 | ERRCODE_DUPLICATE_TABLE | associated error messages |
42V08 | ERRCODE_AMBIGUOUS_PARAMETER | associated error messages |
42V09 | ERRCODE_AMBIGUOUS_ALIAS | associated error messages |
42V10 | ERRCODE_INVALID_COLUMN_REFERENCE | associated error messages |
42V11 | ERRCODE_INVALID_CURSOR_DEFINITION | associated error messages |
42V12 | ERRCODE_INVALID_DATABASE_DEFINITION | |
42V13 | ERRCODE_INVALID_FUNCTION_DEFINITION | associated error messages |
42V14 | ERRCODE_INVALID_PSTATEMENT_DEFINITION | |
42V15 | ERRCODE_INVALID_SCHEMA_DEFINITION | associated error messages |
42V16 | ERRCODE_INVALID_TABLE_DEFINITION | associated error messages |
42V17 | ERRCODE_INVALID_OBJECT_DEFINITION | associated error messages |
42V18 | ERRCODE_INDETERMINATE_DATATYPE | associated error messages |
42V21 | ERRCODE_UNDEFINED_PROJECTION | associated error messages |
42V22 | ERRCODE_UNDEFINED_NODE | associated error messages |
42V23 | ERRCODE_UNDEFINED_PERMUTATION | |
42V24 | ERRCODE_UNDEFINED_USER | associated error messages |
42V25 | ERRCODE_PATTERN_MATCH_ERROR | associated error messages |
42V26 | ERRCODE_DUPLICATE_NODE | associated error messages |
Class 44—WITH CHECK OPTION Violation | ||
44000 | ERRCODE_WITH_CHECK_OPTION_VIOLATION | |
Class 53—Insufficient Resources | ||
53000 | ERRCODE_INSUFFICIENT_RESOURCES | associated error messages |
53100 | ERRCODE_DISK_FULL | associated error messages |
53200 | ERRCODE_OUT_OF_MEMORY | associated error messages |
53300 | ERRCODE_TOO_MANY_CONNECTIONS | |
Class 54—Program Limit Exceeded | ||
54000 | ERRCODE_PROGRAM_LIMIT_EXCEEDED | associated error messages |
54001 | ERRCODE_STATEMENT_TOO_COMPLEX | associated error messages |
54011 | ERRCODE_TOO_MANY_COLUMNS | associated error messages |
54023 | ERRCODE_TOO_MANY_ARGUMENTS | associated error messages |
Class 55—Object Not In Prerequisite State | ||
55000 | ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE | associated error messages |
55006 | ERRCODE_OBJECT_IN_USE | associated error messages |
55V02 | ERRCODE_CANT_CHANGE_RUNTIME_PARAM | associated error messages |
55V03 | ERRCODE_LOCK_NOT_AVAILABLE | associated error messages |
55V04 | ERRCODE_TM_MARKER_NOT_AVAILABLE | associated error messages |
Class 57—Operator Intervention | ||
57000 | ERRCODE_OPERATOR_INTERVENTION | |
57014 | ERRCODE_QUERY_CANCELED | associated error messages |
57015 | ERRCODE_SLOW_DELETE | associated error messages |
57V01 | ERRCODE_ADMIN_SHUTDOWN | associated error messages |
57V02 | ERRCODE_CRASH_SHUTDOWN | |
57V03 | ERRCODE_CANNOT_CONNECT_NOW | associated error messages |
57V04 | ERRCODE_DML_COMMIT_DURING_SHUTDOWN | associated error messages |
Class 58—System Error | ||
58030 | ERRCODE_IO_ERROR | associated error messages |
58V01 | ERRCODE_UNDEFINED_FILE | associated error messages |
58V02 | ERRCODE_DUPLICATE_FILE | |
Class V1—Vertica-specific multi-node errors class | ||
V1001 | ERRCODE_LOST_CONNECTIVITY | associated error messages |
V1002 | ERRCODE_K_SAFETY_VIOLATION | associated error messages |
V1003 | ERRCODE_CLUSTER_CHANGE | associated error messages |
Class V2—Vertica-specific miscellaneous errors class | ||
V2000 | ERRCODE_AUTH_FAILED | associated error messages |
V2001 | ERRCODE_LICENSE_ISSUE | associated error messages |
V2002 | ERRCODE_MOVEOUT_ABORTED | |
Class VC—Configuration File Error | ||
VC001 | ERRCODE_CONFIG_FILE_ERROR | associated error messages |
VC002 | ERRCODE_LOCK_FILE_EXISTS | |
Class VD—DB Designer errors | ||
VD001 | ERRCODE_DESIGNER_FUNCTION_ERROR | associated error messages |
Class VP—User procedure errors | ||
VP000 | ERRCODE_USER_PROC_ERROR | associated error messages |
VP001 | ERRCODE_USER_PROC_EXEC_ERROR | associated error messages |
Class VX—Internal Error | ||
VX001 | ERRCODE_INTERNAL_ERROR | associated error messages |
VX002 | ERRCODE_DATA_CORRUPTED | associated error messages |
VX003 | ERRCODE_INDEX_CORRUPTED | associated error messages |
VX004 | ERRCODE_PLAN_TO_SQL_INTERNAL_EROR | associated error messages |