HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

Class 42 - Class 44

SQLSTATE Value Description
Class 42 - Syntax error or access rule violation
42000 Syntax error or access rule violation (SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION)
42601 syntax error (SYNTAX_ERROR)
42501 Insufficient privilege (INSUFFICIENT_PRIVILEGE)
42846 Type conversion cannot be performed 无法进行类型转换(CANNOT_COERCE)
42803 Grouping error (GROUPING_ERROR)
42P20 Windowing error (WINDOWING_ERROR)
42P19 Invalid recursion (INVALID_RECURSION)
42830 Invalid foreign key (INVALID_FOREIGN_KEY)
42602 Invalid name (INVALID_NAME)
42622 Too long name (NAME_TOO_LONG)
42939 Reserved name (RESERVED_NAME)
42804 Data type mismatch (DATATYPE_MISMATCH)
42P18 Indeterminate data type (INDETERMINATE_DATATYPE)
42P21 Collation mismatch (COLLATION_MISMATCH)
42P22 Indeterminate collation (INDETERMINATE_COLLATION)
42P23 Partition error (PARTITION_ERROR)
42P24 Invalid attribute value (INVALID_ATTRIBUTE)
42P25 Invalid aggregation function (INVALID_AGG)
42P26 Resource pool error (RESOURCE_POOL_ERROR)
42P27 Parent plan not found (PLAN_PARENT_NOT_FOUND)
42P28 Update conflict (MODIFY_CONFLICTS)
42P29 Distribution error (DISTRIBUTION_ERROR)
42809 Incorrect object type (WRONG_OBJECT_TYPE)
42703 Undefined column (UNDEFINED_COLUMN)
42883 Undefined function (UNDEFINED_FUNCTION)
42P01 Undefined table (UNDEFINED_TABLE)
42P02 Undefined parameter (UNDEFINED_PARAMETER)
42704 Undefined object (UNDEFINED_OBJECT)
42701 Duplicate column (DUPLICATE_COLUMN)
42P03 Duplicate cursor (DUPLICATE_CURSOR)
42P04 Duplicate database (DUPLICATE_DATABASE)
42723 Duplicate function (DUPLICATE_FUNCTION)
42P05 Duplicate prepared statement (DUPLICATE_PREPARED_STATEMENT)
42P06 Duplicate schema (DUPLICATE_SCHEMA)
42P07 Duplicate table (DUPLICATE_TABLE)
42712 Duplicate alias (DUPLICATE_ALIAS)
42710 Duplicate object (DUPLICATE_OBJECT)
42702 Ambiguous column (AMBIGUOUS_COLUMN)
42725 Ambiguous function (AMBIGUOUS_FUNCTION)
42P08 Ambiguous parameter (AMBIGUOUS_PARAMETER)
42P09 Ambiguous alias (AMBIGUOUS_ALIAS)
42P10 Invalid column reference (INVALID_COLUMN_REFERENCE)
42611 Invalid column definition (INVALID_COLUMN_DEFINITION)
42P11 Invalid cursor definition (INVALID_CURSOR_DEFINITION)
42P12 Invalid database definition (INVALID_DATABASE_DEFINITION)
42P13 Invalid function definition (INVALID_FUNCTION_DEFINITION)
42P14 Invalid prepared statement definition (INVALID_PREPARED_STATEMENT_DEFINITION)
42P15 Invalid schema definition (INVALID_SCHEMA_DEFINITION)
42P16 Invalid table definition (INVALID_TABLE_DEFINITION)
42P17 Invalid object definition (INVALID_OBJECT_DEFINITION)
Class 44 - WITH CHECK option violation
44000 WITH CHECK option violation (WITH_CHECK_OPTION_VIOLATION)
Copyright © 2011-2024 www.enmotech.com All rights reserved.