5000 \~ 5999

更新时间：2023-08-07 17:30:32

此范围表示 SQL 层错误码。包含 SQL 错误码，WITH 子句错误码及 Factoring 错误码。

ERROR 5002 (HY000) : Resolve error

ERROR 5010 (21000) : Unknown operator

ERROR 5011 (42000) : Duplicated star

ERROR 5012 (HY000) : Illegal ID

ERROR 5014 (HY000) : Illegal value

ERROR 5016 (HY000) : Generate logical plan error

ERROR 5017 (HY000) : Schema not set

ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date.

ERROR 5031 (HY000) : Column not found

ERROR 5034 (01007) : No user

ERROR 5050 (42710) : User exists

ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld

ERROR 5058 (42000) : Duplicated parameters

ERROR 5063 (42000) : Unknown hint

ERROR 5066 (HY000) : Session interrupted

ERROR 5071 (42000) : Cannot alter index column

ERROR 5074 (23000) : NOP cannot be used here

ERROR 5081 (25000) : The server is read only now

ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s

ERROR 5084 (22000) : Can not cast varchar value to bool type

ERROR 5085 (22000) : Not a number Can not cast varchar value to number type

ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type

ERROR 5087 (22000) : Result value was out of range when cast to number

ERROR 5090 (22000) : Precision was out of range

ERROR 5091 (22000) : Scale value was out of range

ERROR 5092 (42000) : Unknown index

ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'

ERROR 5099 (42000) : System config unknown

ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument

ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s

ERROR 5108 (42000) : function LENGTH（) expected a varchar argument

ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument

ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument

ERROR 5112 (42P01) : Variable %.*s does not exists

ERROR 5114 (42000) : Invalid numeric char '%c'

ERROR 5116 (HY000) : Logical operator child index overflow

ERROR 5117 (HY000) : fail to explain plan

ERROR 5118 (HY000) : fail to copy logical operator

ERROR 5119 (HY000) : fail to generate plan

ERROR 5120 (HY000) : fail to create raw expr

ERROR 5121 (HY000) : fail to generate join order

ERROR 5122 (HY000) : optimizer general error

ERROR 5130 (HY000) : sql resolver no memory

ERROR 5131 (HY000) : plan cache support dml only

ERROR 5133 (42000) : No such grant defined

ERROR 5136 (HY000) : plan exists in plan cache already

ERROR 5137 (HY000) : plan is expired

ERROR 5138 (HY000) : no plan exist

ERROR 5144 (HY000) : COLLATION '%.s' is notvalid for CHARACTER SET '%.s'

ERROR 5150 (HY000) : Tenant not in this server

ERROR 5151 (42P01) : tablegroup not exist

ERROR 5156 (HY000) : tenant \'%s\' already exist

ERROR 5157 (HY000) : Unknown tenant '%.*s'

ERROR 5159 (HY000) : tablegroup already exist

ERROR 5160 (HY000) : invalid tenant name specified in connection string

ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key

ERROR 5223 (42000) : wrong ident name

ERROR 5226 (42000) : plan cache memory used reach the high water mark

ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement

ERROR 5235 (HY000) : The table \'%.s.%.s\' is read only so it cannot execute this statement

ERROR 5243 (HY000) : system variables' version maybe different

ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d

ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'

ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes

ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576

ERROR 5260 (HY000) : Tenant \'%.*s\' is locked

ERROR 5264 (HY000) : Outline '%.*s' already exists

ERROR 5265 (HY000) : Outline \'%.s.%.s\' doesn\'t exist

ERROR 5267 (HY000) : invalid outline ,error info:%s

ERROR 5268 (HY000) : SQL reach max concurrent num %ld

ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin

ERROR 5270 (HY000) : object not in RECYCLE BIN

ERROR 5272 (HY000) : Outline content '%.s' of outline '%.s' already exists when added

ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added

ERROR 5278 (HY000) : This partition value with incorrect charset type

ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list

ERROR 5296 (42000) : there has no readable replica

ERROR 5297 (HY000) : unexpected time zone info transition

ERROR 5298 (HY000) : synonym '%.*s' already exists

ERROR 5299 (HY000) : synonym \'%.s.%.s\' doesn\'t exist

