0001 to 3999

This error code range indicates error codes compatible with MySQL.

ERROR 1007 (HY000): Can't create database '%s'; database exists

• OceanBase Database error code: 5158

• MySQL compatible error code: 1007

ERROR 1008 (HY000): Can't drop database '%.*s'; database doesn't exist

• OceanBase Database error code: 5166

• MySQL compatible error code: 1008

ERROR 1017 (HY000): File not exist

• OceanBase Database error code: 4027

• MySQL compatible error code: 1017

ERROR 1018 (HY000): Directory not exist

• OceanBase Database error code: 4066

• MySQL compatible error code: 1018

ERROR 1022 (23000): Can't write; duplicate key in table \'%.*s\'

• OceanBase Database error code: 5595

• MySQL compatible error code: 1022

ERROR 1025 (HY000): ## ERROR on rename of \'%s.%s\' to \'%s.%s\'

• OceanBase Database error code: 5215

• MySQL compatible error code: 1025

ERROR 1040 (08004): Too many connections

• OceanBase Database error code: 5271

• MySQL compatible error code: 1040

ERROR 1041 (53000): Out of resource

• OceanBase Database error code: 4153

• MySQL compatible error code: 1041

ERROR 1044 (42000): Access denied for user '%.*s'@'%.*s' to database '%.*s'

• OceanBase Database error code: 5170

• MySQL compatible error code: 1044

ERROR 1045 (42000): Access denied for user '%.*s'@'%.*s' (using password: %s)

• OceanBase Database error code: 4043

• MySQL compatible error code: 1045

ERROR 1046 (3D000 ): No database selected

• OceanBase Database error code: 5134

• MySQL compatible error code: 1046

ERROR 1047 (HY001): Unknown packet

• OceanBase Database error code: 4118

• MySQL compatible error code: 1047

ERROR 1048 (23000): Column '%.*s' cannot be null

• OceanBase Database error code: 4235

• MySQL compatible error code: 1048

ERROR 1049 (42000): Unknown database '%.*s'

• OceanBase Database error code: 5154

• MySQL compatible error code: 1049

ERROR 1050 (42S01): Table '%.*s' already exists

• OceanBase Database error code: 5020

• MySQL compatible error code: 1050

ERROR 1051 (42S02): Unknown table '%.*s'

• OceanBase Database error code: 5201

• MySQL compatible error code: 1051

ERROR 1052 (23000): Column '%.*s' in %.*s is ambiguous

• OceanBase Database error code: 5207

• MySQL compatible error code: 1052

ERROR 1054 (42S22): Unknown column '%.*s' in '%.*s'

• OceanBase Database error code: 5217

• MySQL compatible error code: 1054

ERROR 1055 (42000): \'%.*s\' is not in GROUP BY

• OceanBase Database error code: 5218

• MySQL compatible error code: 1055

ERROR 1056 (42000): Can't group on '%.*s'

• OceanBase Database error code: 5206

• MySQL compatible error code: 1056

ERROR 1059 (42000): Identifier name \'%.*s\' is too long

• OceanBase Database error code: 5179, 9526

• MySQL compatible error code: 1059

ERROR 1060 (42S21): Duplicate column group name '%.*s'

• OceanBase Database error code: 5404

• MySQL compatible error code: 1060

ERROR 1061 (42000): Duplicate key name \'%.*s\'

• OceanBase Database error code: 5025

• MySQL compatible error code: 1061

ERROR 1062 (23000): Duplicate entry \'%s\' for key \'%.*s\'

• OceanBase Database error code: 5024

• MySQL compatible error code: 1062

ERROR 1063 (42000): Incorrect column specifier for column '%.*s'

• OceanBase Database error code: 5165

• MySQL compatible error code: 1063

ERROR 1064 (0B000): Failed to init SQL parser

• OceanBase Database error code: 5000

• MySQL compatible error code: 1064

ERROR 1064 (42000): Parse error", "%s near \'%.*s\' at line %d

• OceanBase Database error code: 5001

• MySQL compatible error code: 1064

ERROR 1064 (42000): Wrong number of partitions defined, mismatch with previous setting

• OceanBase Database error code: 5282

• MySQL compatible error code: 1064

ERROR 1065 (42000): Query was empty

• OceanBase Database error code: 5253

• MySQL compatible error code: 1065

ERROR 1066 (42000): Not unique table/alias: \'%.*s\'

• OceanBase Database error code: 5208

• MySQL compatible error code: 1066

ERROR 1067 (42000): Invalid default value for \'%.*s\'

• OceanBase Database error code: 5173

• MySQL compatible error code: 1067

ERROR 1068 (42000): Multiple primary key defined

• OceanBase Database error code: 5210

• MySQL compatible error code: 1068

ERROR 1069 (42000): Too many keys specified; max %ld keys allowed

• OceanBase Database error code: 5194

• MySQL compatible error code: 1069

ERROR 1070 (42000): Too many key parts specified; max %ld parts allowed

• OceanBase Database error code: 5195

• MySQL compatible error code: 1070

ERROR 1071 (42000): Specified key was too long; max key length is %ld bytes

• OceanBase Database error code: 5196

• MySQL compatible error code: 1071

ERROR 1072 (42000): Key column '%.*s' doesn't exist in table

• OceanBase Database error code: 5211

• MySQL compatible error code: 1072

ERROR 1074 (42000): Column length too big for column '%s' (max = %d)

• OceanBase Database error code: 5198

• MySQL compatible error code: 1074

ERROR 1074 (42000): Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead

• OceanBase Database error code: 9577

• MySQL compatible error code: 1074

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column

• OceanBase Database error code: 5193

• MySQL compatible error code: 1075

ERROR 1078 (01000): (string):%s: Got signal %d. Aborting

• OceanBase Database error code: 4662

• MySQL compatible error code: 1078

ERROR 1082 (42S12): Illegal index

• OceanBase Database error code: 5028

• MySQL compatible error code: 1082

ERROR 1082 (42000): Index unavailable

• OceanBase Database error code: 5073

• MySQL compatible error code: 1082

ERROR 1083 (42000): Field separator argument is not what is expected; check the manual

• OceanBase Database error code: 5295

• MySQL compatible error code: 1083

ERROR 1083 (HY000): Non-ASCII separator arguments are not fully supported

• OceanBase Database error code: 5609

• MySQL compatible 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 Database error code: 5610

• MySQL compatible error code: 1083

ERROR 1086 (58000): File already exist

• OceanBase Database error code: 4117

• MySQL compatible 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 Database error code: 5190

• MySQL compatible error code: 1089

ERROR 1090 (42000): You can't delete all columns with ALTER TABLE; use DROP TABLE instead

• OceanBase Database error code: 5187

• MySQL compatible error code: 1090

ERROR 1091 (42000): Can't DROP '%.*s'; check that column/key exists

• OceanBase Database error code: 5209

• MySQL compatible error code: 1091

ERROR 1093 (HY000): You can\'t specify target table \'%s\' for update in FROM clause

• OceanBase Database error code: 5174

• MySQL compatible error code: 1093

ERROR 1094 (HY000): Unknown thread id: %lu

• OceanBase Database error code: 4174

• MySQL compatible error code: 1094

ERROR 1095 (HY000): You are not owner of thread %lu

• OceanBase Database error code: 5251

• MySQL compatible error code: 1095

ERROR 1096 (HY000): No tables used

• OceanBase Database error code: 5185

• MySQL compatible error code: 1096

ERROR 1097 (HY000): Too many strings for column %.*s and SET

• OceanBase Database error code: 5336

• MySQL compatible error code: 1097

ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value

• OceanBase Database error code: 5430

• MySQL compatible error code: 1101

ERROR 1102 (42000): Incorrect database name '%.*s'

• OceanBase Database error code: 5162

• MySQL compatible error code: 1102

ERROR 1103 (42000): Incorrect table name '%.*s'

• OceanBase Database error code: 5163

• MySQL compatible error code: 1103

ERROR 1105 (42000): invalid xpath expression

• OceanBase Database error code: 7404

• MySQL compatible error code: 1105

• Cause: The format or content of the XPath expression is incorrect or invalid.

• Solution: Check the XPath expression and the XML data.

ERROR 1105 (42000): Given XPATH expression not supported

• OceanBase Database error code: 7409

• MySQL compatible error code: 1105

• Cause: The XPath expression is not supported.

• Solution: Check whether the XPath expression is correct and whether the database version supports the use of the XPath expression.

ERROR 1108 (HY000): Incorrect parameters to procedure '%.*s'

• OceanBase Database error code: 5406

• MySQL compatible error code: 1108

ERROR 1109 (42S02): Unknown table '%.*s' in %.*s

• OceanBase Database error code: 5200

• MySQL compatible error code: 1109

ERROR 1110 (42000): Column \'%s\' specified twice

• OceanBase Database error code: 4228

• MySQL compatible error code: 1110

ERROR 1111 (HY000): Invalid use of group function

• OceanBase Database error code: 5176

• MySQL compatible error code: 1111

ERROR 1113 (42000): A table must have at least 1 column

• OceanBase Database error code: 5904

• MySQL compatible error code: 1113

ERROR 1115 (42000): Unknown character set: '%.*s'

• OceanBase Database error code: 5142

• MySQL compatible error code: 1115

ERROR 1117 (42000): Too many columns

• OceanBase Database error code: 5197

