This error code range indicates compatibility with MySQL error codes.
ERROR 1007 (HY000) : Can't create database '%s'; database exists
OceanBase error code: 5158
Compatible MySQL error code: 1007
ERROR 1008 (HY000) : Can't drop database '%.*s'; database doesn't exist
OceanBase error code: 5166
Compatible MySQL error code: 1008
ERROR 1017 (HY000) : File not exist
OceanBase error code: 4027
Compatible MySQL error code: 1017
ERROR 1018 (HY000) : Directory not exist
OceanBase error code: 4066
Compatible MySQL error code: 1018
ERROR 1022 (23000) : Can't write; duplicate key in table \'%.*s\'
OceanBase error code: 5595
Compatible MySQL error code: 1022
ERROR 1025 (HY000) : ## ERROR on rename of \'%s.%s\' to \'%s.%s\'
OceanBase error code: 5215
Compatible MySQL error code: 1025
ERROR 1040 (08004) : Too many connections
OceanBase error code: 5271
Compatible MySQL error code: 1040
ERROR 1041 (53000) : Out of resource
OceanBase error code: 4153
Compatible MySQL error code: 1041
ERROR 1044 (42000) : Access denied for user '%.*s'@'%.*s' to database '%.*s'
OceanBase error code: 5170
Compatible MySQL error code: 1044
ERROR 1045 (42000) : Access denied for user '%.*s'@'%.*s' (using password: %s)
OceanBase error code: 4043
Compatible MySQL error code: 1045
ERROR 1046 (3D000) : No database selected
OceanBase error code: 5134
Compatible MySQL error code: 1046
ERROR 1047 (HY001) : Unknown packet
OceanBase error code: 4118
Compatible MySQL error code: 1047
ERROR 1048 (23000) : Column '%.*s' cannot be null
OceanBase error code: 4235
Compatible MySQL error code: 1048
ERROR 1049 (42000) : Unknown database '%.*s'
OceanBase error code: 5154
Compatible MySQL error code: 1049
ERROR 1050 (42S01) : Table '%.*s' already exists
OceanBase error code: 5020
Compatible MySQL error code: 1050
ERROR 1051 (42S02) : Unknown table '%.*s'
OceanBase error code: 5201
Compatible MySQL error code: 1051
ERROR 1052 (23000) : Column '%.*s' in %.*s is ambiguous
OceanBase error code: 5207
Compatible MySQL error code: 1052
ERROR 1054 (42S22) : Unknown column '%.*s' in '%.*s'
OceanBase error code: 5217
Compatible MySQL error code: 1054
ERROR 1055 (42000) : \'%.*s\' is not in GROUP BY
OceanBase error code: 5218
Compatible MySQL error code: 1055
ERROR 1056 (42000) : Can't group on '%.*s'
OceanBase error code: 5206
Compatible MySQL error code: 1056
ERROR 1059 (42000) : Identifier name \'%.*s\' is too long
OceanBase error code: 5179, 9526
Compatible MySQL error code: 1059
ERROR 1060 (42S21) : Duplicate column group name '%.*s'
OceanBase error code: 5404
Compatible MySQL error code: 1060
ERROR 1061 (42000) : Duplicate key name \'%.*s\'
OceanBase error code: 5025
Compatible MySQL error code: 1061
ERROR 1062 (23000) : Duplicate entry \'%s\' for key \'%.*s\'
OceanBase error code: 5024
Compatible MySQL error code: 1062
ERROR 1063 (42000) : Incorrect column specifier for column '%.*s'
OceanBase error code: 5165
Compatible MySQL error code: 1063
ERROR 1064 (0B000) : Failed to init SQL parser
OceanBase error code: 5000
Compatible MySQL error code: 1064
ERROR 1064 (42000) : Parse error", "%s near \'%.*s\' at line %d
OceanBase error code: 5001
Compatible MySQL error code: 1064
ERROR 1064 (42000) : Wrong number of partitions defined, mismatch with previous setting
OceanBase error code: 5282
Compatible MySQL error code: 1064
ERROR 1065 (42000) : Query was empty
OceanBase error code: 5253
Compatible MySQL error code: 1065
ERROR 1066 (42000) : Not unique table/alias: \'%.*s\'
OceanBase error code: 5208
Compatible MySQL error code: 1066
ERROR 1067 (42000) : Invalid default value for \'%.*s\'
OceanBase error code: 5173
Compatible MySQL error code: 1067
ERROR 1068 (42000) : Multiple primary key defined
OceanBase error code: 5210
Compatible MySQL error code: 1068
ERROR 1069 (42000) : Too many keys specified; max %ld keys allowed
OceanBase error code: 5194
Compatible MySQL error code: 1069
ERROR 1070 (42000) : Too many key parts specified; max %ld parts allowed
OceanBase error code: 5195
Compatible MySQL error code: 1070
ERROR 1071 (42000) : Specified key was too long; max key length is %ld bytes
OceanBase error code: 5196
Compatible MySQL error code: 1071
ERROR 1072 (42000) : Key column '%.*s' doesn't exist in table
OceanBase error code: 5211
Compatible MySQL error code: 1072
ERROR 1074 (42000) : Column length too big for column '%s' (max = %d)
OceanBase error code: 5198
Compatible MySQL error code: 1074
ERROR 1074 (42000) : Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead
OceanBase error code: 9577
Compatible MySQL error code: 1074
ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column
OceanBase error code: 5193
Compatible MySQL error code: 1075
ERROR 1078 (01000) : (string):%s: Got signal %d. Aborting
OceanBase error code: 4662
Compatible MySQL error code: 1078
ERROR 1082 (42S12) : Illegal index
OceanBase error code: 5028
Compatible MySQL error code: 1082
ERROR 1082 (42000) : Index unavailable
OceanBase error code: 5073
Compatible MySQL error code: 1082
ERROR 1083 (42000) : Field separator argument is not what is expected; check the manual
OceanBase error code: 5295
Compatible MySQL error code: 1083
ERROR 1083 (HY000) : Non-ASCII separator arguments are not fully supported
OceanBase error code: 5609
Compatible MySQL error code: 1083
ERROR 1083 (HY000) : First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
OceanBase error code: 5610
Compatible MySQL error code: 1083
ERROR 1086 (58000) : File already exist
OceanBase error code: 4117
Compatible MySQL error code: 1086
ERROR 1089 (HY000) : Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
OceanBase error code: 5190
Compatible MySQL error code: 1089
ERROR 1090 (42000) : You can't delete all columns with ALTER TABLE; use DROP TABLE instead
OceanBase error code: 5187
Compatible MySQL error code: 1090
ERROR 1091 (42000) : Can't DROP '%.*s'; check that column/key exists
OceanBase error code: 5209
Compatible MySQL error code: 1091
ERROR 1093 (HY000) : You can\'t specify target table \'%s\' for update in FROM clause
OceanBase error code: 5174
Compatible MySQL error code: 1093
ERROR 1094 (HY000) : Unknown thread id: %lu
OceanBase error code: 4174
Compatible MySQL error code: 1094
ERROR 1095 (HY000) : You are not owner of thread %lu
OceanBase error code: 5251
Compatible MySQL error code: 1095
ERROR 1096 (HY000) : No tables used
OceanBase error code: 5185
Compatible MySQL error code: 1096
ERROR 1097 (HY000) : Too many strings for column %.*s and SET
OceanBase error code: 5336
Compatible MySQL error code: 1097
ERROR 1101 (42000) : BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value
OceanBase error code: 5430
Compatible MySQL error code: 1101
ERROR 1102 (42000) : Incorrect database name '%.*s'
OceanBase error code: 5162
Compatible MySQL error code: 1102
ERROR 1103 (42000) : Incorrect table name '%.*s'
OceanBase error code: 5163
Compatible MySQL error code: 1103
ERROR 1105 (42000) : invalid xpath expression
OceanBase error code: 7404
Compatible MySQL error code: 1105
Cause: The XPath expression is incorrectly formatted or invalid.
Solution: Check the XPath expression and verify that the XML data is correct.
ERROR 1105 (42000) : Given XPATH expression not supported
OceanBase error code: 7409
Compatible MySQL error code: 1105
Cause: The XPath expression is not supported.
Solution: Check whether the XPath expression used is correct and whether the database version supports using this XPath expression.
ERROR 1108 (HY000) : Incorrect parameters to procedure '%.*s'
OceanBase error code: 5406
Compatible MySQL error code: 1108
ERROR 1109 (42S02) : Unknown table '%.*s' in %.*s
OceanBase error code: 5200
Compatible MySQL error code: 1109
ERROR 1110 (42000) : Column \'%s\' specified twice
OceanBase error code: 4228
Compatible MySQL error code: 1110
ERROR 1111 (HY000) : Invalid use of group function
OceanBase error code: 5176
Compatible MySQL error code: 1111
ERROR 1113 (42000) : A table must have at least 1 column
OceanBase error code: 5904
Compatible MySQL error code: 1113
ERROR 1115 (42000) : Unknown character set: '%.*s'
OceanBase error code: 5142
Compatible MySQL error code: 1115
ERROR 1117 (42000) : Too many columns
OceanBase error code: 5197
Compatible MySQL error code: 1117
ERROR 1118 (42000) : Row size too large
OceanBase error code: 5199
Compatible MySQL error code: 1118
ERROR 1122 (HY000) : Can not load function %s
OceanBase error code: 4291
Compatible MySQL error code: 1122
ERROR 1123 (HY000) : Can not initialize function '%.*s'
OceanBase error code: 4292
Compatible MySQL error code: 1123
ERROR 1124 (HY000) : No paths allowed for shared library
OceanBase error code: 4293
Compatible MySQL error code: 1124
ERROR 1125 (HY000) : Function %.*s already exists
OceanBase error code: 4294
Compatible MySQL error code: 1125
ERROR 1126 (HY000) : Can not open shared library '%.*s'
OceanBase error code: 4295
Compatible MySQL error code: 1126
ERROR 1127 (HY000) : Can't find symbol %.*s in library
OceanBase error code: 4296
Compatible MySQL error code: 1127
ERROR 1028 (HY000) : Function %.*s is not defined
OceanBase error code: 9203
Compatible MySQL error code: 1128
Cause: The corresponding plugin feature is not available. This usually occurs because the plugin is not installed or initialization failed.
Solution: Check whether the plugin is correctly installed and initialized.
ERROR 1133 (42000) : Can not find any matching row in the user table'%.*s'
OceanBase error code: 4042
Compatible MySQL error code: 1133
ERROR 1133 (42000) : Incorrect password
OceanBase error code: 5038
Compatible MySQL error code: 1133
ERROR 1136 (21S01) : column count does not match value count at row '%d'
OceanBase error code: 5168
Compatible MySQL error code: 1136
ERROR 1136 (21S01) : Column count doesn\'t match value count at row %ld
OceanBase error code: 5175
Compatible MySQL error code: 1136
ERROR 1138 (22004) : Invalid use of NULL value
OceanBase error code: 5596
Compatible MySQL error code: 1138
ERROR 1139 (42000) : Got error '%s' from regexp
OceanBase error code: 5115
Compatible MySQL error code: 1139
ERROR 1140 (42000) : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
OceanBase error code: 5221
Compatible MySQL error code: 1140
ERROR 1141 (HY000) : There is no such grant defined for user '%.*s' on host '%.*s'
OceanBase error code: 11008
Compatible MySQL error code: 1141
Cause: The grant is not defined for user '%.*s' on host '%.*s'.
Solution: Ensure that user '%.*s' on host '%.*s' has the correct grant and that the grant is correctly defined.
ERROR 1142 (42000) : %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'
OceanBase error code: 5171
Compatible MySQL error code: 1142
ERROR 1144 (42000) : Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
OceanBase error code: 5183
Compatible MySQL error code: 1144
ERROR 1146 (42S02) : Table \'%s.%s\' doesn\'t exist
OceanBase error code: 5019
Compatible MySQL error code: 1146
ERROR 1149 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use
OceanBase error code: 5006
Compatible MySQL error code: 1149
ERROR 1153 (08S01) : Got a packet bigger than \'max_allowed_packet\' bytes"
OceanBase error code: 4254
Compatible MySQL error code: 1153
ERROR 1166 (42000) : Incorrect column name '%.*s'
OceanBase error code: 5164
Compatible MySQL error code: 1166
ERROR 1167 (42000) : The used storage engine can't index column '%.*s'
OceanBase error code: 5216
Compatible MySQL error code: 1167
ERROR 1171 (42000) : Insert null into %.*s
OceanBase error code: 5030
Compatible MySQL error code: 1171
ERROR 1171 (42000) : All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
OceanBase error code: 5256
Compatible MySQL error code: 1171
ERROR 1172 (42000) : Result consisted of more than one row
OceanBase error code: 5294
Compatible MySQL error code: 1172
ERROR 1173 (42000) : Primary key columns) not specified in the WHERE clause
OceanBase error code: 5047
Compatible MySQL error code: 1173
ERROR 1175 (HY000) : You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
OceanBase error code: 5865
Compatible MySQL error code: 1175
ERROR 1176 (42000) : Key '%.*s' doesn't exist in table '%.*s'
OceanBase error code: 5289
Compatible MySQL error code: 1176
ERROR 1192 (HY000) : Can't execute the given command because you have active locked tables or an active transaction
OceanBase error code: 5236
Compatible MySQL error code: 1192
ERROR 1193 (HY000) : Unknown system variable '%.*s'
OceanBase error code: 5044
Compatible MySQL error code: 1193
ERROR 1203 (42000) : Too many sessions
OceanBase error code: 5059
Compatible MySQL error code: 1203
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
OceanBase error code: 6003
Compatible MySQL error code: 1205
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
OceanBase error code: 6006
Compatible MySQL error code: 1205
ERROR 1210 (HY000) : Incorrect arguments to %s
OceanBase error code: 4002
Compatible MySQL error code: 1210
ERROR 1210 (HY000) : Miss argument for %s
OceanBase error code: 4272
Compatible MySQL error code: 1210
ERROR 1210 (HY000) : Miss argument for %s
OceanBase error code: 4277
Compatible MySQL error code: 1210
ERROR 1213 (HY000) : Deadlock
OceanBase error code: 4101
Compatible MySQL error code: 1213
ERROR 1215 (HY000) : Cannot add foreign key constraint
OceanBase error code: 5317
Compatible MySQL error code: 1215
ERROR 1221 (HY000) : Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
OceanBase error code: 5182
Compatible MySQL error code: 1221
ERROR 1221 (HY000) : Incorrect usage of UNION and INTO
OceanBase error code: 9641
Compatible MySQL error code: 1221
ERROR 1222 (21000) : The used SELECT statements have a different number of columns
OceanBase error code: 5007
Compatible MySQL error code: 1222
ERROR 1225 (HY000) : Option '%s' used twice in statement
OceanBase error code: 4299
Compatible MySQL error code: 1225
ERROR 1226 (42000) : User '%.*s' has exceeded the '%s' resource (current value: %lu)
OceanBase error code: 5967
Compatible MySQL error code: 1226
ERROR 1227 (42501) : Access denied; you need (at least one of) the %s privilege(s) for this operation
OceanBase error code: 5036
Compatible MySQL error code: 1227
ERROR 1228 (HY000) : Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL
OceanBase error code: 5100
Compatible MySQL error code: 1228
ERROR 1229 (HY000) : Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL
OceanBase error code: 5101
Compatible MySQL error code: 1229
ERROR 1230 (42000) : Variable '%.*s' doesn't have a default value
OceanBase error code: 4256
Compatible MySQL error code: 1230
ERROR 1231 (42000) : Variable \'%.*s\' can't be set to the value of \'%.*s\'
OceanBase error code: 5145
Compatible MySQL error code: 1231
ERROR 1232 (42000) : Incorrect argument type to variable '%.*s'
OceanBase error code: 5180
Compatible MySQL error code: 1232
ERROR 1234 (42000) : Incorrect usage/placement of '%s'
OceanBase error code: 5213
Compatible MySQL error code: 1234
ERROR 1235 (0A000) : %s not supported
OceanBase error code: 4007
Compatible MySQL error code: 1235
ERROR 1235 (42000) : This version of MySQL doesn't yet support 'non-string DEFAULT value for a column in a JSON_TABLE expression'
OceanBase error code: 5517
Compatible MySQL error code: 1235
Cause: The current version does not support specifying a non-string default value for a column in a JSON_TABLE expression.
Solution: Upgrade to the latest version that supports this feature or modify the column's default value to a string type.
ERROR 1235 (42000) : This version doesn't yet support 'references in JSON Schema.
OceanBase error code: 6284
Compatible MySQL error code: 1235
Cause: Indicates that the current version does not support using references in JSON mode.
Solution: Modify the design of JSON mode to avoid using references.
ERROR 1235 (42000) : This version of OceanBase doesn't yet support 'multiple triggers with the same action time and event for one table'
OceanBase error code: 9581
Compatible MySQL error code: 1235
ERROR 1238 (HY000) : Variable '%.*s' is a %.*s variable
OceanBase error code: 5103
Compatible MySQL error code: 1238
ERROR 1239 (42000) : Incorrect foreign key definition: Key reference and table reference don't match
OceanBase error code: 5318
Compatible MySQL error code: 1239
ERROR 1241 (21000) : Operand should contain %ld column(s)
OceanBase error code: 5042
Compatible MySQL error code: 1241
ERROR 1243 (HY007) : statement not prepared, stmt_id=%u
OceanBase error code: 5043
Compatible MySQL error code: 1243
ERROR 1242 (21000) : Subquery returns more than 1 row
OceanBase error code: 5153
Compatible MySQL error code: 1242
ERROR 1243 (HY000) : Unknown prepared statement handle
OceanBase error code: 5560
Compatible MySQL error code: 1243
ERROR 1247 (42S22) : Reference '%.*s' not supported (reference to group function)
OceanBase error code: 5225
Compatible MySQL error code: 1247
ERROR 1250 (42000) : Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause
OceanBase error code: 5238
Compatible MySQL error code: 1250
ERROR 1252 (7280) : All parts of a SPATIAL index must be NOT NULL.
OceanBase error code: 5238
Compatible MySQL error code: 1252
ERROR 1253 (42000) : COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'
OceanBase error code: 5144
Compatible MySQL error code: 1253
ERROR 1259 (HY000) : ZLIB: Input data corrupted
OceanBase error code: 5124
Compatible MySQL error code: 1259
ERROR 1260 (42000) : Row %ld was cut by GROUP_CONCAT()
OceanBase error code: 5254
Compatible MySQL error code: 1260
ERROR 1261 (1000) : Row %ld doesn't contain data for all columns
OceanBase error code: 5611
Compatible MySQL error code: 1261
ERROR 1262 (1000) : Row %ld was truncated; it contained more data than there were input columns
OceanBase error code: 5612
Compatible MySQL error code: 1262
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
OceanBase error code: 4224
Compatible MySQL error code: 1264
ERROR 1264 (22003) : value larger than specified precision(%ld,%ld) allowed for this column
OceanBase error code: 5088
Compatible MySQL error code: 1264
ERROR 1264 (22003) : value(%s) larger than specified precision(%ld,%ld) allowed for this column
OceanBase error code: 5089
Compatible MySQL error code: 1264
ERROR 1264 (22003) : Result value was out of range when casting varchar to number
OceanBase error code: 5093
Compatible MySQL error code: 1264
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
OceanBase error code: 5229
Compatible MySQL error code: 1264
ERROR 1265 (01000) : Data truncated for column '%.*s' at row %ld
OceanBase error code: 4249
Compatible MySQL error code: 1265
ERROR 1265 (01000) : Timeout value truncated to 102 years
OceanBase error code: 4252
Compatible MySQL error code: 1265
ERROR 1267 (HY000) : Illegal mix of collations (%s,%s), (%s,%s)
OceanBase error code: 5177
Compatible MySQL error code: 1267
ERROR 1273 (HY000) : Unknown collation: '%.*s'
OceanBase error code: 5143
Compatible MySQL error code: 1273
ERROR 1280 (42000) : Incorrect index name '%.*s'
OceanBase error code: 5224
Compatible MySQL error code: 1280
ERROR 1283 (HY000) : Column '%.*s' cannot be part of FULLTEXT index
OceanBase error code: 5288
Compatible MySQL error code: 1283
ERROR 1283 (42000) : A FTS index may only contain a text type column.
OceanBase error code: 7289
Compatible MySQL error code: 1283
Cause: A full-text search (FTS) index can contain only columns of the TEXT type.
Solution: Ensure that the data type of the column for which you are creating the FTS index is TEXT, such as VARCHAR, TEXT, or CHAR.
ERROR 1286 (42000) : Unknown storage engine \'%.*s\'
OceanBase error code: 5259
Compatible MySQL error code: 1286
ERROR 1287 (HY000) : %s is deprecated and will be removed in a future release. Please use '%s' instead
OceanBase error code: 5516
Compatible MySQL error code: 1287
Cause: This syntax is deprecated and will be removed in a future version.
Solution: Use the
SET variable=expression, ...orSELECT expression(s) INTO variables(s)syntax.
ERROR 1288 (HY000) : The target table %.*s of the %.*s is not updatable
OceanBase error code: 5228
Compatible MySQL error code: 1288
ERROR 1290 (HY000) : The MySQL server is running with the --read-only option so it cannot execute this statement
OceanBase error code: 5233
Compatible MySQL error code: 1290
ERROR 1291 (HY000) : Column '%.*s' has duplicated value '%.*s' in %s
OceanBase error code: 5334
Compatible MySQL error code: 1291
ERROR 1292 (22007) : %s=%d must between %d and %d
OceanBase error code: 4158
Compatible MySQL error code: 1292
ERROR 1292 (22007) : Incorrect value
OceanBase error code: 4190
Compatible MySQL error code: 1292
ERROR 1292 (01000) : Truncated incorrect DOUBLE value: '%.*s'
OceanBase error code: 4262
Compatible MySQL error code: 1292
ERROR 1292 (22007) : Incorrect datetime value: '%.*s' for column '%s'
OceanBase error code: 4219
Compatible MySQL error code: 1292
ERROR 1292 (22007) : Truncated incorrect %.*s value: '%.*s'
OceanBase error code: 5222
Compatible MySQL error code: 1292
ERROR 1294 (HY000) : Invalid ON UPDATE clause for \'%s\' column
OceanBase error code: 5172
Compatible MySQL error code: 1294
ERROR 1295 (HY000) : This command is not supported in the prepared statement protocol yet
OceanBase error code: 5568
Compatible MySQL error code: 1295
ERROR 1298 (HY000) : Unknown or incorrect time zone: \'%.*s\'
OceanBase error code: 5192
Compatible MySQL error code: 1298
ERROR 1300 (HY000) : Invalid %.*s character string: \'%.*s\'
OceanBase error code: 5250
Compatible MySQL error code: 1300
ERROR 1301 (HY000) : Result of %s() was larger than max_allowed_packet (%d) truncated
OceanBase error code: 5316
Compatible MySQL error code: 1301
ERROR 1302 (42000) : Conflicting declarations: '%s' and '%s'
OceanBase error code: 5858
Compatible MySQL error code: 1302
ERROR 1303 (2F003) : Cant create a routine from within another routine
OceanBase error code: 5582
Compatible MySQL error code: 1303
ERROR 1304 (42000) : %s %.*s already exists
OceanBase error code: 5541
Compatible MySQL error code: 1304
ERROR 1305 (42000) : %s %.*s does not exist
OceanBase error code: 5055
Compatible MySQL error code: 1305
ERROR 1305 (42000) : %s %.*s.%.*s does not exist
OceanBase error code: 5542
Compatible MySQL error code: 1305
ERROR 1305 (42000) : savepoint does not exist
OceanBase error code: 6242
Compatible MySQL error code: 1305
ERROR 1308 (42000) : no matching label: %.*s
OceanBase error code: 5546, 9505
Compatible MySQL error code: 1308
ERROR 1308 (42000) : %s with no matching label: %s
OceanBase error code: 5593
Compatible MySQL error code: 1308
ERROR 1309 (42000) : Redefining label '%.*s'
OceanBase error code: 9579
Compatible MySQL error code: 1309
ERROR 1313 (42000) : RETURN is only allowed in a FUNCTION
OceanBase error code: 5583
Compatible MySQL error code: 1313
ERROR 1314 (HY000) : '%.*s' is not allowed in stored procedure
OceanBase error code: 9580
Compatible MySQL error code: 1314
ERROR 1317 (70100) : Query execution was interrupted
OceanBase error code: 5065
Compatible MySQL error code: 1317
ERROR 1318 (42000) : Incorrect number of arguments for %s %s; expected %u, got %u
OceanBase error code: 5555
Compatible MySQL error code: 1318
ERROR 1319 (42000) : Undefined CONDITION: %.*s
OceanBase error code: 5545
Compatible MySQL error code: 1319
ERROR 1320 (42000) : No Return found in FUNCTION '%.*s'
OceanBase error code: 9575
Compatible MySQL error code: 1320
ERROR 1321 (2F005) : FUNCTION %s ended without RETURN
OceanBase error code: 5580
Compatible MySQL error code: 1321
ERROR 1323 (42000) : Cursor SELECT must not have INTO
OceanBase error code: 5584
Compatible MySQL error code: 1323
ERROR 1324 (42000) : Undefined CURSOR: %.*s
OceanBase error code: 5547
Compatible MySQL error code: 1324
ERROR 1325 (24000) : Cursor is already open
OceanBase error code: 5589
Compatible MySQL error code: 1325
ERROR 1326 (24000) : Cursor is not open
OceanBase error code: 5590
Compatible MySQL error code: 1326
ERROR 1327 (42000) : Undeclared variable: %.*s
OceanBase error code: 5543
Compatible MySQL error code: 1327
ERROR 1327 (42000) : Undeclared type: %.*s
OceanBase error code: 5544
Compatible MySQL error code: 1327
ERROR 1328 (HY000) : Incorrect number of FETCH variables
OceanBase error code: 5554
Compatible MySQL error code: 1328
ERROR 1329 (02000) : No data - zero rows fetched, selected, or processed
OceanBase error code: 4026
Compatible MySQL error code: 1329
ERROR 1330 (42000) : Duplicate parameter: %.*s
OceanBase error code: 5548
Compatible MySQL error code: 1330
ERROR 1330 (42000) : Duplicate type: %.*s
OceanBase error code: 5550
Compatible MySQL error code: 1330
ERROR 1330 (42000) : Duplicate label: %.*s
OceanBase error code: 5552
Compatible MySQL error code: 1330
ERROR 1331 (42000) : Duplicate variable: %.*s
OceanBase error code: 5549
Compatible MySQL error code: 1331
ERROR 1332 (42000) : Duplicate condition: %.*s
OceanBase error code: 5551
Compatible MySQL error code: 1332
ERROR 1333 (42000) : Duplicate cursor: %.*s
OceanBase error code: 5553
Compatible MySQL error code: 1333
ERROR 1336 (0A000) : %s is not allowed in stored function or trigger
OceanBase error code: 5569
Compatible MySQL error code: 1336
ERROR 1337 (42000) : Variable or condition declaration after cursor or handler declaration
OceanBase error code: 5586
Compatible MySQL error code: 1337
ERROR 1338 (42000) : Cursor declaration after handler declaration
OceanBase error code: 5587
Compatible MySQL error code: 1338
ERROR 1339 (20000) : Case not found for CASE statement
OceanBase error code: 5571
Compatible MySQL error code: 1339
ERROR 1347 (HY000) : \'%s.%s\' is not %s
OceanBase error code: 5214
Compatible MySQL error code: 1347
ERROR 1348 (HY000) : Column '%.*s' is not updatable
OceanBase error code: 5719
Compatible MySQL error code: 1348
ERROR 1349 (HY000) : View's SELECT contains a subquery in the FROM clause
OceanBase error code: 4238
Compatible MySQL error code: 1349
ERROR 1350 (HY000) : View's SELECT contains a 'INTO' clause.
OceanBase error code: 5503
Compatible MySQL error code: 1350
Cause: The SELECT statement of the view contains an 'INTO' clause.
Solution: Remove the 'INTO' clause from the SELECT statement of the view.
ERROR 1353 (HY000) : View's SELECT and view's field list have different column counts
OceanBase error code: 5740
Compatible MySQL error code: 1353
ERROR 1356 (42S22) : View \'%.*s.%.*s\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
OceanBase error code: 5231
Compatible MySQL error code: 1356
ERROR 1360 (HY000) : Trigger does not exist
OceanBase error code: 5733
Compatible MySQL error code: 1360
ERROR 1362 (HY000) : Updating of %s row is not allowed in %s trigger
OceanBase error code: 9584
Compatible MySQL error code: 1362
ERROR 1363 (HY000) : There is no %s row in on %s trigger
OceanBase error code: 9640
Compatible MySQL error code: 1363
ERROR 1364 (HY000) : Field \'%s\' doesn't have a default value
OceanBase error code: 4227
Compatible MySQL error code: 1364
ERROR 1365 (22012) : Divided by zero
OceanBase error code: 4078
Compatible MySQL error code: 1365
ERROR 1366 (22007) : Incorrect datetime value: '%s' for column '%s'
OceanBase error code: 4219
Compatible MySQL error code: 1366
ERROR 1366 (HY000) : Incorrect integer value for column '%.*s' at row %ld
OceanBase error code: 4226
Compatible MySQL error code: 1366
ERROR 1366 (HY000) : Incorrect string value for column '%.*s' at row %ld
OceanBase error code: 4258
Compatible MySQL error code: 1366
ERROR 1367 (22007) : Illegal %s '%.*s' value found during parsing
OceanBase error code: 5332
Compatible MySQL error code: 1367
ERROR 1368 (HY000) : CHECK OPTION on non-updatable view '%.*s.%.*s'
OceanBase error code: 5972
Compatible MySQL error code: 1368
ERROR 1369 (HY000) : CHECK OPTION failed '%.*s.%.*s'
OceanBase error code: 5971
Compatible MySQL error code: 1369
ERROR 1370 (42000) : %.*s command denied to user '%.*s'@'%.*s' for routine '%.*s'
OceanBase error code: 5387
Compatible MySQL error code: 1370
Cause: The user is denied the permission to execute the routine command.
Solution: Check whether the user has the corresponding privilege and whether there are spelling errors in the stored procedure or function name.
ERROR 1382 (HY000) : The '%.*s' syntax is reserved for purposes internal to the OceanBase Server
OceanBase error code: 5405
Compatible MySQL error code: 1382
ERROR 1390 (54000) : Prepared statement contains too many placeholders
OceanBase error code: 5080
Compatible MySQL error code: 1390
ERROR 1391 (HY000) : Key part \'%.*s\' length cannot be 0
OceanBase error code: 5191
Compatible MySQL error code: 1391
ERROR 1393 (HY000) : Can not modify more than one base table through a join view '%.*s.%.*s'
OceanBase error code: 5718
Compatible MySQL error code: 1393
ERROR 1395 (HY000) : Can not delete from join view '%.*s.%.*s'
OceanBase error code: 5720
Compatible MySQL error code: 1395
ERROR 1396 (HY000) : Operation %.*s failed for %.*s
OceanBase error code: 5155
Compatible MySQL error code: 1396
ERROR 1397 (XAE04) : Unknown XID
OceanBase error code: 6245
Compatible MySQL error code: 1397
ERROR 1398 (XAE05) : XAER_INVAL: Invalid arguments (or unsupported command)
OceanBase error code: 6249
Compatible MySQL error code: 1398
ERROR 1399 (XAE07) : The command cannot be executed when global transaction is in the %s state
OceanBase error code: 6246
Compatible MySQL error code: 1399
ERROR 1399 (XAE07) : RMFAIL: The command cannot be executed when global transaction is in the %s state
OceanBase error code: 6258
Compatible MySQL error code: 1399
ERROR 1400 (XAE09) : Some work is done outside global transaction
OceanBase error code: 6248
Compatible MySQL error code: 1400
ERROR 1401 (XAE03) : XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
OceanBase error code: 6250
Compatible MySQL error code: 1401
ERROR 1402 (XA100) : XA_RBROLLBACK: Transaction branch was rolled back
OceanBase error code: 6252
Compatible MySQL error code: 1402
ERROR 1406 (22001) : Data too long for column '%.*s' at row %ld
OceanBase error code: 5167
Compatible MySQL error code: 1406
ERROR 1406 (22001) : Data too long for column
OceanBase error code: 5354
Compatible MySQL error code: 1406
ERROR 1407 (42000) : Bad SQLSTATE: \'%.*s\'
OceanBase error code: 5585
Compatible MySQL error code: 1407
ERROR 1410 (42000) : You are not allowed to create a user with GRANT
OceanBase error code: 5169
Compatible MySQL error code: 1410
ERROR 1411 (HY000) : Incorrect %.*s value: '%.*s' for function %.*s
OceanBase error code: 5936
Compatible MySQL error code: 1411
ERROR 1411 (HY000) : Incorrect string value for function %s
OceanBase error code: 11062
Compatible MySQL error code: 1411
Cause: The string value for function %s is incorrect.
Solution: Check the function to ensure its validity.
ERROR 1413 (42000) : Duplicate handler declared in the same block
OceanBase error code: 5581
Compatible MySQL error code: 1413
ERROR 1414 (42000) : OUT or INOUT argument %d for routine %.*s is not a variable
OceanBase error code: 5592
Compatible MySQL error code: 1414
ERROR 1415 (0A000) : Not allowed to return a result set from a %s
OceanBase error code: 5579
Compatible MySQL error code: 1415
ERROR 1416 (22003) : Cannot get geometry object from data you send to the GEOMETRY field.
OceanBase error code: 7276
Compatible MySQL error code: 1416
ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger
OceanBase error code: 5576
Compatible MySQL error code: 1422
ERROR 1422 (HY000) : '%.*s' is not allowed in stored function or trigger
OceanBase error code: 9576
Compatible MySQL error code: 1422
ERROR 1424 (HY000) : Recursive stored functions are not allowed
OceanBase error code: 5570
Compatible MySQL error code: 1424
ERROR 1425 (42000) : Too big scale %d specified for column '%s'. Maximum is %ld
OceanBase error code: 5202
Compatible MySQL error code: 1425
ERROR 1426 (42000) : Too big precision %d specified for column '%s'. Maximum is %ld
OceanBase error code: 5203
Compatible MySQL error code: 1426
ERROR 1427 (42000) : For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')
OceanBase error code: 5204
Compatible MySQL error code: 1427
ERROR 1435 (HY000) : Trigger in wrong schema
OceanBase error code: 9582
Compatible MySQL error code: 1435
ERROR 1439 (42000) : Display width out of range for column '%s' (max = %ld)
OceanBase error code: 5205
Compatible MySQL error code: 1439
ERROR 1439 (42000) : Display width out of range for column '%.*s' (max = %d)
OceanBase error code: 9578
Compatible MySQL error code: 1439
ERROR 1440 (XAE08) : The XID already exists
OceanBase error code: 6247
Compatible MySQL error code: 144
ERROR 1441 (22008) : Datetime overflow
OceanBase error code: 4261
Compatible MySQL error code: 1441
ERROR 1442 (HY000) : Can't update table \'%s\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
OceanBase error code: 5791
Compatible MySQL error code: 1442
ERROR 1444 (HY000) : The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
OceanBase error code: 11016
Compatible MySQL error code: 1444
Cause: The prepared statement contains a recursive call to itself.
Solution: Modify the logic of the stored procedure/function to avoid recursive calls to prepared statements.
ERROR 1445 (HY000) : Not allowed to set autocommit from a stored function or trigger
OceanBase error code: 5591
Compatible MySQL error code: 1445
ERROR 1449 (HY000) : User not exist
OceanBase error code: 5035
Compatible MySQL error code: 1449
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
OceanBase error code: 5314
Compatible MySQL error code: 1451
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
OceanBase error code: 5618
Compatible MySQL error code: 1451
ERROR 1452 (23000) : Cannot add or update a child row: a foreign key constraint fails
OceanBase error code: 5315
Compatible MySQL error code: 1452
ERROR 1456 (HY000) : Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine
OceanBase error code: 5567
Compatible MySQL error code: 1456
ERROR 1458 (42000) : Incorrect routine name \'%.*s\'
OceanBase error code: 5588
Compatible MySQL error code: 1458
ERROR 1462 (42S02) : \'%.*s'.'%.*s\' contains view recursion
OceanBase error code: 5239
Compatible MySQL error code: 1462
ERROR 1466 (HY000) : Leading spaces are removed from name \'%.*s\'
OceanBase error code: 5247
Compatible MySQL error code: 1466
ERROR 1467 (HY000) : Failed to read auto increment value from storage engine
OceanBase error code: 5184
Compatible MySQL error code: 1467
ERROR 1470 (HY000) : String '%.*s' is too long for user name (should be no longer than 64)
OceanBase error code: 5181
Compatible MySQL error code: 1470
ERROR 1471 (HY000) : The target table %.*s of the INSERT is not insertable-into
OceanBase error code: 5717
Compatible MySQL error code: 1471
ERROR 1474 (HY000) : Name \'%.*s\' has become ''
OceanBase error code: 5246
Compatible MySQL error code: 1474
ERROR 1475 (42000) : Ambiguous column
OceanBase error code: 5015
Compatible MySQL error code: 1475
ERROR 1480 (HY000) : Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition
OceanBase error code: 5878
Compatible MySQL error code: 1480
Cause: VALUES LESS THAN can only be used in partition definitions that employ RANGE PARTITIONING.
Solution: Use the correct syntax for partition definitions based on the table's partitioning scheme.
ERROR 1486 (HY000) : Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed
OceanBase error code: 5230
Compatible MySQL error code: 1486
ERROR 1488 (HY000) : Field in list of fields for partition function not found in table
OceanBase error code: 5255
Compatible MySQL error code: 1488
ERROR 1491 (HY000) : The PARTITION function returns the wrong type
OceanBase error code: 5257
Compatible MySQL error code: 1491
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition%.*s
OceanBase error code: 5281
Compatible MySQL error code: 1493
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition
OceanBase error code: 5353
Compatible MySQL error code: 1493
ERROR 1495 (HY000) : Multiple definition of same constant in list partitioning
OceanBase error code: 5340
Compatible MySQL error code: 1495
ERROR 1499 (HY000) : Too many partitions (including subpartitions) were defined
OceanBase error code: 5188
Compatible MySQL error code: 1499
ERROR 1500 (HY000) : It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
- OceanBase error code: 4398
- Compatible MySQL error code: 1500
- Cause: When creating a partitioned table, incompatible partitioning methods were used. For example, RANGE/LIST partitioning and HASH/KEY partitioning were used together in subpartitions.
- Solution:
- Modify the partitioning method: If you need to use RANGE/LIST partitioning and HASH/KEY partitioning together in subpartitions, consider modifying the partitioning method to use a compatible one. Note that modifying the partitioning method or splitting a partitioned table may affect existing data and applications. Proceed with caution.
- Split the partition: If you need to use incompatible partitioning methods, consider splitting the partitioned table into multiple tables, each using a different partitioning method.
ERROR 1503 (HY000) : A %s must include all columns in the table's partitioning function
OceanBase error code: 5261
Compatible MySQL error code: 1503
ERROR 1503 (HY000) : A PRIMARY KEY must include all columns in the table\'s partitioning function
OceanBase error code: 5283
Compatible MySQL error code: 1503
ERROR 1504 (HY000) : Number of partitions = 0 is not an allowed value
OceanBase error code: 5189
Compatible MySQL error code: 1504
ERROR 1505 (HY000) : Partition management on a not partitioned table is not possible
OceanBase error code: 5302
Compatible MySQL error code: 1505
ERROR 1507 (HY000) : error in list of partitions to DROP
OceanBase error code: 5303
Compatible MySQL error code: 1507
ERROR 1508 (HY000) : Cannot remove all partitions, use DROP TABLE instead
OceanBase error code: 5306
Compatible MySQL error code: 1508
ERROR 1512 (HY000) : %s PARTITION can only be used on RANGE/LIST partitions
OceanBase error code: 5305
Compatible MySQL error code: 1512
ERROR 1517 (HY000) : Duplicate partition name \'%.*s\'
OceanBase error code: 5280
Compatible MySQL error code: 1517
ERROR 1517 (HY000) : Duplicate partition name %.*s
- OceanBase error code: 5493
- Compatible MySQL error code: 1517
- Cause: When modifying a table partition name, the new name duplicates an existing partition name in the table. (Since MySQL does not have a concept of subpartitions, this error code is shared by both partition and subpartition names.)
- Solution: Rename the partition or delete the partition with the duplicate name.
ERROR 1517 (HY000) : Duplicate partition name %.*s
- OceanBase error code: 5494
- Compatible MySQL error code: 1517
- Cause: The partition name is duplicated.
- Solution: Rename the partition or delete the duplicate partition.
ERROR 1517 (HY000) : missing or invalid WAIT interval
- OceanBase error code: 5495
- Compatible MySQL error code: 1517
- Cause: The wait time parameter specified in the MySQL WAIT command is invalid or missing.
- Solution: Check the syntax of the WAIT command you are using and ensure the wait time parameter is correct.
ERROR 1520 (HY000) : Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
OceanBase error code: 5566
Compatible MySQL error code: 1520
ERROR 1524 (HY000) : Plugin '%.*s' is not loaded
OceanBase error code: 11003
Compatible MySQL error code: 1524
Cause:
- The input plugin type is not supported.
- The input plugin type is supported (currently, OceanBase AI Database only supports the
mysql_native_passwordtype), but the plugin was not correctly loaded by the program.
Solution:
- Check whether the plugin type is supported.
- Check whether the loading statement, configuration file, and version of the plugin are correct.
- Check whether sufficient privileges are available to load and install the plugin.
ERROR 1525 (HY000) : Incorrect %s value: '%s'
OceanBase error code: 5241
Compatible MySQL error code: 1525
ERROR 1525 (HY000) : XML parsing failed
OceanBase error code: 9549
Compatible MySQL error code: 1525
Cause: The XML parser returned an error while attempting to parse the document.
Solution: Check whether the document to be parsed is valid.
ERROR 1526 (HY000) : Table has no partition for value
OceanBase error code: 5284
Compatible MySQL error code: 1526
ERROR 1537 (HY000) : Event '%.*s' already exists
OceanBase error code: 9768
Compatible MySQL error code: 1537
Cause: The name of the event being created conflicts with an existing event name.
Solution: Choose a different, unique name for the new event.
ERROR 1539 (HY000) : Unknown '%.*s' event
OceanBase error code: 9769
Compatible MySQL error code: 1539
Cause: The event that you are trying to access or operate on does not exist.
Solution: Verify that the event name is correct and that the target event exists.
ERROR 1540 (HY000) : Failed to alter event '%.*s'
OceanBase error code: 9770
Compatible MySQL error code: 1540
Cause: Failed to modify the event.
Solution: Ensure that the syntax of the
ALTER EVENTstatement is correct, including the attributes and values to be modified.
ERROR 1541 (HY000) : Failed to drop %.*s
OceanBase error code: 9771
Compatible MySQL error code: 1541
Cause: Failed to drop an event, table, or other database object.
Solution: Use the corresponding query statement to confirm the exact name and existence of the object.
ERROR 1542 (HY000) : INTERVAL is either not positive or too big
OceanBase error code: 9772
Compatible MySQL error code: 1542
Cause: The specified time interval (INTERVAL) when defining an event is not a positive number or exceeds the allowed maximum value.
Solution: Ensure the INTERVAL value is positive. If the interval value is too large, adjust it to a reasonable range based on your needs and system limitations.
ERROR 1543 (HY000) : ENDS is either invalid or before STARTS
OceanBase error code: 9773
Compatible MySQL error code: 1543
Cause: The event end time (ENDS) is either invalid or earlier than the start time (STARTS).
Solution: Confirm that the ENDS timestamp is correct and later than the STARTS time.
ERROR 1544 (HY000) : Event execution time is in the past. Event has been disabled
OceanBase error code: 9774
Compatible MySQL error code: 1544
Cause: The start time set when creating the event is earlier than the current time.
Solution: Update the event's start time to a future point in time to ensure it is valid.
ERROR 1549 (HY000) : Failed to delete the event from mysql.event
OceanBase error code: 9775
Compatible MySQL error code: 1549
Cause: Failed to delete an event from the
mysql.eventtable.Solution: Ensure the current user has the permission to delete events.
ERROR 1551 (HY000) : Same old and new event name
OceanBase error code: 9776
Compatible MySQL error code: 1551
Cause: The operation is invalid because the new name is the same as the old name when you try to rename an event.
Solution: Specify a new name that is different from the current event name in the ALTER EVENT statement.
ERROR 1552 (HY000) : Data for column '%.*s' too long
OceanBase error code: 9777
Compatible MySQL error code: 1552
Cause: The length of data inserted into a column exceeds the maximum length defined for that column.
Solution: Check and shorten the length of the inserted data to ensure it does not exceed the column's maximum length limit.
ERROR 1562 (HY000) : Cannot create temporary table with partitions
OceanBase error code: 5310
Compatible MySQL error code: 1562
ERROR 1563 (HY000) : Partition constant is out of partition function domain
OceanBase error code: 5286
Compatible MySQL error code: 1563
ERROR 1564 (HY000) : This partition function is not allowed
OceanBase error code: 5262
Compatible MySQL error code: 1564
ERROR 1566 (HY000) : Not allowed to use NULL value in VALUES LESS THAN
OceanBase error code: 5285
Compatible MySQL error code: 1566
ERROR 1567 (HY000) : Incorrect partition name '%.*s'
OceanBase error code: 11002
Compatible MySQL error code: 1567
Cause: The partition name is incorrect.
Solution: Please check whether the partition name is entered correctly.
ERROR 1568 (25001) : Transaction characteristics can't be changed while a transaction is in progress
OceanBase error code: 5219
Compatible MySQL error code: 1568
ERROR 1576 (HY000) : Recursion of EVENT DDL statements is forbidden when body is present
OceanBase error code: 9780
Compatible MySQL error code: 1576
Cause: A DDL operation attempts to directly or indirectly modify itself again. Recursive execution of an event's DDL statements is prohibited when the event definition contains a body.
Solution: Check the DDL statement to ensure it does not directly or indirectly reference the event being created or modified.
ERROR 1582 (42000) : Incorrect parameter count in the call to native function '%.*s'
OceanBase error code: 5054
Compatible MySQL error code: 1582
ERROR 1583 (42000) : Incorrect parameters in the call to native function '%.*s'
OceanBase error code: 5407
Compatible MySQL error code: 1583
ERROR 1588 (HY000) : Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
OceanBase error code: 9778
Compatible MySQL error code: 1588
Cause: The event was automatically dropped immediately after creation because its execution time was in the past.
Solution: Set the event's start time to a future point to ensure it is executed in the future.
ERROR 1589 (HY000) : Event execution time is in the past. The event was not changed. Specify a time in the future.
OceanBase error code: 9779
Compatible MySQL error code: 1589
Cause: The execution time of the event being modified is in the past, so the modification did not take effect.
Solution: Ensure the modified event execution time is in the future so that the event can be scheduled properly.
ERROR 1613 (XA106) : XA_RBTIMEOUT: Transaction branch was rolled back: took too long
OceanBase error code: 6253
Compatible MySQL error code: 1613
ERROR 1621 (HY000) : variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value
OceanBase error code: 5102
Compatible MySQL error code: 1621
ERROR 1628 (HY000) : Comment for table is too long (max = %ld)
OceanBase error code: 4229
Compatible MySQL error code: 1628
ERROR 1629 (HY000) : Comment for field is too long (max = %ld)
OceanBase error code: 4230
Compatible MySQL error code: 1629
ERROR 1642 (01000) : Unhandled user-defined warning condition
OceanBase error code: 9701
Compatible MySQL error code: 1642
ERROR 1644 (HY000) : Unhandled user-defined exception condition
OceanBase error code: 5556
Compatible MySQL error code: 1644
ERROR 1645 (0K000) : RESIGNAL when handler not active
OceanBase error code: 9702
Compatible MySQL error code: 1645
ERROR 1646 (HY000) : SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
OceanBase error code: 5557
Compatible MySQL error code: 1646
ERROR 1652 (HY000) : Duplicate partition field name '%.*s'
OceanBase error code: 5237
Compatible MySQL error code: 1652
ERROR 1653 (HY000) : Inconsistency in usage of column lists for partitioning
OceanBase error code: 5276
Compatible MySQL error code: 1653
ERROR 1654 (HY000) : Partition column values of incorrect type
OceanBase error code: 5275
Compatible MySQL error code: 1654
ERROR 1654 (HY000) : Partition column values of incorrect type
OceanBase error code: 5349
Compatible MySQL error code: 1654
ERROR 1654 (HY000) : Partition column values of incorrect type
OceanBase error code: 5355
Compatible MySQL error code: 1654
ERROR 1655 (HY000) : Too many fields in \'list of partition fields\'
OceanBase error code: 5287
Compatible MySQL error code: 1655
ERROR 1657 (HY000) : Cannot have more than one value for this type of RANGE partitioning
OceanBase error code: 5277
Compatible MySQL error code: 1657
ERROR 1659 (HY000) : Field \'%.*s\' is of a not allowed type for this type of partitioning
OceanBase error code: 5178
Compatible MySQL error code: 1659
ERROR 1688 (HY000) : Comment for index is too long (max = %ld)
OceanBase error code: 4231
Compatible MySQL error code: 1688
ERROR 1690 (22003) : %s value is out of range in '%s'
OceanBase error code: 4157
Compatible MySQL error code: 1690
ERROR 1697 (HY000) : VALUES value for partition \'%.*s\' must have type INT
OceanBase error code: 5274
Compatible MySQL error code: 1697
ERROR 1701 (42000) : Cannot truncate a table referenced in a foreign key constraint %.*s
OceanBase error code: 5594
Compatible MySQL error code: 1701
ERROR 1706 (HY000) : Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'
OceanBase error code: 5344
Compatible MySQL error code: 1706
ERROR 1708 (HY000) : The value of \'%s\' should be no less than the value of \'%s\'
OceanBase error code: 5266
Compatible MySQL error code: 1708
ERROR 1731 (HY000) : Non matching attribute '%s' between partition and table
OceanBase error code: 4773
Compatible MySQL error code: 1731
Cause: Some attributes do not match between the partition and the table.
Solution: Check the attributes between the partition and the table to ensure they match.
ERROR 1732 (HY000) : Table to exchange with partition is partitioned: '%.*s'
OceanBase error code: 11017
Compatible MySQL error code: 1732
Cause: The table you are trying to exchange is a partitioned table.
Solution: Select a non-partitioned table for the exchange.
ERROR 1735 (HY000) : Unkown partition '%.*s' in table '%.*s'
OceanBase error code: 5146
Compatible MySQL error code: 1735
ERROR 1736 (HY000) : Tables have different definitions
OceanBase error code: 4772
Compatible MySQL error code: 1736
Cause: The definitions of the two tables are different.
Solution: Compare the schema definitions of the two tables to ensure they match, including table structure, field types, and the number of fields.
ERROR 1748 (HY000) : Found a row not matching the given partition set
OceanBase error code: 5147
Compatible MySQL error code: 1748
ERROR 1758 (35000) : Invalid condition number
OceanBase error code: 9696
Compatible MySQL error code: 1758
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
OceanBase error code: 5220
Compatible MySQL error code: 1792
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
OceanBase error code: 6226
Compatible MySQL error code: 1792
ERROR 1819 (HY000) : Your password does not satisfy the current policy requirements
OceanBase error code: 4365
Compatible MySQL error code: 1819
ERROR 1820 (HY000) : You must reset your password using ALTER USER statement before executing this statement
OceanBase error code: 4366
Compatible MySQL error code: 1820
ERROR 1827 (42000) : The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function
OceanBase error code: 5227
Compatible MySQL error code: 1827
ERROR 1830 (HY000) : Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
OceanBase error code: 5512
Compatible MySQL error code: 1830
Cause: A column cannot be set to NOT NULL because it needs to be set to SET NULL in a foreign key constraint.
Solution: Set the column to allow NULL, or modify the foreign key constraint to use another operation (such as SET DEFAULT).
ERROR 1830 (HY000) : Cannot define foreign key with ON DELETE SET NULL clause on a generated column
OceanBase error code: 5513
Compatible MySQL error code: 1830
Cause: A foreign key constraint with an ON DELETE SET NULL clause cannot be defined on a virtual column.
Solution: Do not define a foreign key constraint with an ON DELETE SET NULL clause on a virtual column.
ERROR 1831 (HY000) : Duplicate index '%s' defined on the table '%s.%s'
OceanBase error code: 9137
Compatible MySQL error code: 1831
Cause: An attempt was made to create an index that already exists.
Solution: Check whether the specified index exists. If so, delete or modify the existing index and then recreate the new one.
ERROR 1869 (HY000) : Auto-increment value in UPDATE conflicts with internally generated values
OceanBase error code: 5244
Compatible MySQL error code: 1869
ERROR 1882 (HY000) : The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long
OceanBase error code: 4336
Compatible MySQL error code: 1882
ERROR 3004 (0Z002) : GET STACKED DIAGNOSTICS when handler not active
OceanBase error code: 5402
Compatible MySQL error code: 3004
ERROR 3011 (HY000) : Referenced trigger '%s' for the given action time and event type does not exist
OceanBase error code: 9704
Compatible MySQL error code: 3011
Cause: The query execution time exceeded the maximum allowed by the system. This exceeds the threshold set by the
max_execution_timeparameter.Solution: Adjust the
max_execution_timeparameter.
ERROR 3020 (2201E) : Invalid argument for logarithm
OceanBase error code: 5565
Compatible MySQL error code: 3020
ERROR 3024 (HY000) : maybe you can adjust the session variable max_execution_time or max_execution_time hint, and try again
OceanBase error code: 4412
Compatible MySQL error code: 3024
ERROR 3028 (HY000) : Expression #%d of ORDER BY contains aggregate function and applies to a UNION
OceanBase error code: 5263
Compatible MySQL error code: 3028
ERROR 3033 (HY000) : Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical
OceanBase error code: 7201
Compatible MySQL error code: 3033
ERROR 3034 (HY000) : Calling geometry function %s with unsupported types of arguments
OceanBase error code: 7202
Compatible MySQL error code: 3034
ERROR 3035 (HY000) : Unknown GIS error occurred in function %s
OceanBase error code: 7203
Compatible MySQL error code: 3035
ERROR 3036 (HY000) : Unknown exception caught in GIS function %s
OceanBase error code: 7204
Compatible MySQL error code: 3036
ERROR 3037 (22023) : Invalid GIS data provided to function %s
OceanBase error code: 7205
Compatible MySQL error code: 3037
ERROR 3038 (HY000) : The geometry has no data in function %s.
OceanBase error code: 7206
Compatible MySQL error code: 3038
ERROR 3039 (HY000) : Unable to calculate centroid because geometry is empty in function %s.
OceanBase error code: 7207
Compatible MySQL error code: 3039
ERROR 3040 (HY000) : Geometry overlay calculation error: geometry data is invalid in function %s.
OceanBase error code: 7208
Compatible MySQL error code: 3040
ERROR 3041 (HY000) : Geometry turn info calculation error: geometry data is invalid in function %s.
OceanBase error code: 7209
Compatible MySQL error code: 3041
ERROR 3042 (HY000) : Analysis procedures of intersection points interrupted unexpectedly in function %s.
OceanBase error code: 7210
Compatible MySQL error code: 3042
ERROR 3043 (HY000) : Unknown exception thrown in function %s.
OceanBase error code: 7211
Compatible MySQL error code: 3043
ERROR 3044 (HY000) : Memory allocation error: %-.256s in function %s.
OceanBase error code: 7265
Compatible MySQL error code: 3044
ERROR 3045 (HY000) : Domain error", "Domain error: %-.256s in function %s.
OceanBase error code: 7266
Compatible MySQL error code: 3045
ERROR 3046 (HY000) : Length error: %-.256s in function %s.
OceanBase error code: 7267
Compatible MySQL error code: 3046
ERROR 3047 (HY000) : Invalid argument error: %-.256s in function %s.
OceanBase error code: 7268
Compatible MySQL error code: 3047
ERROR 3048 (HY000) : Out of range error: %-.256s in function %s.
OceanBase error code: 7269
Compatible MySQL error code: 3048
ERROR 3049 (HY000) : Overflow error: %-.256s in function %s.
OceanBase error code: 7270
Compatible MySQL error code: 3049
ERROR 3530 (HY000) : role '%.*s' not granted or does not exist
OceanBase error code: 5377
Compatible MySQL error code: 3530
Cause: The role '%.*s' has not been granted or does not exist.
Solution: Ensure that the role '%.*s' has been correctly granted and exists in the system.
ERROR 3530 (HY000) : %.*s@%.*s is not granted to %.*s@%.*s
OceanBase error code: 5379
Compatible MySQL error code: 3530
Cause: %.*s@%.*s has not been granted to %.*s@%.*s.
Solution: Ensure that the authorization %.*s@%.*s has been correctly granted to %.*s@%.*s.
ERROR 3050 (HY000) : Range error: %-.256s in function %s.
OceanBase error code: 7271
Compatible MySQL error code: 3050
ERROR 3051 (HY000) : Underflow error: %-.256s in function %s.
OceanBase error code: 7272
Compatible MySQL error code: 3051
ERROR 3052 (HY000) : Logic error: %-.256s in function %s.
OceanBase error code: 7273
Compatible MySQL error code: 3052
ERROR 3053 (HY000) : Runtime error: %-.256s in function %s.
OceanBase error code: 7274
Compatible MySQL error code: 3053
ERROR 3054 (HY000) : Unknown exception: %-.384s in function %s.
OceanBase error code: 7275
Compatible MySQL error code: 3054
ERROR 3055 (HY000) : Geometry byte string must be little endian.
OceanBase error code: 7212
Compatible MySQL error code: 3055
ERROR 3060 (HY000) : Do not support online operation on table with GIS index
OceanBase error code: 7213
Compatible MySQL error code: 3060
ERROR 3061 (42000) : User variable name %.*s is illegal
OceanBase error code: 11013
Compatible MySQL error code: 3061
Cause: The user variable name is invalid. Its length cannot exceed 1,024 characters.
Solution: Change the user variable name to a valid one.
ERROR 3064 (HY000) : invalid type given for an argument
OceanBase error code: 5351
Compatible MySQL error code: 3064
ERROR 3105 (HY000) : The value specified for generated column '%.*s' in table '%.*s' is not allowed
OceanBase error code: 5290
Compatible MySQL error code: 3105
ERROR 3106 (HY000) : '%s' is not supported for generated columns
OceanBase error code: 5292
Compatible MySQL error code: 3106
ERROR 3108 (HY000) : Column '%.*s' has a generated column dependency
OceanBase error code: 5293
Compatible MySQL error code: 3108
ERROR 3118 (HY000) : User locked
OceanBase error code: 5039
Compatible MySQL error code: 3118
ERROR 3122 (HY000) : Inconsistent intersection points.
OceanBase error code: 7214
Compatible MySQL error code: 3122
ERROR 3134 (HY000) : Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.
OceanBase error code: 7215
Compatible MySQL error code: 3134
ERROR 3140 (22032) : Invalid JSON text
OceanBase error code: 5411
Compatible MySQL error code: 3140
ERROR 3141 (22032) : Invalid JSON text in argument
OceanBase error code: 5412
Compatible MySQL error code: 3141
ERROR 3142 (42000) : The JSON binary value contains invalid data
OceanBase error code: 5413
Compatible MySQL error code: 3142
ERROR 3143 (42000) : Invalid JSON path expression
OceanBase error code: 5414
Compatible MySQL error code: 3143
ERROR 3144 (22032) : Cannot create a JSON value from a string
OceanBase error code: 5415
Compatible MySQL error code: 3144
ERROR 3145 (22032) : Invalid JSON character data provided to function
OceanBase error code: 5416
Compatible MySQL error code: 3145
ERROR 3146 (22032) : Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required
OceanBase error code: 5417
Compatible MySQL error code: 3146
ERROR 3147 (22032) : Cannot CAST value to JSON
OceanBase error code: 5418
Compatible MySQL error code: 3147
ERROR 3148 (42000) : A path expression must be encoded in the utf8 character set
OceanBase error code: 5419
Compatible MySQL error code: 3148
ERROR 3149 (42000) : In this situation, path expressions may not contain the * and ** tokens
OceanBase error code: 5420
Compatible MySQL error code: 3149
ERROR 3150 (22032) : The JSON value is too big to be stored in a JSON column
OceanBase error code: 5421
Compatible MySQL error code: 3150
ERROR 3151 (22032) : The JSON object contains a key name that is too long
OceanBase error code: 5422
Compatible MySQL error code: 3151
ERROR 1351 (HY000) : View's SELECT contains a variable or parameter
- OceanBase error code: 9748
- Compatible MySQL error code: 1351
- Cause: The SELECT statement of the view contains variables or parameters.
- Solution: Check the query statement to ensure it does not contain variables or parameters.
ERROR 3153 (42000) : The path expression is not allowed in this context
OceanBase error code: 5424
Compatible MySQL error code: 3153
ERROR 3154 (42000) : The oneOrAll argument may take these values: \'one\' or \'all\'
OceanBase error code: 5425
Compatible MySQL error code: 3154
ERROR 3155 (22003) : Out of range JSON value for CAST
OceanBase error code: 5426
Compatible MySQL error code: 3155
ERROR 3156 (22018) : Invalid JSON value for CAST
OceanBase error code: 5427
Compatible MySQL error code: 3156
ERROR 3157 (22032) : The JSON document exceeds the maximum depth
OceanBase error code: 5428
Compatible MySQL error code: 3157
ERROR 3158 (22032) : JSON documents may not contain NULL member names
OceanBase error code: 5429
Compatible MySQL error code: 3158
ERROR 3162 (HY000) : User %.*s does not exist
OceanBase error code: 11012
Compatible MySQL error code: 3162
Cause: User %.*s does not exist.
Solution: Ensure that the user %.*s to be operated on exists, or use another valid user to perform the operation.
ERROR 3163 (HY000) : Authorization ID '%.*s'@'%.*s' already exists
OceanBase error code: 11009
Compatible MySQL error code: 3163
Cause: Authorization ID '%.*s'@'%.*s' already exists.
Solution: Use a different authorization ID, or delete the existing authorization ID and try creating it again.
ERROR 3165 (42000) : A path expression is not a path to a cell in an array
OceanBase error code: 5431
Compatible MySQL error code: 3165
ERROR 3504 (HY000) : Too many enumeration valuesfor column %.*s
OceanBase error code: 5335
Compatible MySQL error code: 3504
ERROR 3505 (HY000) : Too long enumeration/setvalue for column %.*s
OceanBase error code: 5333
Compatible MySQL error code: 3505
ERROR 3516 (22S01) : %.64s value is a geometry of unexpected type %.64s in %.64s.
OceanBase error code: 7216
Compatible MySQL error code: 3516
ERROR 3516 (22S01) : Unknown WKB type(%d)! Full WKB type number was (%d).
OceanBase error code: 7288
Compatible MySQL error code: 3516
ERROR 3517 (SR002) : Can't parse the spatial reference system definition of SRID %u.
OceanBase error code: 7217
Compatible MySQL error code: 3517
ERROR 3518 (SR003) : The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.
OceanBase error code: 7218
Compatible MySQL error code: 3518
ERROR 3519 (01000) : There's no spatial reference system with SRID %u.
OceanBase error code: 7219
Compatible MySQL error code: 3519
ERROR 3520 (22S00) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.
OceanBase error code: 7220
Compatible MySQL error code: 3520
ERROR 3521 (SR001) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.
OceanBase error code: 7221
Compatible MySQL error code: 3521
ERROR 3523 (HY000) : Unknown authorization ID %.*s@%.*s
OceanBase error code: 11007
Compatible MySQL error code: 3523
Cause: The authorization ID %.*s@%.*s is unknown.
Solution: Check whether the authorization ID %.*s@%.*s exists or is entered correctly.
ERROR 3548 (SR001) : There's no spatial reference system with SRID %u.
OceanBase error code: 7222
Compatible MySQL error code: 3548
ERROR 3548 (SR001) : Spatial reference system is empty
OceanBase error code: 7285
Compatible MySQL error code: 3548
ERROR 3558 (22023) : Invalid option key '%.192s' in function %.192s.
OceanBase error code: 7286
Compatible MySQL error code: 3558
ERROR 3559 (22023) : Invalid value '%.192s' for option '%.192s' in function '%.192s'.
OceanBase error code: 7287
Compatible MySQL error code: 3559
ERROR 3560 (22023) : The string '%.192s' is not a valid key %c value pair in function %.192s.
OceanBase error code: 7283
Compatible MySQL error code: 3560
ERROR 3565 (01000) : There's no spatial reference system with SRID %u. The axis order is unknown.
OceanBase error code: 7223
Compatible MySQL error code: 3565
ERROR 3573 (HY000) : Recursive Common Table Expression should contain a UNION ALL
OceanBase error code: 5742
Compatible MySQL error code: 3573
Cause: A recursive common table expression (CTE) must contain a UNION ALL operation.
Solution: Use a UNION ALL operation in the recursive CTE.
ERROR 3574 (HY000) : Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
OceanBase error code: 5982
Compatible MySQL error code: 3574
ERROR 3575 (HY000) : ORDER BY / LIMIT / SELECT DISTINCT / HAVING / WINDOW FUNCTION / GROUP BY in recursive query block of Common Table Expression not supported
OceanBase error code: 5758
Compatible MySQL error code: 3575
Cause: ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY is not supported in the common expression of a recursive query block.
Solution: Do not use ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY in the common expression of a recursive query block.
ERROR 3576 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints
OceanBase error code: 5759
Compatible MySQL error code: 3576
ERROR 3577 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must be referenced only once, and not in any subquery
OceanBase error code: 5744
Compatible MySQL error code: 3577
ERROR 3581 (HY000) : A window which depends on another cannot define partitioning
OceanBase error code: 5438
Compatible MySQL error code: 3581
ERROR 3582 (HY000) : Window '%.*s' has a frame definition, so cannot be referenced by another window
OceanBase error code: 5439
Compatible MySQL error code: 3582
ERROR 3583 (HY000) : Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause
OceanBase error code: 5440
Compatible MySQL error code: 3583
ERROR 3586 (HY000) : Window '%.*s': frame start or end is negative or NULL or of non-integral type
OceanBase error code: 5507
Compatible MySQL error code: 3586
Cause: The start or end position of the window is negative, NULL, or of a non-integer type.
Solution: Correct the start or end position of the window to ensure it is non-negative, non-NULL, and of an integer type.
ERROR 3587 (HY000) : Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
OceanBase error code: 5984
Compatible MySQL error code: 3587
ERROR 3588 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of datetime type. Only INTERVAL bound value allowed.
OceanBase error code: 5508
Compatible MySQL error code: 3588
Cause: A window with a RANGE frame contains an ORDER BY expression based on a datetime type, and only INTERVAL boundary values are allowed.
Solution: Ensure that the ORDER BY expression in the window with a RANGE frame uses only INTERVAL boundary values, not datetime boundary values.
ERROR 3589 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of numeric type. INTERVAL bound value not allowed.
OceanBase error code: 5509
Compatible MySQL error code: 3589
Cause: A window with a RANGE frame contains an ORDER BY expression of a numeric type, and INTERVAL boundary values are not allowed.
Solution: Do not use INTERVAL boundary values in a window where the ORDER BY expression is of a numeric type.
ERROR 3590 (HY000) : Window '%.*s' has a non-constant frame bound.
OceanBase error code: 5510
Compatible MySQL error code: 3590
Cause: The window has a non-constant frame boundary.
Solution: Ensure that the frame boundary of the window is a constant.
ERROR 3592 (HY000) : Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression
OceanBase error code: 5985
Compatible MySQL error code: 3592
ERROR 3596 (HY000) : Window '%s': INTERVAL can only be used with RANGE frames
OceanBase error code: 5983
Compatible MySQL error code: 3596
ERROR 3616 (22S02) : Longitude %f is out of range in function %.192s. It must be within (%f, %f].
OceanBase error code: 7263
Compatible MySQL error code: 3616
ERROR 3617 (22S03) : Latitude %f is out of range in function %.192s. It must be within [%f, %f].
OceanBase error code: 7264
Compatible MySQL error code: 3617
ERROR 3618 (22S00) : %.192s(%.80s) has not been implemented for geographic spatial reference systems.
OceanBase error code: 7224
Compatible MySQL error code: 3618
ERROR 3636 (HY000) : Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.
OceanBase error code: 5408
Compatible MySQL error code: 3636
ERROR 3643 (HY000) : The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.
OceanBase error code: 7225
Compatible MySQL error code: 3643
ERROR 3644 (HY000) : The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.
OceanBase error code: 7226
Compatible MySQL error code: 3644
ERROR 3666 (42000) : Can't store an array or an object in the scalar %s column 'jpath'
OceanBase error code: 4298
Compatible MySQL error code: 3666
Cause: An array or object cannot be stored in a scalar column.
Solution: Convert the array or object to a scalar value, or change the column's data type to accommodate arrays or objects.
ERROR 3667 (42000) : Every table function must have an alias
OceanBase error code: 5515
Compatible MySQL error code: 3667
Cause: Each table function must have an alias.
Solution: Provide an alias for the table function.
ERROR 3674 (HY000) : The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
OceanBase error code: 7227
Compatible MySQL error code: 3674
ERROR 3682 (22S00) : Function %.192s is only defined for SRID 0 and SRID 4326.
OceanBase error code: 7228
Compatible MySQL error code: 3682
ERROR 3704 (22S00) : %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.
OceanBase error code: 7229
Compatible MySQL error code: 3704
ERROR 3705 (22S00) : %.192s(%.80s) has not been implemented for projected spatial reference systems.
OceanBase error code: 7230
Compatible MySQL error code: 3705
ERROR 3706 (22023) : Invalid radius provided to function %s: Radius(%lf) must be greater than zero.
OceanBase error code: 7284
Compatible MySQL error code: 3706
ERROR 3708 (SR006) : Missing mandatory attribute %s.
OceanBase error code: 7231
Compatible MySQL error code: 3708
ERROR 3709 (SR006) : Multiple definitions of attribute %s.
OceanBase error code: 7232
Compatible MySQL error code: 3709
ERROR 3710 (SR006) : The spatial reference system name can't be an empty string or start or end with whitespace.
OceanBase error code: 7233
Compatible MySQL error code: 3710
ERROR 3711 (SR006) : The organization name can't be an empty string or start or end with whitespace.
OceanBase error code: 7234
Compatible MySQL error code: 3711
ERROR 3712 (SR004) : There is already a spatial reference system with SRID %u.
OceanBase error code: 7235
Compatible MySQL error code: 3712
ERROR 3713 (01S00) : There is already a spatial reference system with SRID %u.
OceanBase error code: 7236
Compatible MySQL error code: 3713
ERROR 3714 (SR000) : SRID 0 is not modifiable.
OceanBase error code: 7237
Compatible MySQL error code: 3714
ERROR 3715 (01S01) : The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade.
OceanBase error code: 7238
Compatible MySQL error code: 3715
ERROR 3716 (SR005) : Can't modify SRID %u. There is at least one column depending on it.
OceanBase error code: 7239
Compatible MySQL error code: 3716
ERROR 3717 (SR006) : Invalid character in attribute %s.
OceanBase error code: 7240
Compatible MySQL error code: 3717
ERROR 3718 (SR006) : Attribute %s is too long. The maximum length is %u characters.
OceanBase error code: 7241
Compatible MySQL error code: 3718
ERROR 3726 (22S00) : Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.
OceanBase error code: 7242
Compatible MySQL error code: 3726
ERROR 3727 (22023) : Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.
OceanBase error code: 7243
Compatible MySQL error code: 3727
ERROR 3728 (HY000) : Spatial indexes can't be primary or unique indexes.
OceanBase error code: 7244
Compatible MySQL error code: 3728
ERROR 3729 (HY000) : The index type %.20s is not supported for spatial indexes.
OceanBase error code: 7245
Compatible MySQL error code: 3729
ERROR 3729 (HY000) : The index type %s is not supported for spatial indexes.
OceanBase error code: 7281
Compatible MySQL error code: 3729
ERROR 3731 (22S02) : A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].
OceanBase error code: 7246
Compatible MySQL error code: 3731
ERROR 3732 (22S03) : A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].
OceanBase error code: 7247
Compatible MySQL error code: 3732
ERROR 3736 (SR002) : The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.
OceanBase error code: 7248
Compatible MySQL error code: 3736
ERROR 3737 (SR002) : The length of the semi-major axis must be a positive number.
OceanBase error code: 7249
Compatible MySQL error code: 3737
ERROR 3738 (SR002) : The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.
OceanBase error code: 7250
Compatible MySQL error code: 3738
ERROR 3739 (SR002) : The angular unit conversion factor must be a positive number.
OceanBase error code: 7251
Compatible MySQL error code: 3739
ERROR 3740 (SR002) : The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.
OceanBase error code: 7252
Compatible MySQL error code: 3740
ERROR 3741 (22S00) : Transformation from SRID %u is not supported.
OceanBase error code: 7253
Compatible MySQL error code: 3741
ERROR 3742 (22S00) : Transformation to SRID %u is not supported.
OceanBase error code: 7254
Compatible MySQL error code: 3742
ERROR 3743 (22S00) : Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
OceanBase error code: 7255
Compatible MySQL error code: 3743
ERROR 3744 (22S00) : Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
OceanBase error code: 7256
Compatible MySQL error code: 3744
ERROR 3753 (42000) : Cannot create a functional index on a function that returns a JSON or GEOMETRY value.
OceanBase error code: 7257
Compatible MySQL error code: 3753
ERROR 3754 (HY000) : Functional index '%.*s' cannot refer to an auto-increment column.
- OceanBase error code: 5496
- Compatible MySQL error code: 3754
- Cause: An auto-increment column was used as part of a functional index during creation, which is not allowed.
- Solution: Modify the functional index to remove the auto-increment column or use another column instead.
ERROR 3757 (HY000) : Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.
- OceanBase error code: 5498
- Compatible MySQL error code: 3757
- Cause: A functional index was created on an expression that returns a BLOB or TEXT type, which is not allowed.
- Solution: Use the CAST function to convert the BLOB or TEXT expression to another type, and then create the functional index with the converted expression.
ERROR 3758 (HY000) : Expression of functional index contains a disallowed function.
- OceanBase error code: 5905
- Compatible MySQL error code: 3758
- Cause: An unsupported function was used in the index function when creating a functional index. The index function uses SYSDATE or the user environment.
- Solution: The index function must be a pure function (RNDS, RNPS, WNDS, or WNPS).
ERROR 3760 (HY000) : Spatial functional index is not supported.
OceanBase error code: 7258
Compatible MySQL error code: 3760
ERROR 3762 (HY000) : Functional index on a column is not supported. Consider using a regular index instead.
- OceanBase error code: 5499
- Compatible MySQL error code: 3762
- Cause: The index function is a single column when creating a functional index.
- Solution: Please use a regular index.
ERROR 3812 (HY000) : An expression of non-boolean type specified to a check constraint \'%.*s\'
OceanBase error code: 5987
Compatible MySQL error code: 3812
ERROR 3813 (HY000) : Column check constraint \'%.*s\' references other column
OceanBase error code: 5786
Compatible MySQL error code: 3813
ERROR 3814 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function: %.*s
OceanBase error code: 5991
Compatible MySQL error code: 3814
ERROR 3815 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function
OceanBase error code: 5992
Compatible MySQL error code: 3815
ERROR 3816 (HY000) : An expression of a check constraint \'%.*s\' cannot refer to a user or system variable
OceanBase error code: 5993
Compatible MySQL error code: 3816
ERROR 3818 (HY000) : Check constraint \'%.*s\' cannot refer to an auto-increment column
OceanBase error code: 5990
Compatible MySQL error code: 3818
ERROR 3819 (HY000) : check constraint violated
OceanBase error code: 5693
Compatible MySQL error code: 3819
ERROR 3820 (HY000) : Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
OceanBase error code: 5994
Compatible MySQL error code: 3820
ERROR 3821 (HY000) : Check constraint \'%.*s\' is not found in the table
OceanBase error code: 5988
Compatible MySQL error code: 3821
ERROR 3822 (HY000) : Duplicate check constraint name \'%.*s\'
OceanBase error code: 5678
Compatible MySQL error code: 3822
ERROR 3837 (HY000) : Column '%.*s' has a functional index dependency and cannot be dropped or renamed.
- OceanBase error code: 5497
- Compatible MySQL error code: 3837
- Cause: The column to be dropped has a functional index dependency and cannot be directly dropped or renamed.
- Solution:
- Drop the functional index: If the column to be dropped is part of a functional index, you can first drop the functional index and then drop the column.
- Modify the functional index: If the column to be dropped is part of a functional index, you can modify the functional index to remove the column from it, and then drop the column.
ERROR 3853 (22032) : Invalid JSON type in argument, should be object.
OceanBase error code: 6285
Compatible MySQL error code: 3853
Cause: An invalid JSON type is used for an argument that should be an object type.
Solution: Ensure the parameter is a valid JSON object type or convert it to the correct JSON object type.
ERROR 3855 (HY000) : Column '%.*s' has a partitioning function dependency and cannot be dropped or renamed.
- OceanBase error code: 5502
- Compatible MySQL error code: 3855
- Cause: The column cannot be dropped or renamed because it has a partitioning function dependency.
ERROR 3939 (HY000) : Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
OceanBase error code: 5986
Compatible MySQL error code: 3939
ERROR 3940 (HY000) : Constraint \'%.*s\' does not exist
OceanBase error code: 5692
Compatible MySQL error code: 3940
ERROR 3941 (HY000) : Altering constraint enforcement is not supported for the constraint \'%.*s\'. Enforcement state alter is not supported for the PRIMARY, UNIQUE and FOREIGN KEY type constraints
OceanBase error code: 5989
Compatible MySQL error code: 3941
ERROR 3942 (HY000) : Each row of a VALUES clause must have at least one column, unless when used as source in an INSERT statement.
OceanBase error code: 11000
Compatible MySQL error code: 3942
Cause: Each row in a VALUES clause must have at least one column, unless it is used as a data source in an INSERT statement.
Solution: Ensure each row in the VALUES clause has at least one column.
ERROR 3943 (HY000) : A VALUES clause cannot use DEFAULT values, unless used as a source in an INSERT statement.
OceanBase error code: 11001
Compatible MySQL error code: 3943
Cause: Default values cannot be used in the VALUES clause, unless they are used as a data source in the INSERT statement.
Solution: Do not use default values in the VALUES clause, unless they are used as a data source in the INSERT statement.
ERROR 3959 (HY000) : Check constraint \'%.*s\' uses column \'%.*s\', hence column cannot be dropped or renamed
OceanBase error code: 5859
Compatible MySQL error code: 3959
ERROR 3966 (22035) : No value was found by '%.192s' on the specified path
OceanBase error code: 5432
Compatible MySQL error code: 3966
ERROR 3967 (22035) : More than one value was found by '%.192s' on the specified path
OceanBase error code: 5433
Compatible MySQL error code: 3967