ERROR 5300 (HY000) : missing ORDER BY expression in the window specification

ERROR 5301 (HY000) : The argument of the window function should be a constant for a partition

ERROR 5307 (HY000) : Scheduler thread number is not enough

ERROR 5309 (HY000) : Ignore sql in restore process

ERROR 5311 (HY000) : Invalid column id for %.*s

ERROR 5312 (HY000) : Duplicated ddl id '%.*s'

ERROR 5319 (HY000) : Child column \'%.s\' data length cannot be less than parent column \'%.s\' data length

ERROR 5320 (HY000) : \'%.*s\': used in a foreign key constraint

ERROR 5325 (HY000) : ORDER SIBLINGS BY clause not allowed here

ERROR 5326 (HY000) : when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

ERROR 5327 (HY000) : Database can not be specified in public synonym

ERROR 5328 (HY000) : Looping chain of synonyms

ERROR 5329 (HY000) : Cannot create a synonym with same name as object

ERROR 5330 (HY000) : Synonym %s translation is no longer valid

ERROR 5331 (HY000) : name is already used by an existing object

ERROR 5337 (HY000) : rowid is wrong

ERROR 5338 (HY000) : Window Function not allowed here

ERROR 5339 (HY000) : Fail to parse list partition

ERROR 5341 (HY000) : timezone region ID is invalid

ERROR 5342 (HY000) : invalid hex number

ERROR 5343 (42000) : wrong number or types of arguments in call to '%.*s'

ERROR 5345 (HY000) : insufficient parallel query worker available

ERROR 5346 (HY000) : FOR UPDATE of this query expression is not allowed

ERROR 5347 (HY000) : argument should be a function of expressions in PARTITION BY

ERROR 5348 (HY000) : result of string concatenation is too long

说明

有关该系统变量的详细信息，请参见 OceanBase 数据库官方文档的《参考指南（MySQL 模式）》中的系统变量章节。

ERROR 5350 (HY000) : updating partition key column would cause a partition change

ERROR 5351 (HY000) : invalid type given for an argument

ERROR 5352 (HY000) : specified field not found in datetime or interval

ERROR 5360 (HY000) : insufficient privileges

ERROR 5361 (HY000) : user %.*s lacks CREATE SESSION privilege; logon denied

ERROR 5363 (HY000) : system privileges not granted to '%.*s'

ERROR 5364 (HY000) : only SELECT and ALTER privileges are valid for sequences

ERROR 5365 (HY000) : EXECUTE privilege not allowed for tables

ERROR 5366 (HY000) : only EXECUTE and DEBUG privileges are valid for procedures

ERROR 5367 (HY000) : only EXECUTE, DEBUG, and UNDER privileges are valid for types

ERROR 5368 (HY000) : ADMIN option not granted for role '%.*s'

ERROR 5369 (HY000) : user or role '%.*s' does not exist

ERROR 5370 (HY000) : missing ON keyword

ERROR 5371 (HY000) : grant option does not exist for '%.s.%.s'

ERROR 5372 (HY000) : ALTER, INDEX and EXECUTE not allowed for views

ERROR 5373 (HY000) : circular role grant detected

ERROR 5374 (HY000) : invalid privilege on directories

ERROR 5375 (HY000) : directory access denied

ERROR 5376 (HY000) : missing or invalid role name

ERROR 5377 (HY000) : role '%.*s' not granted or does not exist

ERROR 5378 (HY000) : DEFAULT ROLE '%.*s' not granted to user

ERROR 5379 (HY000) : ROLE '%.s' not granted to '%.s'

ERROR 5380 (HY000) : cannot GRANT to a role WITH GRANT OPTION

ERROR 5381 (HY000) : duplicate username in list

ERROR 5382 (HY000) : cannot grant %.*s to a role

ERROR 5383 (HY000) : CASCADE CONSTRAINTS must be specified to perform this revoke

ERROR 5384 (HY000) : you may not GRANT/REVOKE privileges to/from yourself

ERROR 5401 (HY000) : resultant data type of virtual column is not supported

ERROR 5558 (42000) : %s \'%.s.%.s\' already exists

ERROR 5559 (42000) : %s \'%.s.%.s\' does not exist

ERROR 5561 (HY000) : Invalid use of window function