• MySQL compatible error code: 1117

ERROR 1118 (42000): Row size too large

• OceanBase Database error code: 5199

• MySQL compatible error code: 1118

ERROR 1122 (HY000): Can not load function %s

• OceanBase Database error code: 4291

• MySQL compatible error code: 1122

ERROR 1123 (HY000): Can not initialize function '%.*s'

• OceanBase Database error code: 4292

• MySQL compatible error code: 1123

ERROR 1124 (HY000): No paths allowed for shared library

• OceanBase Database error code: 4293

• MySQL compatible error code: 1124

ERROR 1125 (HY000): Function %.*s already exists

• OceanBase Database error code: 4294

• MySQL compatible error code: 1125

ERROR 1126 (HY000): Can not open shared library '%.*s'

• OceanBase Database error code: 4295

• MySQL compatible error code: 1126

ERROR 1127 (HY000): Can't find symbol %.*s in library

• OceanBase Database error code: 4296

• MySQL compatible error code: 1127

ERROR 1133 (42000): Can not find any matching row in the user table'%.*s'

• OceanBase Database error code: 4042

• MySQL compatible error code: 1133

ERROR 1133 (42000): Incorrect password

• OceanBase Database error code: 5038

• MySQL compatible error code: 1133

ERROR 1136 (21S01): column count does not match value count at row '%d'

• OceanBase Database error code: 5168

• MySQL compatible error code: 1136

ERROR 1136 (21S01): Column count doesn\'t match value count at row %ld

• OceanBase Database error code: 5175

• MySQL compatible error code: 1136

ERROR 1138 (22004): Invalid use of NULL value

• OceanBase Database error code: 5596

• MySQL compatible error code: 1138

ERROR 1139 (42000): Got error '%s' from regexp

• OceanBase Database error code: 5115

• MySQL compatible 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 Database error code: 5221

• MySQL compatible error code: 1140

ERROR 1141 (HY000): There is no such grant defined for user '%.*s' on host '%.*s'

• OceanBase Database error code: 11008

• MySQL compatible error code: 1141

• Cause: The user '%.*s' does not have the specified privilege on the host '%.*s'.

• Solution: Make sure that the user '%.*s' has the correct privilege on the host '%.*s' and that the privilege is properly defined.

ERROR 1142 (42000): %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'

• OceanBase Database error code: 5171

• MySQL compatible error code: 1142

ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

• OceanBase Database error code: 5183

• MySQL compatible error code: 1144

ERROR 1146 (42S02): Table \'%s.%s\' doesn\'t exist

• OceanBase Database error code: 5019

• MySQL compatible 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 Database error code: 5006

• MySQL compatible error code: 1149

ERROR 1153 (08S01): Got a packet bigger than \'max_allowed_packet\' bytes"

• OceanBase Database error code: 4254

• MySQL compatible error code: 1153

ERROR 1166 (42000): Incorrect column name '%.*s'

• OceanBase Database error code: 5164

• MySQL compatible error code: 1166

ERROR 1167 (42000): The used storage engine can't index column '%.*s'

• OceanBase Database error code: 5216

• MySQL compatible error code: 1167

ERROR 1171 (42000): Insert null into %.*s

• OceanBase Database error code: 5030

• MySQL compatible 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 Database error code: 5256

• MySQL compatible error code: 1171

ERROR 1172 (42000): Result consisted of more than one row

• OceanBase Database error code: 5294

• MySQL compatible error code: 1172

ERROR 1173 (42000): Primary key columns) not specified in the WHERE clause

• OceanBase Database error code: 5047

• MySQL compatible 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 Database error code: 5865

• MySQL compatible error code: 1175

ERROR 1176 (42000): Key '%.*s' doesn't exist in table '%.*s'

• OceanBase Database error code: 5289

• MySQL compatible error code: 1176

ERROR 1192 (HY000): Can't execute the given command because you have active locked tables or an active transaction

• OceanBase Database error code: 5236

• MySQL compatible error code: 1192

ERROR 1193 (HY000): Unknown system variable '%.*s'

• OceanBase Database error code: 5044

• MySQL compatible error code: 1193

ERROR 1203 (42000): Too many sessions

• OceanBase Database error code: 5059

• MySQL compatible error code: 1203

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

• OceanBase Database error code: 6003

• MySQL compatible error code: 1205

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

• OceanBase Database error code: 6006

• MySQL compatible error code: 1205

ERROR 1210 (HY000): Incorrect arguments to %s

• OceanBase Database error code: 4002

• MySQL compatible error code: 1210

ERROR 1210 (HY000): Miss argument for %s

• OceanBase Database error code: 4272

• MySQL compatible error code: 1210

ERROR 1210 (HY000): Miss argument for %s

• OceanBase Database error code: 4277

• MySQL compatible error code: 1210

ERROR 1213 (HY000): Deadlock found when trying to get lock

• OceanBase Database error code: 4101

• MySQL compatible error code: 1213

• Cause: A deadlock occurs when concurrent transactions compete for resources and wait for each other to release locks.

• Solution:

  • Retry the transaction logic at the application layer. Usually, it can be automatically recovered.

  • Optimize the transaction order or reduce the time that transactions hold locks to avoid circular waiting.

ERROR 1215 (HY000): Cannot add foreign key constraint

• OceanBase Database error code: 5317

• MySQL compatible error code: 1215

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

• OceanBase Database error code: 5182

• MySQL compatible error code: 1221

ERROR 1221 (HY000):Incorrect usage of UNION and INTO

• OceanBase Database error code: 9641

• MySQL compatible error code: 1221

ERROR 1222 (21000): The used SELECT statements have a different number of columns

• OceanBase Database error code: 5007

• MySQL compatible error code: 1222

ERROR 1225 (HY000): Option '%s' used twice in statement

• OceanBase Database error code: 4299

• MySQL compatible error code: 1225

ERROR 1226 (42000): User '%.*s' has exceeded the '%s' resource (current value: %lu)

• OceanBase Database error code: 5967

• MySQL compatible error code: 1226

ERROR 1227 (42501): Access denied; you need (at least one of) the %s privilege(s) for this operation

• OceanBase Database error code: 5036

• MySQL compatible error code: 1227

ERROR 1228 (HY000): Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL

• OceanBase Database error code: 5100

• MySQL compatible error code: 1228

ERROR 1229 (HY000): Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL

• OceanBase Database error code: 5101

• MySQL compatible error code: 1229

ERROR 1230 (42000): Variable '%.*s' doesn't have a default value

• OceanBase Database error code: 4256

• MySQL compatible error code: 1230

ERROR 1231 (42000 ): Variable \'%.*s\' can't be set to the value of \'%.*s\'

• OceanBase Database error code: 5145

• MySQL compatible error code: 1231

ERROR 1232 (42000): Incorrect argument type to variable '%.*s'

• OceanBase Database error code: 5180

• MySQL compatible error code: 1232

ERROR 1234 (42000): Incorrect usage/placement of '%s'

• OceanBase Database error code: 5213

• MySQL compatible error code: 1234

ERROR 1235 (0A000): %s not supported

• OceanBase Database error code: 4007

• MySQL compatible 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 Database error code: 5517

• MySQL compatible error code: 1235

• Cause: In the MySQL-compatible mode of OceanBase Database of the current version, you cannot specify a default value of a non-string type for a column in the JSON_TABLE expression.

• Solution: Upgrade to the latest version that supports this feature or change the default value of the column to a string type.

ERROR 1235 (42000): This version doesn't yet support 'references in JSON Schema.

• OceanBase Database error code: 6284

• MySQL compatible error code: 1235

• Cause: The current version does not support using references in JSON mode.

• Solution: Modify the JSON mode design 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 Database error code: 9581

• MySQL compatible error code: 1235

ERROR 1238 (HY000): Variable '%.*s' is a %.*s variable

• OceanBase Database error code: 5103

• MySQL compatible error code: 1238

ERROR 1239 (42000): Incorrect foreign key definition: Key reference and table reference don't match

• OceanBase Database error code: 5318

• MySQL compatible error code: 1239

ERROR 1241 (21000): Operand should contain %ld column(s)

• OceanBase Database error code: 5042

• MySQL compatible error code: 1241

ERROR 1243 (HY007): statement not prepared, stmt_id=%u

• OceanBase Database error code: 5043

• MySQL compatible error code: 1243

ERROR 1242 (21000): Subquery returns more than 1 row

• OceanBase Database error code: 5153

• MySQL compatible error code: 1242

ERROR 1243 (HY000): Unknown prepared statement handle

• OceanBase Database error code: 5560

• MySQL compatible error code: 1243

ERROR 1247 (42S22): Reference '%.*s' not supported (reference to group function)

• OceanBase Database error code: 5225

• MySQL compatible error code: 1247

ERROR 1250 (42000): Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause

• OceanBase Database error code: 5238

• MySQL compatible error code: 1250

ERROR 1252 (7280): All parts of a SPATIAL index must be NOT NULL.

• OceanBase Database error code: 5238

• MySQL compatible error code: 1252

ERROR 1253 (42000): COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'

• OceanBase Database error code: 5144

• MySQL compatible error code: 1253

ERROR 1259 (HY000): ZLIB: Input data corrupted

• OceanBase Database error code: 5124

• MySQL compatible error code: 1259

ERROR 1260 (42000): Row %ld was cut by GROUP_CONCAT()

• OceanBase Database error code: 5254

