0001 ~ 3999

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 codes: 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 the correctness of the XML data.

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 used XPath expression 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 the specified user on the specified host.

• Solution: Ensure that the grant is correctly defined for the specified user on the specified host.

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 of MySQL-compatible mode 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 in 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

• Error cause: A Full-Text Search (FTS) index can only contain columns of text type.

• Solution: Ensure that the data type of the column for which you are creating an 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

• Error cause: This syntax is deprecated and will be removed in a future version.

• Solution: Use the SET variable=expression, ... or SELECT 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 permission 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: The VALUES LESS THAN clause can only be used in partition definitions that employ RANGE PARTITIONING.

• Solution: Use the correct syntax for the partition definition 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
• Error cause: An incompatible partitioning method was used when creating a partitioned table. For example, RANGE/LIST partitioning and HASH/KEY partitioning are 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 partitions: 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 the name of a table partition, 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 drop the duplicate partition.

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

• OceanBase error code: 5494
• Compatible MySQL error code: 1517
• Error cause: The partition name is duplicate.
• Solution: Modify the partition name or drop the duplicate partition.

ERROR 1517 (HY000): missing or invalid WAIT interval

• OceanBase error code: 5495
• Compatible MySQL error code: 1517
• Error cause: The specified wait time parameter is invalid or missing when using the MySQL WAIT command.
• Solution: Check the syntax of the WAIT command to 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

• Error cause:

  • The input plugin type is not supported.
  • The input plugin type is supported (currently, OceanBase Database supports mysql_native_password and caching_sha2_password types), but the plugin has not been correctly loaded by the program. caching_sha2_password is supported starting from V4.6.1.

• 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 exist 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 to be 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

• Error cause: Failed to modify an event.

• Solution: Ensure the syntax of the ALTER EVENT statement 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

• Error 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

• Error cause: The specified time interval (INTERVAL) is not positive or exceeds the allowed maximum value when defining an event.

• 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: Ensure the ENDS timestamp is correct and later than the STARTS timestamp.

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.event table.

• Solution: Ensure the current user has the privilege 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: 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 DDL statements within an event 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 it had expired.

• 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 to be exchanged 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 structure definitions of the two tables to ensure they match, including table structure, field types, and field counts.

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 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 exceeds the maximum allowed by the system, which is set by the max_execution_time parameter.

• Solution: Adjust the max_execution_time parameter.

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 with MySQL error code: 3157

ERROR 3158 (22032): JSON documents may not contain NULL member names

• OceanBase error code: 5429

• Compatible with MySQL error code: 3158

ERROR 3162 (HY000): User %.*s does not exist

• OceanBase error code: 11012

• Compatible MySQL error code: 3162

• Alert cause: The user %.*s does not exist.

• Solution: Ensure the target user %.*s 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

• Error cause: The 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 date-time type, which only allows the use of INTERVAL boundary values.

• Solution: Ensure that the ORDER BY expression for a window with a RANGE frame uses only INTERVAL boundary values, not date-time 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

• Error cause: A window containing RANGE frames has an ORDER BY expression of a numeric type, which does not allow the use of INTERVAL boundary values.

• Solution: Do not use INTERVAL boundary values in windows that have an ORDER BY expression of a numeric type.

ERROR 3590 (HY000): Window '%.*s' has a non-constant frame bound.

• OceanBase error code: 5510

• Compatible MySQL error code: 3590

• Error cause: The window has a non-constant frame boundary.

• Solution: Ensure 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

• Error 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 the storage of an array or object.

ERROR 3667 (42000): Every table function must have an alias

• OceanBase error code: 5515

• Compatible MySQL error code: 3667

• Error cause: Every 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 is used as part of a functional index, 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 is created on an expression that returns a BLOB or TEXT value, which is not allowed.
• Solution: Use the CAST function to convert the BLOB or TEXT expression to another data 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 is used in the expression of the 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: Create 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-existent 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
• Error 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

• Error cause: An invalid JSON type is used as an argument, but it should be an object type.

• Solution: Ensure the argument 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
• Error cause: The column has a partitioning function dependency, which prevents it from being dropped or renamed.

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 the VALUES clause must have at least one column, unless it is used as a data source in an INSERT statement.

• Solution: Ensure that 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 a VALUES clause, unless it is used as a data source in an INSERT statement.

• Solution: Do not use default values in a VALUES clause unless it is used as a data source in an 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