ERROR 5562 (HY000) : Duplicate constraint name '%.*s'

ERROR 5563 (HY000) : Constraint not found

ERROR 5564 (HY000) : Duplicate alter index operations on column \'%.*s\'

ERROR 5572 (HY000) : a partition may be split into exactly two new partitions

ERROR 5573 (HY000) : this physical attribute may not be specified for a table partition

ERROR 5574 (HY000) : missing VALUES keyword

ERROR 5575 (HY000) : missing AT or VALUES keyword

ERROR 5578 (HY000) : Plan cache lock conflict

ERROR 5597 (HY000) : last resulting partition cannot contain bounds

ERROR 5598 (HY000) : cannot add partition when DEFAULT partition exists

ERROR 5599 (HY000) : cannot split partition into one partition, use rename instead

ERROR 5600 (HY000) : can not create user %s in sys tenant, name %.*s

ERROR 5601 (HY000) : Percentage should between 1 and 99

ERROR 5603 (0A000) : Attempt to create, alter or drop an index on temporary table already in use

ERROR 5604 (HY000) : invalid NLS parameter string used in SQL function

ERROR 5605 (HY000) : datetime/interval precision is out of range

ERROR 5606 (42000) : Invalid number format model

ERROR 5607 (HY000) : SQL command not properly ended

ERROR 5608 (42000) : invalid number format model

ERROR 5613 (HY000) : too many values

ERROR 5614 (HY000) : not enough values

ERROR 5615 (HY000) : single-row subquery returns more than one row

ERROR 5616 (HY000) : UPDATE ... SET expression must be a subquery

ERROR 5617 (HY000) : inappropriate INTO

ERROR 5619 (HY000) : Column part of using clause can not have qualifier

ERROR 5623 (HY000) : outer join operator (+) not allowed in operand of OR or IN

ERROR 5624 (HY000) : a column may not be outer-joined to a subquery

ERROR 5625 (HY000) : old style outer join (+) cannot be used with ANSI joins

ERROR 5626 (HY000) : outer join operator (+) is not allowed here

ERROR 5627 (HY000) : Schema try again

ERROR 5628 (HY000) : zero-length columns are not allowed

ERROR 5629 (HY000) : year conflicts with Julian date

ERROR 5630 (HY000) : day of year conflicts with Julian date

ERROR 5631 (HY000) : month conflicts with Julian date

ERROR 5632 (HY000) : day of month conflicts with Julian date

ERROR 5633 (HY000) : day of week conflicts with Julian date

ERROR 5634 (HY000) : hour conflicts with seconds in day

ERROR 5635 (HY000) : minutes of hour conflicts with seconds in day

ERROR 5636 (HY000) : seconds of minute conflicts with seconds in day

ERROR 5637 (HY000) : date not valid for month specified

ERROR 5638 (HY000) : input value not long enough for date format

ERROR 5639 (HY000) : (full) year must be between -4713 and +9999, and not be 0

ERROR 5640 (HY000) : quarter must be between 1 and 4

ERROR 5641 (HY000) : not a valid month

ERROR 5642 (HY000) : not a valid day of the week

ERROR 5643 (HY000) : day of year must be between 1 and 365 (366 for leap year)

ERROR 5644 (HY000) : hour must be between 1 and 12

ERROR 5645 (HY000) : hour must be between 0 and 23

ERROR 5646 (HY000) : minutes must be between 0 and 59

ERROR 5647 (HY000) : seconds must be between 0 and 59

ERROR 5648 (HY000) : seconds in day must be between 0 and 86399

ERROR 5649 (HY000) : julian date must be between 1 and 5373484

ERROR 5650 (HY000) : AM/A.M. or PM/P.M. required

ERROR 5651 (HY000) : BC/B.C. or AD/A.D. required

ERROR 5652 (HY000) : format code appears twice

ERROR 5653 (HY000) : day of week may only be specified once

ERROR 5654 (HY000) : signed year precludes use of BC/AD

ERROR 5655 (HY000) : Julian date precludes use of day of year

ERROR 5656 (HY000) : year may only be specified once

ERROR 5657 (HY000) : hour may only be specified once

ERROR 5658 (HY000) : AM/PM conflicts with use of A.M./P.M.