• MySQL compatible error code: 1260

ERROR 1261 (1000): Row %ld doesn't contain data for all columns

• OceanBase Database error code: 5611

• MySQL compatible error code: 1261

ERROR 1262 (1000): Row %ld was truncated; it contained more data than there were input columns

• OceanBase Database error code: 5612

• MySQL compatible error code: 1262

ERROR 1264 (22003): Out of range value for column '%.*s' at row %ld

• OceanBase Database error code: 4224

• MySQL compatible error code: 1264

ERROR 1264 (22003): value larger than specified precision(%ld,%ld) allowed for this column

• OceanBase Database error code: 5088

• MySQL compatible error code: 1264

ERROR 1264 (22003): value(%s) larger than specified precision(%ld,%ld) allowed for this column

• OceanBase Database error code: 5089

• MySQL compatible error code: 1264

ERROR 1264 (22003): Result value was out of range when casting varchar to number

• OceanBase Database error code: 5093

• MySQL compatible error code: 1264

ERROR 1264 (22003): Out of range value for column '%.*s' at row %ld

• OceanBase Database error code: 5229

• MySQL compatible error code: 1264

ERROR 1265 (01000): Data truncated for column '%.*s' at row %ld

• OceanBase Database error code: 4249

• MySQL compatible error code: 1265

ERROR 1265 (01000): Timeout value truncated to 102 years

• OceanBase Database error code: 4252

• MySQL compatible error code: 1265

ERROR 1267 (HY000): Illegal mix of collations (%s,%s), (%s,%s)

• OceanBase Database error code: 5177

• MySQL compatible error code: 1267

ERROR 1270 (HY000): Illegal mix of collations

• OceanBase Database error code: 5356

• MySQL compatible error code: 1270

ERROR 1273 (HY000): Unknown collation: '%.*s'

• OceanBase Database error code: 5143

• MySQL compatible error code: 1273

ERROR 1280 (42000): Incorrect index name '%.*s'

• OceanBase Database error code: 5224

• MySQL compatible error code: 1280

ERROR 1283 (HY000): Column '%.*s' cannot be part of FULLTEXT index

• OceanBase Database error code: 5288

• MySQL compatible error code: 1283

ERROR 1283 (42000): A FTS index may only contain a text type column.

• OceanBase Database error code: 7289

• MySQL compatible error code: 1283

• Cause: A full-text search (FTS) index can contain only text columns.

• Solution: Make sure that the column you are trying to create an FTS index for is of text type, such as VARCHAR, TEXT, or CHAR.

ERROR 1286 (42000): Unknown storage engine \'%.*s\'

• OceanBase Database error code: 5259

• MySQL compatible error code: 1286

ERROR 1287 (HY000): %s is deprecated and will be removed in a future release. Please use '%s' instead

• OceanBase Database error code: 5516

• MySQL compatible error code: 1287

• Cause: The syntax is deprecated and will be removed in a future release.

• 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 Database error code: 5228

• MySQL compatible error code: 1288

ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement

• OceanBase Database error code: 5233

• MySQL compatible error code: 1290

ERROR 1291 (HY000): Column '%.*s' has duplicated value '%.*s' in %s

• OceanBase Database error code: 5334

• MySQL compatible error code: 1291

ERROR 1292 (22007): %s=%d must between %d and %d

• OceanBase Database error code: 4158

• MySQL compatible error code: 1292

ERROR 1292 (22007): Incorrect value

• OceanBase Database error code: 4190

• MySQL compatible error code: 1292

ERROR 1292 (01000): Truncated incorrect DOUBLE value: '%.*s'

• OceanBase Database error code: 4262

• MySQL compatible error code: 1292

ERROR 1292 (22007): Incorrect datetime value: '%.*s' for column '%s'

• OceanBase Database error code: 4219

• MySQL compatible error code: 1292

ERROR 1292 (22007): Truncated incorrect %.*s value: '%.*s'

• OceanBase Database error code: 5222

• MySQL compatible error code: 1292

ERROR 1294 (HY000): Invalid ON UPDATE clause for \'%s\'

• OceanBase Database error code: 5172

• MySQL compatible error code: 1294

ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet

• OceanBase Database error code: 5568

• MySQL compatible error code: 1295

ERROR 1298 (HY000): Unknown or incorrect time zone: \'%.*s\'

• OceanBase Database error code: 5192

• MySQL compatible error code: 1298

ERROR 1300 (HY000): Invalid %.*s character string: \'%.*s\'

• OceanBase Database error code: 5250

• MySQL compatible error code: 1300

ERROR 1301 (HY000): Result of %s() was larger than max_allowed_packet (%d) truncated

• OceanBase Database error code: 5316

• MySQL compatible error code: 1301

ERROR 1302 (42000): Conflicting declarations: '%s' and '%s'

• OceanBase Database error code: 5858

• MySQL compatible error code: 1302

ERROR 1303 (2F003): Cant create a routine from within another routine

• OceanBase Database error code: 5582

• MySQL compatible error code: 1303

ERROR 1304 (42000): %s %.*s already exists

• OceanBase Database error code: 5541

• MySQL compatible error code: 1304

ERROR 1305 (42000): %s %.*s does not exist

• OceanBase Database error code: 5055

• MySQL compatible error code: 1305

ERROR 1305 (42000): %s %.*s.%.*s does not exist

• OceanBase Database error code: 5542

• MySQL compatible error code: 1305

ERROR 1305 (42000): savepoint does not exist

• OceanBase Database error code: 6242

• MySQL compatible error code: 1305

ERROR 1308 (42000): no matching label: %.*s

• OceanBase Database error code: 5546, 9505

• MySQL compatible error code: 1308

ERROR 1308 (42000): %s with no matching label: %s

• OceanBase Database error code: 5593

• MySQL compatible error code: 1308

ERROR 1309 (42000): Redefining label '%.*s'

• OceanBase Database error code: 9579

• MySQL compatible error code: 1309

ERROR 1313 (42000): RETURN is only allowed in a FUNCTION

• OceanBase Database error code: 5583

• MySQL compatible error code: 1313

ERROR 1314 (HY000): '%.*s' is not allowed in stored procedure

• OceanBase Database error code: 9580

• MySQL compatible error code: 1314

ERROR 1317 (70100): Query execution was interrupted

• OceanBase Database error code: 5065

• MySQL compatible error code: 1317

ERROR 1318 (42000): Incorrect number of arguments for %s %s; expected %u, got %u

• OceanBase Database error code: 5555

• MySQL compatible error code: 1318

ERROR 1319 (42000): Undefined CONDITION: %.*s

• OceanBase Database error code: 5545

• MySQL compatible error code: 1319

ERROR 1320 (42000): No Return found in FUNCTION '%.*s'

• OceanBase Database error code: 9575

• MySQL compatible error code: 1320

ERROR 1321 (2F005): FUNCTION %s ended without RETURN

• OceanBase Database error code: 5580

• MySQL compatible error code: 1321

ERROR 1323 (42000): Cursor SELECT must not have INTO

• OceanBase Database error code: 5584

• MySQL compatible error code: 1323

ERROR 1324 (42000): Undefined CURSOR: %.*s

• OceanBase Database error code: 5547

• MySQL compatible error code: 1324

ERROR 1325 (24000): Cursor is already open

• OceanBase Database error code: 5589

• MySQL compatible error code: 1325

ERROR 1326 (24000): Cursor is not open

• OceanBase Database error code: 5590

• MySQL compatible error code: 1326

ERROR 1327 (42000): Undeclared variable: %.*s

• OceanBase Database error code: 5543

• MySQL compatible error code: 1327

ERROR 1327 (42000): Undeclared type: %.*s

• OceanBase Database error code: 5544

• MySQL compatible error code: 1327

ERROR 1328 (HY000): Incorrect number of FETCH variables

• OceanBase Database error code: 5554

• MySQL compatible error code: 1328

ERROR 1329 (02000): No data - zero rows fetched, selected, or processed

• OceanBase Database error code: 4026

• MySQL compatible error code: 1329

ERROR 1330 (42000): Duplicate parameter: %.*s

• OceanBase Database error code: 5548

• MySQL compatible error code: 1330

ERROR 1330 (42000): Duplicate type: %.*s

• OceanBase Database error code: 5550

• MySQL compatible error code: 1330

ERROR 1330 (42000): Duplicate label: %.*s

• OceanBase Database error code: 5552

• MySQL compatible error code: 1330

ERROR 1331 (42000): Duplicate variable: %.*s

• OceanBase Database error code: 5549

• MySQL compatible error code: 1331

ERROR 1332 (42000): Duplicate condition: %.*s

• OceanBase Database error code: 5551

• MySQL compatible error code: 1332

ERROR 1333 (42000): Duplicate cursor: %.*s

• OceanBase Database error code: 5553

• MySQL compatible error code: 1333

ERROR 1336 (0A000): %s is not allowed in stored function or trigger

• OceanBase Database error code: 5569

• MySQL compatible error code: 1336

ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration

• OceanBase Database error code: 5586

• MySQL compatible error code: 1337

ERROR 1338 (42000): Cursor declaration after handler declaration

• OceanBase Database error code: 5587

• MySQL compatible error code: 1338

ERROR 1339 (20000): Case not found for CASE statement

• OceanBase Database error code: 5571

• MySQL compatible error code: 1339

ERROR 1347 (HY000): \'%s.%s\' is not %s

• OceanBase Database error code: 5214

• MySQL compatible error code: 1347

ERROR 1348 (HY000): Column '%.*s' is not updatable

• OceanBase Database error code: 5719

• MySQL compatible error code: 1348

ERROR 1349 (HY000): View's SELECT contains a subquery in the FROM clause

• OceanBase Database error code: 4238

• MySQL compatible error code: 1349

ERROR 1350 (HY000): View's SELECT contains a 'INTO' clause.

• OceanBase Database error code: 5503

• MySQL compatible error code: 1350

• Cause: The SELECT statement of the view contains the 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 Database error code: 5740

• MySQL compatible 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 Database error code: 5231

• MySQL compatible error code: 1356

ERROR 1360 (HY000): Trigger does not exist

• OceanBase Database error code: 5733

• MySQL compatible error code: 1360

ERROR 1362 (HY000): Updating of %s row is not allowed in %s trigger

• OceanBase Database error code: 9584

• MySQL compatible error code: 1362

ERROR 1363 (HY000): There is no %s row in on %s trigger

• OceanBase Database error code: 9640

• MySQL compatible error code: 1363

ERROR 1364 (HY000): Field \'%s\' doesn't have a default value

• OceanBase Database error code: 4227

• MySQL compatible error code: 1364

ERROR 1365 (22012): Divided by zero

• OceanBase Database error code: 4078

• MySQL compatible error code: 1365

ERROR 1366 (22007): Incorrect datetime value: '%s' for column '%s'

• OceanBase Database error code: 4219

• MySQL compatible error code: 1366

ERROR 1366 (HY000): Incorrect integer value for column '%.*s' at row %ld

• OceanBase Database error code: 4226

• MySQL compatible error code: 1366

ERROR 1366 (HY000): Incorrect string value for column '%.*s' at row %ld

• OceanBase Database error code: 4258

• MySQL compatible error code: 1366

ERROR 1367 (22007): Illegal %s '%.*s' value found during parsing

• OceanBase Database error code: 5332

• MySQL compatible error code: 1367

ERROR 1368 (HY000): CHECK OPTION on non-updatable view '%.*s.%.*s'

• OceanBase Database error code: 5972

• MySQL compatible error code: 1368

ERROR 1369 (HY000): CHECK OPTION failed '%.*s.%.*s'

• OceanBase Database error code: 5971

• MySQL compatible error code: 1369

ERROR 1370 (42000): %.*s command denied to user '%.*s'@'%.*s' for routine '%.*s'

• OceanBase Database error code: 5387

• MySQL compatible error code: 1370

• Error reason: The routine command is denied to the user.

• Solution: Check whether the user has the corresponding permissions and whether the stored procedure or function is misspelled.

ERROR 1382 (HY000): The '%.*s' syntax is reserved for purposes internal to the OceanBase Server

• OceanBase Database error code: 5405

• MySQL compatible error code: 1382

ERROR 1390 (54000): Prepared statement contains too many placeholders

• OceanBase Database error code: 5080

• MySQL compatible error code: 1390

ERROR 1391 (HY000): Key part \'%.*s\' length cannot be 0

• OceanBase Database error code: 5191

• MySQL compatible error code: 1391

ERROR 1393 (HY000): Can not modify more than one base table through a join view '%.*s.%.*s'

• OceanBase Database error code: 5718

• MySQL compatible error code: 1393

ERROR 1395 (HY000): Can not delete from join view '%.*s.%.*s'

• OceanBase Database error code: 5720

• MySQL compatible error code: 1395

ERROR 1396 (HY000): Operation %.*s failed for %.*s

• OceanBase Database error code: 5155

• MySQL compatible error code: 1396

ERROR 1397 (XAE04): Unknown XID

• OceanBase Database error code: 6245

• MySQL compatible error code: 1397

ERROR 1398 (XAE05): XAER_INVAL: Invalid arguments (or unsupported command)

• OceanBase Database error code: 6249

• MySQL compatible error code: 1398

ERROR 1399 (XAE07): The command cannot be executed when global transaction is in the %s state

• OceanBase Database error code: 6246

• MySQL compatible error code: 1399

ERROR 1399 (XAE07): RMFAIL: The command cannot be executed when global transaction is in the %s state

• OceanBase Database error code: 6258

• MySQL compatible error code: 1399

ERROR 1400 (XAE09): Some work is done outside global transaction

• OceanBase Database error code: 6248

• MySQL compatible error code: 1400

ERROR 1401 (XAE03): XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

• OceanBase Database error code: 6250

• MySQL compatible error code: 1401

ERROR 1402 (XA100): XA_RBROLLBACK: Transaction branch was rolled back

• OceanBase Database error code: 6252

• MySQL compatible error code: 1402

ERROR 1406 (22001): Data too long for column '%.*s' at row %ld

• OceanBase Database error code: 5167

• MySQL compatible error code: 1406

ERROR 1406 (22001): Data too long for column

• OceanBase Database error code: 5354

• MySQL compatible error code: 1406

ERROR 1407 (42000): Bad SQLSTATE: \'%.*s\'

• OceanBase Database error code: 5585

• MySQL compatible error code: 1407

ERROR 1410 (42000): You are not allowed to create a user with GRANT

• OceanBase Database error code: 5169

• MySQL compatible error code: 1410

ERROR 1411 (HY000): Incorrect %.*s value: '%.*s' for function %.*s

• OceanBase Database error code: 5936

• MySQL compatible error code: 1411

ERROR 1413 (42000): Duplicate handler declared in the same block

• OceanBase Database error code: 5581

• MySQL compatible error code: 1413

ERROR 1414 (42000): OUT or INOUT argument %d for routine %.*s is not a variable

• OceanBase Database error code: 5592

• MySQL compatible error code: 1414

ERROR 1415 (0A000): Not allowed to return a result set from a %s

• OceanBase Database error code: 5579

• MySQL compatible error code: 1415

ERROR 1416 (22003): Cannot get geometry object from data you send to the GEOMETRY field.

• OceanBase Database error code: 7276

• MySQL compatible error code: 1416

ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger

• OceanBase Database error code: 5576

• MySQL compatible error code: 1422

ERROR 1422 (HY000): '%.*s' is not allowed in stored function or trigger

• OceanBase Database error code: 9576

• MySQL compatible error code: 1422

ERROR 1424 (HY000): Recursive stored functions are not allowed

• OceanBase Database error code: 5570

• MySQL compatible error code: 1424

ERROR 1425 (42000): Too big scale %d specified for column '%s'. Maximum is %ld

• OceanBase Database error code: 5202

• MySQL compatible error code: 1425

ERROR 1426 (42000): Too big precision %d specified for column '%s'. Maximum is %ld

• OceanBase Database error code: 5203

• MySQL compatible error code: 1426

ERROR 1427 (42000): For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')

• OceanBase Database error code: 5204

• MySQL compatible error code: 1427

ERROR 1435 (HY000): Trigger in wrong schema

• OceanBase Database error code: 9582

• MySQL compatible error code: 1435

ERROR 1439 (42000): Display width out of range for column '%s' (max = %ld)

• OceanBase Database error code: 5205

• MySQL compatible error code: 1439

ERROR 1439 (42000): Display width out of range for column '%.*s' (max = %d)

• OceanBase Database error code: 9578

• MySQL compatible error code: 1439

ERROR 1440 (XAE08): The XID already exists

• OceanBase Database error code: 6247

• MySQL compatible error code: 144

ERROR 1441 (22008): Datetime overflow

• OceanBase Database error code: 4261

• MySQL compatible 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 Database error code: 5791

• MySQL compatible 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 Database error code: 11016

• MySQL compatible error code: 1444

• Cause: The prepared statement contains a recursive call to itself.

• Solution: Modify the logic of the stored procedure or function to avoid recursive calls to the prepared statement.

ERROR 1445 (HY000): Not allowed to set autocommit from a stored function or trigger

• OceanBase Database error code: 5591

• MySQL compatible error code: 1445

ERROR 1449 (HY000): User not exist

• OceanBase Database error code: 5035

• MySQL compatible error code: 1449

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

• OceanBase Database error code: 5314

• MySQL compatible error code: 1451

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

• OceanBase Database error code: 5618

• MySQL compatible error code: 1451

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails

• OceanBase Database error code: 5315

• MySQL compatible error code: 1452

ERROR 1456 (HY000): Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine

• OceanBase Database error code: 5567

• MySQL compatible error code: 1456

ERROR 1458 (42000): Incorrect routine name \'%.*s\'

• OceanBase Database error code: 5588

• MySQL compatible error code: 1458

ERROR 1462 (42S02): \'%.*s'.'%.*s\' contains view recursion

• OceanBase Database error code: 5239

• MySQL compatible error code: 1462

ERROR 1466 (HY000): Leading spaces are removed from name \'%.*s\'

• OceanBase Database error code: 5247

• MySQL compatible error code: 1466

ERROR 1467 (HY000): Failed to read auto increment value from storage engine

• OceanBase Database error code: 5184

• MySQL compatible error code: 1467

ERROR 1470 (HY000): String '%.*s' is too long for user name (should be no longer than 64)

• OceanBase error code: 5181

• MySQL compatible error code: 1470

ERROR 1471 (HY000): The target table %.*s of the INSERT is not insertable-into

• OceanBase error code: 5717