ERROR 5659 (HY000) : BC/AD conflicts with use of B.C./A.D.

ERROR 5660 (HY000) : month may only be specified once

ERROR 5661 (HY000) : day of week may only be specified once

ERROR 5662 (HY000) : format code cannot appear in date input format

ERROR 5663 (HY000) : a non-numeric character was found where a numeric was expected

ERROR 5664 (HY000) : 'HH24' precludes use of meridian indicator

ERROR 5665 (HY000) : missing or illegal character following the escape character

ERROR 5666 (HY000) : escape character must be character string of length 1

ERROR 5667 (HY000) : day of month must be between 1 and last day of month

ERROR 5668 (HY000) : not a SELECTed expression

ERROR 5670 (HY000) : (full) year must be between -4713 and +9999, and not be 0

ERROR 5671 (HY000) : such unique or primary key already exists in the table

ERROR 5672 (HY000) : such column list already indexed

ERROR 5674 (HY000) : argument '%ld' is out of range

ERROR 5675 (HY000) : ORDER BY item must be the number of a SELECT-list expression

ERROR 5676 (HY000) : the interval is invalid

ERROR 5677 (HY000) : PL/SQL: numeric or value error: %.*s

ERROR 5678 (HY000) : name already used by an existing constraint

ERROR 5679 (HY000) : table must have at least one column that is not invisible

ERROR 5680 (HY000) : Invisible column is not supported on this type of table

ERROR 5681 (HY000) : Column visibility modifications cannot be combined with any other modified column DDL option

ERROR 5682 (HY000) : The visibility of a column from a table owned by a SYS user cannot be changed

ERROR 5683 (HY000) : too many arguments for function

ERROR 5684 (HY000) : PX sql need retry

ERROR 5685 (HY000) : Tenant '(string)' has been dropped

ERROR 5686 (HY000) : invalid extract field for extract source

ERROR 5687 (42000) : %s \'%.s.%.s\' compile error

ERROR 5690 (HY000) : subquery not allowed here

ERROR 5691 (HY000) : date or system variable wrongly specified in CHECK constraint

ERROR 5692 (HY000) : Cannot drop constraint - nonexistent constraint

ERROR 5693 (HY000) : check constraint violated

ERROR 5694 (HY000) : group function is not allowed here

ERROR 5695 (HY000) : policy string not found

ERROR 5696 (HY000) : invalid label string

ERROR 5697 (HY000) : undefined compartment string for policy string

ERROR 5698 (HY000) : undefined level string for policy string

ERROR 5699 (HY000) : undefined group string for policy string

ERROR 5700 (HY000) : LBAC error: %s

ERROR 5701 (HY000) : policy role already exists for policy string

ERROR 5702 (HY000) : NULL or invalid user label: %s

ERROR 5703 (HY000) : Add index failed

ERROR 5704 (HY000) : profile %.*s does not exist

ERROR 5705 (HY000) : invalid resource limit %s

ERROR 5706 (HY000) : profile %.*s already exists

ERROR 5707 (HY000) : profile %.*s has users assigned, cannot drop without CASCADE

ERROR 5708 (HY000) : the leading precision of the interval is too small

ERROR 5709 (HY000) : time zone hour must be between -12 and 14

ERROR 5710 (HY000) : time zone minute must be between -59 and 59

ERROR 5711 (HY000) : not a valid time zone

ERROR 5712 (HY000) : date format is too long for internal buffer

ERROR 5713 (HY000) : cannot validate (%.s.%.s) - check constraint violated

ERROR 5714 (HY000) : data manipulation operation not legal on this view

ERROR 5715 (HY000) : virtual column not allowed here

ERROR 5716 (HY000) : cannot modify more than one base table through a join view

ERROR 5721 (HY000) : cannot delete from view without exactly one key-preserved table

ERROR 5722 (HY000) : cannot modify a column which maps to a non key-preserved table

ERROR 5723 (HY000) : cannot perform a DML operation on a read-only view

ERROR 5724 (HY000) : invalid INITRANS option value

ERROR 5725 (HY000) : invalid MAXTRANS option value

ERROR 5726 (HY000) : invalid value for PCTFREE or PCTUSED