• MySQL compatible error code: 1471

ERROR 1474 (HY000): Name \'%.*s\' has become ''

• OceanBase error code: 5246

• MySQL compatible error code: 1474

ERROR 1475 (42000): Ambiguous column

• OceanBase error code: 5015

• MySQL compatible error code: 1475

ERROR 1480 (HY000): Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition

• OceanBase error code: 5878

• MySQL compatible error code: 1480

• Cause: Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition.

• Solution: Use the correct partition definition syntax based on the table's partition definition.

ERROR 1486 (HY000): Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed

• OceanBase error code: 5230

• MySQL compatible error code: 1486

ERROR 1488 (HY000): Field in list of fields for partition function not found in table

• OceanBase error code: 5255

• MySQL compatible error code: 1488

ERROR 1491 (HY000): The PARTITION function returns the wrong type

• OceanBase error code: 5257

• MySQL compatible error code: 1491

ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition%.*s

• OceanBase error code: 5281

• MySQL compatible error code: 1493

ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition

• OceanBase error code: 5353

• MySQL compatible error code: 1493

ERROR 1495 (HY000): Multiple definition of same constant in list partitioning

• OceanBase error code: 5340

• MySQL compatible error code: 1495

ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined

• OceanBase error code: 5188

• MySQL compatible 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
• MySQL compatible error code: 1500
• Cause: Incompatible partitioning methods were used when creating the partitioned table, such as using both RANGE/LIST partitioning and HASH/KEY partitioning in subpartitions.
• Solution:
  • Change the partitioning method: If you want to use both RANGE/LIST partitioning and HASH/KEY partitioning in subpartitions, consider changing the partitioning method to a compatible one. Note that changing the partitioning method or splitting the partitioned table may affect existing data and applications. Proceed with caution.
  • Separate 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

• MySQL compatible error code: 1503

ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table\'s partitioning function

• OceanBase error code: 5283

• MySQL compatible error code: 1503

ERROR 1504 (HY000): Number of partitions = 0 is not an allowed value

• OceanBase error code: 5189

• MySQL compatible error code: 1504

ERROR 1505 (HY000): Partition management on a not partitioned table is not possible

• OceanBase error code: 5302

• MySQL compatible error code: 1505

ERROR 1507 (HY000): error in list of partitions to DROP

• OceanBase error code: 5303

• MySQL compatible error code: 1507

ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead

• OceanBase error code: 5306

• MySQL compatible error code: 1508

ERROR 1512 (HY000): %s PARTITION can only be used on RANGE/LIST partitions

• OceanBase error code: 5305

• MySQL compatible error code: 1512

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

• OceanBase error code: 5280

• MySQL compatible error code: 1517

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

• Error code in OceanBase Database: 5493
• Error code in MySQL: 1517
• Cause: When you change the name of a partition, the new name is already taken by an existing partition. The concept of subpartitions is no longer used in OceanBase Database in MySQL-compatible mode since version 4.2.0. Therefore, the same error code is used for both partitions and subpartitions in MySQL-compatible tenants of OceanBase Database.
• Solution: Use another partition name or delete the existing partition with the name.

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

• OceanBase Database error code: 5494
• MySQL compatible error code: 1517
• Cause: The partition name is duplicated.
• Solution: Rename the partition or drop the partition with the duplicate name.

ERROR 1517 (HY000): missing or invalid WAIT interval

• OceanBase Database error code: 5495
• MySQL compatible error code: 1517
• Cause: The specified wait interval is invalid or missing when the WAIT command is used in MySQL.
• Solution: Check the syntax of the WAIT command and ensure that the wait interval is specified correctly.

ERROR 1520 (HY000): Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range

• OceanBase Database error code: 5566

• MySQL compatible error code: 1520

ERROR 1524 (HY000): Plugin '%.*s' is not loaded

• OceanBase Database error code: 11003

• MySQL compatible error code: 1524

• Cause:

  • The specified plugin type is not supported.
  • The specified plugin type is supported (OceanBase Database currently supports only the mysql_native_password plugin type), but the plugin is not correctly loaded.

• Solution:

  • Check whether the specified plugin type is supported.
  • Check whether the plugin loading statement, plugin configuration file, and plugin version are correct.
  • Check whether you have the required permissions to load and install plugins.

ERROR 1525 (HY000): Incorrect %s value: '%s'

• OceanBase Database error code: 5241

• MySQL compatible error code: 1525

ERROR 1525 (HY000): XML parsing failed

• OceanBase Database error code: 9549

• MySQL compatible error code: 1525

• Cause: The XML parser returns an error when it attempts to parse the document.

• Solution: Check whether the document to be parsed is valid.

ERROR 1526 (HY000): Table has no partition for value

• OceanBase Database error code: 5284

• MySQL compatible error code: 1526

ERROR 1537 (HY000): Event '%.*s' already exists

• OceanBase Database error code: 9768

• MySQL compatible error code: 1537

• Cause: The event name to be created conflicts with an existing event name.

• Solution: Specify a different and unique name for the new event.

ERROR 1539 (HY000): Unknown '%.*s' event

• OceanBase Database error code: 9769

• MySQL compatible error code: 1539

• Cause: The event to be accessed or operated on does not exist.

• Solution: Check whether the event name is correct and whether the target event exists.

ERROR 1540 (HY000): Failed to alter event '%.*s'

• OceanBase Database error code: 9770

• MySQL compatible error code: 1540

• Cause: The event modification failed.

• Solution: Check whether 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 Database error code: 9771

• MySQL compatible error code: 1541

• Cause: The attempt to drop an event, table, or other database object failed.

• 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 Database error code: 9772

• MySQL compatible error code: 1542

• Cause: The specified interval (INTERVAL) is not a positive number or exceeds the maximum allowed value when defining an event.

• Solution: Ensure that the INTERVAL value is a positive number. If the interval value is too large, adjust it to a reasonable range based on your requirements and system limitations.

ERROR 1543 (HY000): ENDS is either invalid or before STARTS

• OceanBase Database error code: 9773

• MySQL compatible error code: 1543

• Error reason: The event end time (ENDS) is either invalid or earlier than the start time (STARTS).

• Solution: Verify that 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 Database error code: 9774

• MySQL compatible error code: 1544

• Error reason: The start time specified when the event was created is earlier than the current time.

• Solution: Update the start time of the event to a future time to ensure its validity.

ERROR 1549 (HY000): Failed to delete the event from mysql.event

• OceanBase Database error code: 9775

• MySQL compatible error code: 1549

• Error reason: Failed to delete the event from the mysql.event table.

• Solution: Ensure that the current user has the permission to delete events.

ERROR 1551 (HY000): Same old and new event name

• OceanBase Database error code: 9776

• MySQL compatible error code: 1551

• Error reason: When you attempt to rename an event, the new name is the same as the old name, making the operation invalid.

• 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 Database error code: 9777

• MySQL compatible error code: 1552

• Error reason: The length of the data inserted into a column exceeds the maximum allowed length defined for that column.

• Solution: Check the inserted data and shorten it to ensure it does not exceed the column's maximum length limit.

ERROR 1562 (HY000): Cannot create temporary table with partitions

• OceanBase Database error code: 5310

• MySQL compatible error code: 1562

ERROR 1563 (HY000): Partition constant is out of partition function domain

• OceanBase Database error code: 5286

• MySQL compatible error code: 1563

ERROR 1564 (HY000): This partition function is not allowed

• OceanBase Database error code: 5262

• MySQL compatible error code: 1564

ERROR 1566 (HY000): Not allowed to use NULL value in VALUES LESS THAN

• OceanBase Database error code: 5285

• MySQL compatible error code: 1566

ERROR 1567 (HY000): Incorrect partition name '%.*s'

• OceanBase Database error code: 11002

• MySQL compatible error code: 1567

• Error reason: The partition name is incorrect.

• Solution: Please check if the partition name is entered correctly.

ERROR 1568 (25001): Transaction characteristics can't be changed while a transaction is in progress

• OceanBase Database error code: 5219

• MySQL compatible error code: 1568

ERROR 1576 (HY000): Recursion of EVENT DDL statements is forbidden when body is present

• OceanBase Database error code: 9780

• MySQL compatible error code: 1576

• Error reason: The DDL operation attempts to modify itself directly or indirectly. When an event (EVENT) definition includes a body, recursive execution of DDL statements for the event is prohibited.

• Solution: Check the DDL statements to ensure that they do 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 Database error code: 5054

• MySQL compatible error code: 1582

ERROR 1583 (42000): Incorrect parameters in the call to native function '%.*s'

• OceanBase Database error code: 5407

• MySQL compatible error code: 1583

ERROR 1589 (HY000): Event execution time is in the past. The event was not changed. Specify a time in the future.

• OceanBase Database error code: 9779

• MySQL compatible error code: 1589

• Cause: The execution time of the event to be modified is in the past, so the modification does not take effect.

• Solution: Ensure that the execution time of the modified event is in the future so that the event can be scheduled normally.

ERROR 1613 (XA106): XA_RBTIMEOUT: Transaction branch was rolled back: took too long

• OceanBase Database error code: 6253

• MySQL compatible error code: 1613

ERROR 1621 (HY000): variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value

• OceanBase Database error code: 5102

• MySQL compatible error code: 1621

ERROR 1628 (HY000): Comment for table is too long (max = %ld)

• OceanBase Database error code: 4229

• MySQL compatible error code: 1628

ERROR 1629 (HY000): Comment for field is too long (max = %ld)

• OceanBase Database error code: 4230

• MySQL compatible error code: 1629

ERROR 1642 (01000): Unhandled user-defined warning condition

• OceanBase Database error code: 9701

• MySQL compatible error code: 1642

ERROR 1644 (HY000): Unhandled user-defined exception condition

• OceanBase Database error code: 5556

• MySQL compatible error code: 1644

ERROR 1645 (0K000): RESIGNAL when handler not active

• OceanBase Database error code: 9702

• MySQL compatible error code: 1645

ERROR 1646 (HY000): SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

• OceanBase Database error code: 5557

• MySQL compatible error code: 1646

ERROR 1652 (HY000): Duplicate partition field name '%.*s'

• OceanBase Database error code: 5237

• MySQL compatible error code: 1652

ERROR 1653 (HY000): Inconsistency in usage of column lists for partitioning

• OceanBase Database error code: 5276

• MySQL compatible error code: 1653

ERROR 1654 (HY000): Partition column values of incorrect type

• OceanBase Database error code: 5275

• MySQL compatible error code: 1654

ERROR 1654 (HY000): Partition column values of incorrect type

• OceanBase Database error code: 5349

• MySQL compatible error code: 1654

ERROR 1654 (HY000): Partition column values of incorrect type

• OceanBase Database error code: 5355

• MySQL compatible error code: 1654

ERROR 1655 (HY000): Too many fields in \'list of partition fields\'

• OceanBase Database error code: 5287

• MySQL compatible error code: 1655

ERROR 1657 (HY000): Cannot have more than one value for this type of RANGE partitioning

• OceanBase Database error code: 5277

• MySQL compatible error code: 1657

ERROR 1659 (HY000): Field \'%.*s\' is of a not allowed type for this type of partitioning

• OceanBase Database error code: 5178

• MySQL compatible error code: 1659

ERROR 1688 (HY000): Comment for index is too long (max = %ld)

• OceanBase Database error code: 4231

• MySQL compatible error code: 1688

ERROR 1690 (22003): %s value is out of range in '%s'

• OceanBase Database error code: 4157

• MySQL compatible error code: 1690

ERROR 1697 (HY000): VALUES value for partition \'%.*s\' must have type INT

• OceanBase Database error code: 5274

• MySQL compatible error code: 1697

ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint %.*s

• OceanBase Database error code: 5594

• MySQL compatible 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 Database error code: 5344

• MySQL compatible error code: 1706

ERROR 1708 (HY000): The value of \'%s\' should be no less than the value of \'%s\'

• OceanBase Database error code: 5266

• MySQL compatible error code: 1708

ERROR 1731 (HY000): Non matching attribute '%s' between partition and table

• OceanBase Database error code: 4773

• MySQL compatible error code: 1731

• Cause: Some attributes are mismatched between the partition and the table.

• Solution: Check the attributes between the partition and the table and make sure they match.

ERROR 1732 (HY000): Table to exchange with partition is partitioned: '%.*s'

• OceanBase Database error code: 11017

• MySQL compatible error code: 1732

• Cause: The table to be exchanged with the partition is a partitioned table.

• Solution: Choose a non-partitioned table for the exchange.

ERROR 1735 (HY000): Unkown partition '%.*s' in table '%.*s'

• OceanBase Database error code: 5146

• MySQL compatible error code: 1735

ERROR 1736 (HY000): Tables have different definitions

• OceanBase Database error code: 4772

• MySQL compatible error code: 1736

• Cause: The definitions of the two tables are different.

• Solution: Compare the structure definitions of the two tables and ensure they match, including the table structure, field types, and number of fields.

ERROR 1748 (HY000): Found a row not matching the given partition set

• OceanBase Database error code: 5147

• MySQL compatible error code: 1748

ERROR 1758 (35000): Invalid condition number

• OceanBase Database error code: 9696

• MySQL compatible error code: 1758

ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction

• OceanBase Database error code: 5220

• MySQL compatible error code: 1792

ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction

• OceanBase Database error code: 6226

• MySQL compatible error code: 1792

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

• OceanBase Database error code: 4365

• MySQL compatible error code: 1819

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement

• OceanBase Database error code: 4366

• MySQL compatible 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 Database error code: 5227

• MySQL compatible error code: 1827

ERROR 1830 (HY000): Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL

• OceanBase Database error code: 5512

• MySQL compatible 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 values or modify the foreign key constraint to use another action, such as SET DEFAULT.

ERROR 1830 (HY000): Cannot define foreign key with ON DELETE SET NULL clause on a generated column

• OceanBase Database error code: 5513

• MySQL compatible error code: 1830

• Cause: You cannot define a foreign key constraint with the ON DELETE SET NULL clause on a generated column.

• Solution: Do not define a foreign key constraint with the ON DELETE SET NULL clause on a generated column.

ERROR 1869 (HY000): Auto-increment value in UPDATE conflicts with internally generated values

• OceanBase Database error code: 5244

• MySQL compatible error code: 1869

ERROR 1882 (HY000): The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long

• OceanBase Database error code: 4336

• MySQL compatible error code: 1882

ERROR 3004 (0Z002): GET STACKED DIAGNOSTICS when handler not active

• OceanBase Database error code: 5402

• MySQL compatible error code: 3004

ERROR 3011 (HY000): Referenced trigger '%s' for the given action time and event type does not exist

• OceanBase Database error code: 9704

• MySQL compatible error code: 3011

ERROR 3020 (2201E): Invalid argument for logarithm

• OceanBase Database error code: 5565

• MySQL compatible error code: 3020

ERROR 3028 (HY000): Expression #%d of ORDER BY contains aggregate function and applies to a UNION

• OceanBase Database error code: 5263

• MySQL compatible 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 Database error code: 7201

• MySQL compatible error code: 3033

ERROR 3034 (HY000): Calling geometry function %s with unsupported types of arguments

• OceanBase Database error code: 7202

• MySQL compatible error code: 3034

ERROR 3035 (HY000): Unknown GIS error occurred in function %s

• OceanBase Database error code: 7203

• MySQL compatible error code: 3035

ERROR 3036 (HY000): Unknown exception caught in GIS function %s

• OceanBase Database error code: 7204

• MySQL compatible error code: 3036

ERROR 3037 (22023): Invalid GIS data provided to function %s

• OceanBase Database error code: 7205

• MySQL compatible error code: 3037

ERROR 3038 (HY000): The geometry has no data in function %s.

• OceanBase Database error code: 7206

• MySQL compatible error code: 3038

ERROR 3039 (HY000): Unable to calculate centroid because geometry is empty in function %s.

• OceanBase Database error code: 7207

• MySQL compatible error code: 3039

ERROR 3040 (HY000): Geometry overlay calculation error: geometry data is invalid in function %s.

• OceanBase Database error code: 7208

• MySQL compatible error code: 3040

ERROR 3041 (HY000): Geometry turn info calculation error: geometry data is invalid in function %s.

• OceanBase Database error code: 7209

• MySQL compatible error code: 3041

ERROR 3042 (HY000): Analysis procedures of intersection points interrupted unexpectedly in function %s.

• OceanBase Database error code: 7210

• MySQL compatible error code: 3042

ERROR 3043 (HY000): Unknown exception thrown in function %s.

• OceanBase Database error code: 7211

• MySQL compatible error code: 3043

ERROR 3044 (HY000): Memory allocation error: %-.256s in function %s.

• OceanBase Database error code: 7265

• MySQL compatible error code: 3044

ERROR 3045 (HY000): Domain error", "Domain error: %-.256s in function %s.

• OceanBase Database error code: 7266

• MySQL compatible error code: 3045

ERROR 3046 (HY000): Length error: %-.256s in function %s.

• OceanBase Database error code: 7267

• MySQL compatible error code: 3046

ERROR 3047 (HY000): Invalid argument error: %-.256s in function %s.

• OceanBase Database error code: 7268

• MySQL compatible error code: 3047

ERROR 3048 (HY000): Out of range error: %-.256s in function %s.

• OceanBase Database error code: 7269

• MySQL compatible error code: 3048

ERROR 3049 (HY000): Overflow error: %-.256s in function %s.

• OceanBase Database error code: 7270

• MySQL compatible error code: 3049

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

• OceanBase Database error code: 5377

• MySQL compatible error code: 3530

• Cause: The role '%.*s' has not been granted or does not exist.

• Solution: Make sure that the role '%.*s' has been granted and exists in the system.

ERROR 3530 (HY000): %.*s@%.*s is not granted to %.*s@%.*s

• OceanBase Database error code: 5379

• MySQL compatible error code: 3530

• Cause: The privilege %.*s@%.*s has not been granted to %.*s@%.*s.

• Solution: Make sure that the privilege %.*s@%.*s has been granted to %.*s@%.*s.

ERROR 3050 (HY000): Range error: %-.256s in function %s.

• OceanBase Database error code: 7271

• MySQL compatible error code: 3050

ERROR 3051 (HY000): Underflow error: %-.256s in function %s.

• OceanBase Database error code: 7272

• MySQL compatible error code: 3051

ERROR 3052 (HY000): Logic error: %-.256s in function %s.

• OceanBase Database error code: 7273

• MySQL compatible error code: 3052

ERROR 3053 (HY000): Runtime error: %-.256s in function %s.