ERROR 5728 (HY000) : illegal argument for function

ERROR 5729 (HY000) : this operator cannot be used with lists

ERROR 5730 (HY000) : SAMPLE percentage must be in the range [0.000001,100)

ERROR 5731 (HY000) : specifying owner's name of the table is not allowed

ERROR 5732 (HY000) : stmt trigger with when clause

ERROR 5732 (HY000) : not enough arguments for function

ERROR 5733 (HY000) : trigger '%.*s' does not exist

ERROR 5734 (HY000) : trigger '%.*s' already exist

ERROR 5735 (HY000) : trigger '%.*s' already exists on another table, cannot replace it

ERROR 5736 (HY000) : error signaled in parallel query server

ERROR 5763 (HY000) : Specified pseudo column or operator not allowed here

ERROR 5764 (HY000) : CONNECT BY loop in user data

ERROR 5765 (HY000) : cannot have join with CONNECT BY

ERROR 5766 (HY000) : CONNECT BY clause required in this query block

ERROR 5768 (HY000) : SYS_CONNECT_BY_PATH function is not allowed here

ERROR 5769 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function

ERROR 5770 (HY000) : A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values

ERROR 5771 (HY000) : CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition

ERROR 5772 (HY000) : ORDER SIBLINGS BY clause not allowed here

ERROR 5773 (HY000) : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column

ERROR 5774 (HY000) : not enough arguments for function

ERROR 5777 (HY000) : Prepare statement checksum error

ERROR 5778 (HY000) : cannot enable constraint (%.*s) - no such constraint

ERROR 5779 (HY000) : cannot disable constraint (%.*s) - no such constraint

ERROR 5780 (HY000) : PX DOP downgrade from %ld to %ld

ERROR 5781 (HY000) : parallel_max_servers downgrade due to insufficent cpu resource from %ld to %ld

ERROR 5785 (HY000) : cannot validate (%.s.%.s) - parent keys not found

ERROR 5786 (HY000) : Column check constraint cannot reference other columns

ERROR 5787 (HY000) : batched multi statement execution needs rollback

ERROR 5788 (HY000) : cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc.

ERROR 5789 (HY000) : policy with check option violation

ERROR 5790 (HY000) : policy already applied to table

ERROR 5791 (HY000) : table '%.s'.'%.s' is mutating, trigger/function may not see it

ERROR 5792 (HY000) : column is referenced in a multi-column constraint

ERROR 5793 (HY000) : cannot drop parent key column

ERROR 5794 (HY000) : auto increment service busy

ERROR 5795 (HY000) : No insert/update/delete on table with constraint (%.s.%.s) disabled and validated

ERROR 5796 (HY000) : active autonomous transaction detected and rolled back

ERROR 5797 (HY000) : ORDER BY not allowed here

ERROR 5798 (HY000) : DISTINCT not allowed here

ERROR 5799 (HY000) : assign user variable with := only allowed in select filed list and as root expression

ERROR 5800 (HY000) : cannot modify constraint (%.*s) - no such constraint

ERROR 5801 (HY000) : implementation restriction: exception handler in nested transaction is illegal

ERROR 5802 (HY000) : invalid ROWID

ERROR 5803 (HY000) : Invalid column in the INSERT VALUES Clause:'%.s'.'%.s'

ERROR 5804 (HY000) : incorrect use of the ['%.*s'] operator

ERROR 5805 (HY000) : non-constant expression is not allowed for pivot|unpivot values

ERROR 5806 (HY000) : expect aggregate function inside pivot operation

ERROR 5807 (HY000) : expression must have same datatype as corresponding expression

ERROR 5808 (HY000) : character set mismatch

ERROR 5809 (HY000) : regular expression failed to match

ERROR 5810 (HY000) : invalid regular expression (reg version 0.8)

ERROR 5811 (HY000) : invalid escape \\ sequence in regular expression

ERROR 5812 (HY000) : unmatched bracket in regular expression

ERROR 5813 (HY000) : unmatched parentheses in regular expression

ERROR 5814 (HY000) : invalid back reference in regular expression

ERROR 5815 (HY000) : invalid range in regular expression

ERROR 5816 (HY000) : invalid character class in regular expression