• OceanBase Database error code: 7274

• MySQL compatible error code: 3053

ERROR 3054 (HY000): Unknown exception: %-.384s in function %s.

• OceanBase Database error code: 7275

• MySQL compatible error code: 3054

ERROR 3055 (HY000): Geometry byte string must be little endian.

• OceanBase Database error code: 7212

• MySQL compatible error code: 3055

ERROR 3060 (HY000): Do not support online operation on table with GIS index

• OceanBase Database error code: 7213

• MySQL compatible error code: 3060

ERROR 3061 (42000): User variable name %.*s is illegal

• OceanBase Database error code: 11013

• MySQL compatible error code: 3061

• Cause: The user variable name is invalid and cannot exceed 1,024 characters in length.

• Solution: Change the user variable name to a valid one.

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

• OceanBase Database error code: 5351

• MySQL compatible error code: 3064

ERROR 3105 (HY000): The value specified for generated column '%.*s' in table '%.*s' is not allowed

• OceanBase Database error code: 5290

• MySQL compatible error code: 3105

ERROR 3106 (HY000): '%s' is not supported for generated columns

• OceanBase Database error code: 5292

• MySQL compatible error code: 3106

ERROR 3108 (HY000): Column '%.*s' has a generated column dependency

• OceanBase Database error code: 5293

• MySQL compatible error code: 3108

ERROR 3118 (HY000): User locked

• OceanBase Database error code: 5039

• MySQL compatible error code: 3118

ERROR 3122 (HY000): Inconsistent intersection points.

• OceanBase Database error code: 7214

• MySQL compatible 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

• MySQL-compatible error code: 3134

ERROR 3140 (22032): Invalid JSON text

• OceanBase error code: 5411

• MySQL-compatible error code: 3140

ERROR 3141 (22032): Invalid JSON text in argument

• OceanBase error code: 5412

• MySQL-compatible error code: 3141

ERROR 3142 (42000): The JSON binary value contains invalid data

• OceanBase error code: 5413

• MySQL-compatible error code: 3142

ERROR 3143 (42000): Invalid JSON path expression

• OceanBase error code: 5414

• MySQL-compatible error code: 3143

ERROR 3144 (22032): Cannot create a JSON value from a string

• OceanBase error code: 5415

• MySQL-compatible error code: 3144

ERROR 3145 (22032): Invalid JSON character data provided to function

• OceanBase error code: 5416

• MySQL-compatible 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

• MySQL-compatible error code: 3146

ERROR 3147 (22032): Cannot CAST value to JSON

• OceanBase error code: 5418

• MySQL-compatible error code: 3147

ERROR 3148 (42000): A path expression must be encoded in the utf8 character set

• OceanBase error code: 5419

• MySQL-compatible error code: 3148

ERROR 3149 (42000): In this situation, path expressions may not contain the * and ** tokens

• OceanBase error code: 5420

• MySQL-compatible error code: 3149

ERROR 3150 (22032): The JSON value is too big to be stored in a JSON column

• OceanBase error code: 5421

• MySQL-compatible error code: 3150

ERROR 3151 (22032): The JSON object contains a key name that is too long

• OceanBase error code: 5422

• MySQL-compatible error code: 3151

ERROR 1351 (HY000): View's SELECT contains a variable or parameter

• OceanBase error code: 9748
• MySQL-compatible error code: 1351
• Cause: The SELECT statement of the view contains a variable or parameter.
• Solution: Check the query statement to ensure that it does not contain a variable or parameter.

ERROR 3153 (42000): The path expression is not allowed in this context

• OceanBase error code: 5424

• MySQL-compatible error code: 3153

ERROR 3154 (42000): The oneOrAll argument may take these values: \'one\' or \'all\'

• OceanBase error code: 5425

• MySQL-compatible error code: 3154

ERROR 3155 (22003): Out of range JSON value for CAST

• OceanBase error code: 5426

• MySQL-compatible error code: 3155

ERROR 3156 (22018): Invalid JSON value for CAST

• OceanBase error code: 5427

• MySQL-compatible error code: 3156

ERROR 3157 (22032): The JSON document exceeds the maximum depth

• OceanBase error code: 5428

• MySQL-compatible error code: 3157

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

• OceanBase error code: 5429

• MySQL-compatible error code: 3158

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

• OceanBase error code: 11012

• MySQL-compatible error code: 3162

• Cause: The user %.*s does not exist.

• Solution: Ensure that the user %.*s exists, or use another valid user.

ERROR 3163 (HY000): Authorization ID '%.*s'@'%.*s' already exists

• OceanBase error code: 11009

• MySQL-compatible error code: 3163

• Cause: The authorization ID '%.*s'@'%.*s' already exists.

• Solution: Use a different authorization ID, or delete the existing authorization ID and then try to create it again.

ERROR 3165 (42000): A path expression is not a path to a cell in an array

• OceanBase error code: 5431

• MySQL-compatible error code: 3165

ERROR 3504 (HY000): Too many enumeration valuesfor column %.*s

• OceanBase error code: 5335

• MySQL-compatible error code: 3504

ERROR 3505 (HY000): Too long enumeration/setvalue for column %.*s

• OceanBase error code: 5333

• MySQL-compatible error code: 3505

ERROR 3516 (22S01): %.64s value is a geometry of unexpected type %.64s in %.64s.

• OceanBase error code: 7216

• MySQL compatible error code: 3516

ERROR 3516 (22S01): Unknown WKB type(%d)! Full WKB type number was (%d).

• OceanBase error code: 7288

• MySQL compatible error code: 3516

ERROR 3517 (SR002): Can't parse the spatial reference system definition of SRID %u.

• OceanBase error code: 7217

• MySQL compatible 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

• MySQL compatible error code: 3518

ERROR 3519 (01000): There's no spatial reference system with SRID %u.

• OceanBase error code: 7219

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible error code: 3521

ERROR 3523 (HY000): Unknown authorization ID %.*s@%.*s

• OceanBase error code: 11007

• MySQL compatible error code: 3523

• Cause: The authorization ID %.*s@%.*s does not exist.

• Solution: Check whether the authorization ID %.*s@%.*s exists or whether the input is correct.

ERROR 3548 (SR001): There's no spatial reference system with SRID %u.

• OceanBase error code: 7222

• MySQL compatible error code: 3548

ERROR 3548 (SR001): Spatial reference system is empty

• OceanBase error code: 7285

• MySQL compatible error code: 3548

ERROR 3558 (22023): Invalid option key '%.192s' in function %.192s.

• OceanBase error code: 7286

• MySQL compatible error code: 3558

ERROR 3559 (22023): Invalid value '%.192s' for option '%.192s' in function '%.192s'.

• OceanBase error code: 7287

• MySQL compatible error code: 3559

ERROR 3560 (22023): The string '%.192s' is not a valid key %c value pair in function %.192s.

• OceanBase error code: 7283

• MySQL compatible error code: 3560

ERROR 3565 (01000): There's no spatial reference system with SRID %u. The axis order is unknown.

• OceanBase error code: 7223

• MySQL compatible error code: 3565

ERROR 3573 (HY000): Recursive Common Table Expression should contain a UNION ALL

• OceanBase Database error code: 5742

• MySQL compatible error code: 3573

• Cause: A recursive common table expression (CTE) must contain a UNION ALL operation.

• Solution: Use the 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 Database error code: 5982

• MySQL compatible 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 Database error code: 5758

• MySQL compatible error code: 3575

• Cause: The ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY clause cannot be used in the recursive query block of a common table expression.

• Solution: Do not use the ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY clause in the recursive query block of a common table expression.

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 Database error code: 5759

• MySQL compatible 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 Database error code: 5744

• MySQL compatible error code: 3577

ERROR 3581 (HY000):A window which depends on another cannot define partitioning

• OceanBase Database error code: 5438

• MySQL compatible error code: 3581

ERROR 3582 (HY000):Window '%.*s' has a frame definition, so cannot be referenced by another window

• OceanBase Database error code: 5439

• MySQL compatible error code: 3582

ERROR 3583 (HY000):Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause

• OceanBase Database error code: 5440

• MySQL compatible error code: 3583

ERROR 3586 (HY000): Window '%.*s': frame start or end is negative or NULL or of non-integral type

• OceanBase Database error code: 5507

• MySQL compatible error code: 3586

• Cause: The start or end of the window is negative, NULL, or of a non-integer type.

• Solution: Correct the start or end of the window to ensure that they are 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 Database error code: 5984

• MySQL compatible error code: 3587

ERROR 3588 (HY000): Window '%.*s' with RANGE frame has ORDER BY expression of datetime type. Only INTERVAL bound value allowed.

• OceanBase Database error code: 5508

• MySQL compatible error code: 3588

• Cause: The window with the RANGE frame contains an ORDER BY expression of the datetime type. Only the INTERVAL boundary value is allowed.

• Solution: Ensure that the window with the RANGE frame uses only the INTERVAL boundary value and not the datetime-type boundary value in the ORDER BY expression.

ERROR 3589 (HY000): Window '%.*s' with RANGE frame has ORDER BY expression of numeric type. INTERVAL bound value not allowed.

• OceanBase Database error code: 5509

• MySQL compatible error code: 3589

• Cause: The window with a RANGE frame contains an ORDER BY expression of a numeric type, and the INTERVAL bound value is not allowed.