ERROR 5817 (HY000) : invalid collation class in regular expression

ERROR 5818 (HY000) : braces {} not balanced in in regular expression

ERROR 5819 (HY000) : invalid repetition count(s) in regular expression

ERROR 5820 (HY000) : The regular expression was too complex and current library can't be parsed

ERROR 5821 (HY000) : regular expression internal error

ERROR 5822 (HY000) : invalid argument in regular expression

ERROR 5823 (HY000) : character widths of regex and string differ in regular expression

ERROR 5824 (HY000) : invalid embedded option in regular expression

ERROR 5825 (HY000) : nfa has too many states in regular expression, may be the regular expression too long

ERROR 5827 (HY000) : the definition of relative objects have been modified, please check and retry

ERROR 5828 (HY000) : Subscript beyond count

ERROR 5829 (HY000) : PARTITION () clause on non partitioned table

ERROR 5830 (HY000) : Unknown subpartition

ERROR 5831 (HY000) : Invalid SQL ROW LIMITING expression was specified

ERROR 5833 (HY000) : not implemented in SQL static typing engine

ERROR 5834 (HY000) : name is already used by an existing object

ERROR 5835 (HY000) : connection description for remote database not found

ERROR 5836 (HY000) : database link not found

ERROR 5837 (HY000) : Reference to uninitialized composite

ERROR 5838 (HY000) : Reference to uninitialized collection

ERROR 5839 (HY000) : no more rows needed

ERROR 5840 (HY000) : PL/SQL: program error

ERROR 5841 (HY000) : PL/SQL: Return types of Result Set variables or query do not match

ERROR 5842 (HY000) : PL/SQL: storage error

ERROR 5843 (HY000) : Subscript outside of limit

ERROR 5844 (HY000) : invalid cursor

ERROR 5845 (HY000) : invalid username/password; logon denied

ERROR 5846 (HY000) : not logged on

ERROR 5847 (HY000) : method dispatch on NULL SELF argument is disallowed

ERROR 5848 (HY000) : timeout occurred while waiting for a resource

ERROR 5849 (HY000) : column to be modified to NOT NULL is already NOT NULL

ERROR 5850 (HY000) : column to be modified to NULL cannot be modified to NULL

ERROR 5851 (HY000) :cannot enable (%.s.%.s) - null values found

ERROR 5852 (HY000) : Argument should be a constant

ERROR 5853 (HY000) : not a single-group group function

ERROR 5854 (HY000) : illegal zero-length identifier

ERROR 5855 (HY000) : parameter cannot be modified because specified value is invalid

ERROR 5856 (HY000) : DBMS_SQL access denied

ERROR 5857 (HY000) : not all variables bound

ERROR 5859 (HY000) : column is referenced in a multi-column constraint

ERROR 5860 (HY000) : cannot modify column datatype with current constraint(s)

ERROR 5861 (HY000) : The percentile value should be a number between 0 and 1

ERROR 5862 (HY000) : The argument should be of numeric or date/datetime type

ERROR 5863 (HY000) : ALTER TABLE|INDEX RENAME may not be combined with other operations

ERROR 5864 (HY000) : only simple column names allowed here

ERROR 5866 (HY000) : cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)

ERROR 5867 (HY000) :Duplicate partition name %.*s

ERROR 5868 (HY000) : Incorrect usage of UPDATE and ORDER BY

ERROR 5869 (HY000) : Incorrect usage of UPDATE and LIMIT

ERROR 5870 (HY000) : rowid type mismatch, expect %.s, got %.s

ERROR 5871 (HY000) : rowid num mismatch, expect %ld, actual %ld

ERROR 5872 (HY000) :must name %.*s with a column alias

ERROR 5873 (HY000) : the numeric value does not match the length of the format item

ERROR 5874 (HY000) : invalid datatype

ERROR 5875 (HY000) : table is not partitioned by composite partition method

ERROR 5876 (HY000) : VALUES IN (<value list>) cannot be used for Range subpartitioned tables

ERROR 5877 (HY000) : VALUES IN (<value list>) clause expected

ERROR 5878 (HY000) : VALUES LESS THAN or AT clause cannot be used with List partitioned tables

ERROR 5879 (HY000) : Expecting VALUES LESS THAN or AT clause

ERROR 5880 (HY000) : procedure, function, package, or package body does not exist

ERROR 5882 (HY000) : invalid time limit specified

ERROR 5883 (HY000) : error(s) in array DML

ERROR 5884 (42000) : %s \'%.s.%.s\' compile error

ERROR 5887 (HY000) : missing or invalid password(s)

ERROR 5889 (HY000) : no matching unique or primary key for this column-list

ERROR 5890 (HY000) : duplicate referential constraint specifications

ERROR 5891 (HY000) : such a referential constraint already exists in the table

ERROR 5893 (HY000) : specified data type is not supported for a virtual column

ERROR 5894 (HY000) : referenced table does not have a primary key

ERROR 5895 (HY000) : data type or length of a table partitioning column may not be changed

ERROR 5896 (HY000) : data type or length of a table partitioning column may not be changed

ERROR 5897 (HY000) : cannot decrease column length because some value is too big

ERROR 5898 (HY000) : Datetime/Interval internal error

ERROR 5899 (HY000) : partition extended table name cannot refer to a remote object

ERROR 5901 ( HY000 ) : a view is not appropriate here

ERROR 5902 (HY000) : cannot select ROWID from,or sample, a join view without a key-preserved table

ERROR 5903 (HY000) : cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc

ERROR 5904 (HY000) : table must have at least 1 column that is not virtual

ERROR 5905 (HY000) : only pure functions can be indexed

ERROR 5906 (HY000) : only pure functions can be specified in a virtual column expression

ERROR 5907 (HY000) : UPDATE operation disallowed on virtual columns

ERROR 5908 (HY000) : Invalid column expression was specified

ERROR 5909 (HY000) : table can have only one identity column

ERROR 5910 (HY000) : invalid NOT NULL constraint specified on an identity column

ERROR 5911 (HY000) : cannot modify NOT NULL constraint on an identity column）

ERROR 5912 (HY000) : cannot drop NOT NULL constraint on an identity column

ERROR 5913 (HY000) : column to be modified is not an identity column

ERROR 5914 (HY000) : identity column cannot have a default value

ERROR 5915 (HY000) : identity column must be a numeric type

ERROR 5916 (HY000) : prebuilt table managed column cannot be an identity column

ERROR 5917 (HY000) : cannot alter a system-generated sequence

ERROR 5918 (HY000) : cannot drop a system-generated sequence

ERROR 5919 (HY000)：cannot insert into a generated always identity column

ERROR 5920 (HY000) : cannot update a generated always identity column

ERROR 5921 (HY000) : identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION

ERROR 5922 (HY000) : cannot rename a system-generated sequence

ERROR 5923 (HY000) : UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

ERROR 5924 (HY000) : not executed, type body '%.*s' does not exist

ERROR 5925 (HY000) : The argument [%s] of WIDTH_BUCKET function is NULL or invalid.

ERROR 5926 (HY000) : Not enough memory for CONNECT BY operation

ERROR 5927 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function

ERROR 5928 (HY000) : host %.*s unknown

ERROR 5929 (HY000) : Window name '%.*s' is not defined.

ERROR 5930 (HY000) : maximum open cursors exceeded

ERROR 5931 (HY000) : argument is null, invalid, or out of range

ERROR 5932 (HY000) : unexpected name string

ERROR 5933 (HY000) : PL/SQL: could not findprogram unit being called: '%.*s'

ERROR 5934 (HY000) : fetch out of sequence

说明

PL 游标循环隐式地进行提取，也可能导致此错误。

ERROR 5976 (HY000) : Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s

5000 \~ 5999

ERROR 5002 (HY000) : Resolve error

ERROR 5010 (21000) : Unknown operator

ERROR 5011 (42000) : Duplicated star

ERROR 5012 (HY000) : Illegal ID

ERROR 5014 (HY000) : Illegal value

ERROR 5016 (HY000) : Generate logical plan error

ERROR 5017 (HY000) : Schema not set

ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date.

ERROR 5031 (HY000) : Column not found

ERROR 5034 (01007) : No user

ERROR 5050 (42710) : User exists

ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld

ERROR 5058 (42000) : Duplicated parameters