• Solution: Do not use the INTERVAL bound value in a window that contains an ORDER BY expression of a numeric type.

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

• OceanBase Database error code: 5510

• MySQL compatible error code: 3590

• Cause: The window has a non-constant frame bound.

• Solution: Make sure that the frame bound 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 Database error code: 5985

• MySQL compatible error code: 3592

ERROR 3596 (HY000): Window '%s': INTERVAL can only be used with RANGE frames

• OceanBase Database error code: 5983

• MySQL compatible error code: 3596

ERROR 3616 (22S02): Longitude %f is out of range in function %.192s. It must be within (%f, %f].

• OceanBase Database error code: 7263

• MySQL compatible error code: 3616

ERROR 3617 (22S03): Latitude %f is out of range in function %.192s. It must be within [%f, %f].

• OceanBase Database error code: 7264

• MySQL compatible error code: 3617

ERROR 3618 (22S00): %.192s(%.80s) has not been implemented for geographic spatial reference systems.

• OceanBase Database error code: 7224

• MySQL compatible error code: 3618

ERROR 3636 (HY000): Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.

• OceanBase Database error code: 5408

• MySQL compatible 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 Database error code: 7225

• MySQL compatible 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 Database error code: 7226

• MySQL compatible error code: 3644

ERROR 3666 (42000): Can't store an array or an object in the scalar %s column 'jpath'

• OceanBase Database error code: 4298

• MySQL compatible error code: 3666

• Cause: An array or an object cannot be stored in a scalar column.

• Solution: Convert the array or the object to a scalar value, or change the data type of the column to a type that supports arrays or objects.

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

• OceanBase Database error code: 5515

• MySQL compatible error code: 3667

• 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 Database error code: 7227

• MySQL compatible error code: 3674

ERROR 3682 (22S00): Function %.192s is only defined for SRID 0 and SRID 4326.

• OceanBase error code: 7228

• MySQL compatible error code: 3682

ERROR 3704 (22S00): %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.

• OceanBase error code: 7229

• MySQL compatible error code: 3704

ERROR 3705 (22S00): %.192s(%.80s) has not been implemented for projected spatial reference systems.

• OceanBase error code: 7230

• MySQL compatible error code: 3705

ERROR 3706 (SR006): Invalid radius provided to function %s: Radius(%lf) must be greater than zero.

• OceanBase error code: 7284

• MySQL compatible error code: 3706

ERROR 3708 (SR006): Missing mandatory attribute %s.

• OceanBase error code: 7231

• MySQL compatible error code: 3708

ERROR 3709 (SR006): Multiple definitions of attribute %s.

• OceanBase error code: 7232

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible error code: 3711

ERROR 3712 (SR004): There is already a spatial reference system with SRID %u.

• OceanBase error code: 7235

• MySQL compatible error code: 3712

ERROR 3713 (01S00): There is already a spatial reference system with SRID %u.

• OceanBase error code: 7236

• MySQL compatible error code: 3713

ERROR 3714 (SR000): SRID 0 is not modifiable.

• OceanBase error code: 7237

• MySQL compatible 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

• MySQL compatible error code: 3715

ERROR 3716 (SR005): Can't modify SRID %u. There is at least one column depending on it.

• OceanBase error code: 7239

• MySQL compatible error code: 3716

ERROR 3717 (SR006): Invalid character in attribute %s.

• OceanBase error code: 7240

• MySQL compatible error code: 3717

ERROR 3718 (SR006): Attribute %s is too long. The maximum length is %u characters.

• OceanBase error code: 7241

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible error code: 3727

ERROR 3728 (HY000): Spatial indexes can't be primary or unique indexes.

• OceanBase error code: 7244

• MySQL compatible error code: 3728

ERROR 3729 (HY000): The index type %.20s is not supported for spatial indexes.

• OceanBase error code: 7245

• MySQL compatible error code: 3729

ERROR 3729 (HY000): The index type %s is not supported for spatial indexes.

• OceanBase error code: 7281

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible error code: 3736

ERROR 3737 (SR002): The length of the semi-major axis must be a positive number.

• OceanBase error code: 7249

• MySQL compatible 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

• MySQL compatible error code: 3738

ERROR 3739 (SR002): The angular unit conversion factor must be a positive number.

• OceanBase error code: 7251

• MySQL compatible 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

• MySQL compatible error code: 3740

ERROR 3741 (22S00): Transformation from SRID %u is not supported.

• OceanBase error code: 7253

• MySQL compatible error code: 3741

ERROR 3742 (22S00): Transformation to SRID %u is not supported.

• OceanBase error code: 7254

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible 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

• MySQL compatible error code: 3753

ERROR 3754 (HY000): Functional index '%.*s' cannot refer to an auto-increment column.

• OceanBase error code: 5496
• MySQL compatible error code: 3754
• Error reason: When you create a functional index, you use an auto-increment column as part of the functional index. An auto-increment column cannot be part of a functional index.
• Solution: Modify the functional index to remove the auto-increment column or replace it with another column as part of the functional index.

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
• MySQL compatible error code: 3757
• Error reason: When you create a functional index, you use an expression that returns a BLOB or TEXT value. An expression that returns a BLOB or TEXT value cannot be used to create a functional index.
• Solution: Use the CAST function to convert an expression that returns a BLOB or TEXT value to another type. Then, create a functional index based on the converted expression.

ERROR 3758 (HY000): Expression of functional index contains a disallowed function.

• OceanBase error code: 5905
• MySQL compatible error code: 3758
• Error reason: When you create a functional index, you use a function that is not supported. The index function uses SYSDATE or the user environment.
• Solution: The index function must be a pure function (RNDS, RNPS, WNDS, and WNPS).

ERROR 3760 (HY000): Spatial functional index is not supported.

• OceanBase error code: 7258

• MySQL compatible error code: 3760

ERROR 3762 (HY000): Functional index on a column is not supported. Consider using a regular index instead.

• OceanBase error code: 5499
• MySQL compatible error code: 3762
• Error reason: When you create a functional index, the index function is a single column.
• Solution: Use a regular index.

ERROR 3812 (HY000): An expression of non-boolean type specified to a check constraint \'%.*s\'

• OceanBase error code: 5987

• MySQL compatible error code: 3812

ERROR 3813 (HY000): Column check constraint \'%.*s\' references other column

• OceanBase error code: 5786

• MySQL compatible error code: 3813

ERROR 3814 (HY000): An expression of a check constraint \'%.*s\' contains disallowed function: %.*s

• OceanBase error code: 5991

• MySQL compatible error code: 3814

ERROR 3815 (HY000): An expression of a check constraint \'%.*s\' contains disallowed function

• OceanBase error code: 5992

• MySQL compatible 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

• MySQL compatible error code: 3816

ERROR 3818 (HY000): Check constraint \'%.*s\' cannot refer to an auto-increment column

• OceanBase error code: 5990

• MySQL compatible error code: 3818

ERROR 3819 (HY000): check constraint violated

• OceanBase error code: 5693

• MySQL compatible error code: 3819

ERROR 3820 (HY000): Check constraint \'%.*s\' refers to non-existing column \'%.*s\'

• OceanBase Database error code: 5994

• MySQL compatible error code: 3820

ERROR 3821 (HY000): Check constraint \'%.*s\' is not found in the table

• OceanBase Database error code: 5988

• MySQL compatible error code: 3821

ERROR 3822 (HY000): Duplicate check constraint name \'%.*s\'

• OceanBase Database error code: 5678

• MySQL compatible error code: 3822

ERROR 3837 (HY000): Column '%.*s' has a functional index dependency and cannot be dropped or renamed.

• OceanBase Database error code: 5497
• MySQL compatible error code: 3837
• Cause: The column to be dropped has a functional index dependency. Therefore, it cannot be directly dropped or renamed.
• Solution:
  • Drop the functional index: If the column to be dropped is part of a functional index, drop the functional index first and then drop the column.
  • Modify the functional index: If the column to be dropped is part of a functional index, modify the functional index to remove the column from the index and then drop the column.

ERROR 3853 (22032): Invalid JSON type in argument, should be object.

• OceanBase Database error code: 6285

• MySQL compatible error code: 3853

• Cause: An invalid JSON type is used in the parameter, and the actual type is an object.

• Solution: Make sure that the parameter is a valid JSON object 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 Database error code: 5502
• MySQL compatible error code: 3855
• Cause: The column has a partitioning function dependency. Therefore, it cannot be dropped or renamed.

ERROR 3939 (HY000): Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause

• OceanBase Database error code: 5986

• MySQL compatible error code: 3939

ERROR 3940 (HY000): Constraint \'%.*s\' does not exist

• OceanBase Database error code: 5692

• MySQL compatible 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 Database error code: 5989

• MySQL compatible 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 Database error code: 11000

• MySQL compatible 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: Make sure 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 Database error code: 11001

• MySQL compatible error code: 3943

• Cause: DEFAULT values cannot be used in the VALUES clause, unless it is used as a data source in an INSERT statement.

• Solution: Do not use DEFAULT values in the 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 Database error code: 5859

• MySQL compatible error code: 3959

ERROR 3966 (22035): No value was found by '%.192s' on the specified path

• OceanBase Database error code: 5432

• MySQL compatible error code: 3966

ERROR 3967 (22035): More than one value was found by '%.192s' on the specified path

• OceanBase Database error code: 5433

• MySQL compatible error code: 3967