ERROR 5063 (42000) : Unknown hint

ERROR 5066 (HY000) : Session interrupted

ERROR 5071 (42000) : Cannot alter index column

ERROR 5074 (23000) : NOP cannot be used here

ERROR 5081 (25000) : The server is read only now

ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s

ERROR 5084 (22000) : Can not cast varchar value to bool type

ERROR 5085 (22000) : Not a number Can not cast varchar value to number type

ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type

ERROR 5087 (22000) : Result value was out of range when cast to number

ERROR 5090 (22000) : Precision was out of range

ERROR 5091 (22000) : Scale value was out of range

ERROR 5092 (42000) : Unknown index

ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'

ERROR 5099 (42000) : System config unknown

ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument

ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s

ERROR 5108 (42000) : function LENGTH（) expected a varchar argument

ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument

ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument

ERROR 5112 (42P01) : Variable %.*s does not exists

ERROR 5114 (42000) : Invalid numeric char '%c'

ERROR 5116 (HY000) : Logical operator child index overflow

ERROR 5117 (HY000) : fail to explain plan

ERROR 5118 (HY000) : fail to copy logical operator

ERROR 5119 (HY000) : fail to generate plan

ERROR 5120 (HY000) : fail to create raw expr

ERROR 5121 (HY000) : fail to generate join order

ERROR 5122 (HY000) : optimizer general error

ERROR 5130 (HY000) : sql resolver no memory

ERROR 5131 (HY000) : plan cache support dml only

ERROR 5133 (42000) : No such grant defined

ERROR 5136 (HY000) : plan exists in plan cache already

ERROR 5137 (HY000) : plan is expired

ERROR 5138 (HY000) : no plan exist

ERROR 5144 (HY000) : COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'

ERROR 5150 (HY000) : Tenant not in this server

ERROR 5151 (42P01) : tablegroup not exist

ERROR 5156 (HY000) : tenant \'%s\' already exist

ERROR 5157 (HY000) : Unknown tenant '%.*s'

ERROR 5159 (HY000) : tablegroup already exist

ERROR 5160 (HY000) : invalid tenant name specified in connection string

ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key

ERROR 5223 (42000) : wrong ident name

ERROR 5226 (42000) : plan cache memory used reach the high water mark

ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement

ERROR 5235 (HY000) : The table \'%.*s.%.*s\' is read only so it cannot execute this statement

ERROR 5243 (HY000) : system variables' version maybe different

ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d

ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'

ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes

ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576

ERROR 5260 (HY000) : Tenant \'%.*s\' is locked

ERROR 5264 (HY000) : Outline '%.*s' already exists

ERROR 5265 (HY000) : Outline \'%.*s.%.*s\' doesn\'t exist

ERROR 5267 (HY000) : invalid outline ,error info:%s

ERROR 5268 (HY000) : SQL reach max concurrent num %ld

ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin

ERROR 5270 (HY000) : object not in RECYCLE BIN

ERROR 5272 (HY000) : Outline content '%.*s' of outline '%.*s' already exists when added

ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added

ERROR 5278 (HY000) : This partition value with incorrect charset type

ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list

ERROR 5296 (42000) : there has no readable replica

ERROR 5297 (HY000) : unexpected time zone info transition

ERROR 5298 (HY000) : synonym '%.*s' already exists

ERROR 5144 (HY000) : COLLATION '%.s' is notvalid for CHARACTER SET '%.s'

ERROR 5235 (HY000) : The table \'%.s.%.s\' is read only so it cannot execute this statement

ERROR 5265 (HY000) : Outline \'%.s.%.s\' doesn\'t exist

ERROR 5272 (HY000) : Outline content '%.s' of outline '%.s' already exists when added

ERROR 5299 (HY000) : synonym \'%.s.%.s\' doesn\'t exist

ERROR 5319 (HY000) : Child column \'%.s\' data length cannot be less than parent column \'%.s\' data length

ERROR 5371 (HY000) : grant option does not exist for '%.s.%.s'

ERROR 5379 (HY000) : ROLE '%.s' not granted to '%.s'

ERROR 5558 (42000) : %s \'%.s.%.s\' already exists

ERROR 5559 (42000) : %s \'%.s.%.s\' does not exist