0001 to 3999

These error codes are compatible with specific MySQL error codes.

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

• Error code in OceanBase Database: 5158

• Error code in MySQL: 1007

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

• Error code in OceanBase Database: 5166

• Error code in MySQL: 1008

ERROR 1017 (HY000): File not exist

• Error code in OceanBase Database: 4027

• Error code in MySQL: 1017

ERROR 1018 (HY000): Directory not exist

• Error code in OceanBase Database: 4066

• Error code in MySQL: 1018

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

• Error code in OceanBase Database: 5595

• Error code in MySQL: 1022

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

• Error code in OceanBase Database: 5215

• Error code in MySQL: 1025

ERROR 1040 (08004): Too many connections

• Error code in OceanBase Database: 5271

• Error code in MySQL: 1040

ERROR 1041 (53000): Out of resource

• Error code in OceanBase Database: 4153

• Error code in MySQL: 1041

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

• Error code in OceanBase Database: 5170

• Error code in MySQL: 1044

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

• Error code in OceanBase Database: 4043

• Error code in MySQL: 1045

ERROR 1046 (3D000): No database selected

• Error code in OceanBase Database: 5134

• Error code in MySQL: 1046

ERROR 1047 (HY001): Unknown packet

• Error code in OceanBase Database: 4118

• Error code in MySQL: 1047

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

• Error code in OceanBase Database: 4235

• Error code in MySQL: 1048

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

• Error code in OceanBase Database: 5154

• Error code in MySQL: 1049

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

• Error code in OceanBase Database: 5020

• Error code in MySQL: 1050

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

• Error code in OceanBase Database: 5201

• Error code in MySQL: 1051

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

• Error code in OceanBase Database: 5207

• Error code in MySQL: 1052

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

• Error code in OceanBase Database: 5217

• Error code in MySQL: 1054

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

• Error code in OceanBase Database: 5218

• Error code in MySQL: 1055

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

• Error code in OceanBase Database: 5206

• Error code in MySQL: 1056

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

• Error code in OceanBase Database: 5179 and 9526

• Error code in MySQL: 1059

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

• Error code in OceanBase Database: 5404

• Error code in MySQL: 1060

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

• Error code in OceanBase Database: 5025

• Error code in MySQL: 1061

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

• Error code in OceanBase Database: 5024

• Error code in MySQL: 1062

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

• Error code in OceanBase Database: 5165

• Error code in MySQL: 1063

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

• Error code in OceanBase Database: 5000

• Error code in MySQL: 1064

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

• Error code in OceanBase Database: 5001

• Error code in MySQL: 1064

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

• Error code in OceanBase Database: 5282

• Error code in MySQL: 1064

ERROR 1065 (42000): Query was empty

• Error code in OceanBase Database: 5253

• Error code in MySQL: 1065

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

• Error code in OceanBase Database: 5208

• Error code in MySQL: 1066

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

• Error code in OceanBase Database: 5173

• Error code in MySQL: 1067

ERROR 1068 (42000): Multiple primary key defined

• Error code in OceanBase Database: 5210

• Error code in MySQL: 1068

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

• Error code in OceanBase Database: 5194

• Error code in MySQL: 1069

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

• Error code in OceanBase Database: 5195

• Error code in MySQL: 1070

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

• Error code in OceanBase Database: 5196

• Error code in MySQL: 1071

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

• Error code in OceanBase Database: 5211

• Error code in MySQL: 1072

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

• Error code in OceanBase Database: 5198

• Error code in MySQL: 1074

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

• Error code in OceanBase Database: 9577

• Error code in MySQL: 1074

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

• Error code in OceanBase Database: 5193

• Error code in MySQL: 1075

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

• Error code in OceanBase Database: 4662

• Error code in MySQL: 1078

ERROR 1082 (42S12): Illegal index

• Error code in OceanBase Database: 5028

• Error code in MySQL: 1082

ERROR 1082 (42000): Index unavailable

• Error code in OceanBase Database: 5073

• Error code in MySQL: 1082

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

• Error code in OceanBase Database: 5295

• Error code in MySQL: 1083

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

• Error code in OceanBase Database: 5609

• Error code in MySQL: 1083

ERROR 1083 (HY000): First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY

• Error code in OceanBase Database: 5610

• Error code in MySQL: 1083

ERROR 1086 (58000): File already exist

• Error code in OceanBase Database: 4117

• Error code in MySQL: 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

• Error code in OceanBase Database: 5190

• Error code in MySQL: 1089

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

• Error code in OceanBase Database: 5187

• Error code in MySQL: 1090

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

• Error code in OceanBase Database: 5209

• Error code in MySQL: 1091

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

• Error code in OceanBase Database: 5174

• Error code in MySQL: 1093

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

• Error code in OceanBase Database: 4174

• Error code in MySQL: 1094

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

• Error code in OceanBase Database: 5251

• Error code in MySQL: 1095

ERROR 1096 (HY000): No tables used

• Error code in OceanBase Database: 5185

• Error code in MySQL: 1096

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

• Error code in OceanBase Database: 5336

• Error code in MySQL: 1097

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

• Error code in OceanBase Database: 5430

• Error code in MySQL: 1101

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

• Error code in OceanBase Database: 5162

• Error code in MySQL: 1102

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

• Error code in OceanBase Database: 5163

• Error code in MySQL: 1103

ERROR 1105 (42000): invalid xpath expression

• Error code in OceanBase Database: 7404

• Error code in MySQL: 1105

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

• Solution: Make sure that the XPath expression and XML data are correct.

ERROR 1105 (42000): Given XPATH expression not supported

• Error code in OceanBase Database: 7409

• Error code in MySQL: 1105

• Cause: The specified XPath expression is not supported.

• Solution: Make sure that the specified XPath expression is valid and is supported by the current database version.

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

• Error code in OceanBase Database: 5406

• Error code in MySQL: 1108

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

• Error code in OceanBase Database: 5200

• Error code in MySQL: 1109

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

• Error code in OceanBase Database: 4228

• Error code in MySQL: 1110

ERROR 1111 (HY000): Invalid use of group function

• Error code in OceanBase Database: 5176

• Error code in MySQL: 1111

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

• Error code in OceanBase Database: 5904

• Error code in MySQL: 1113

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

• Error code in OceanBase Database: 5142

• Error code in MySQL: 1115

ERROR 1117 (42000): Too many columns

• Error code in OceanBase Database: 5197

• Error code in MySQL: 1117

ERROR 1118 (42000): Row size too large

• Error code in OceanBase Database: 5199

• Error code in MySQL: 1118

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

• Error code in OceanBase Database: 4291

• Error code in MySQL: 1122

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

• Error code in OceanBase Database: 4292

• Error code in MySQL: 1123

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

• Error code in OceanBase Database: 4293

• Error code in MySQL: 1124

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

• Error code in OceanBase Database: 4294

• Error code in MySQL: 1125

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

• Error code in OceanBase Database: 4295

• Error code in MySQL: 1126

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

• Error code in OceanBase Database: 4296

• Error code in MySQL: 1127

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

• Error code in OceanBase Database: 4042

• Error code in MySQL: 1133

ERROR 1133 (42000): Incorrect password

• Error code in OceanBase Database: 5038

• Error code in MySQL: 1133

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

• Error code in OceanBase Database: 5168

• Error code in MySQL: 1136

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

• Error code in OceanBase Database: 5175

• Error code in MySQL: 1136

ERROR 1138 (22004): Invalid use of NULL value

• Error code in OceanBase Database: 5596

• Error code in MySQL: 1138

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

• Error code in OceanBase Database: 5115

• Error code in MySQL: 1139

ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

• Error code in OceanBase Database: 5221

• Error code in MySQL: 1140

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

• Error code in OceanBase Database: 11008

• Error code in MySQL: 1141

• Cause: The '%.*s' user is not granted the privilege on the '%.*s' host.

• Solution: Make sure that the '%.*s' user is granted the privilege on the '%.*s' host, and that the privilege is correctly defined.

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

• Error code in OceanBase Database: 5171

• Error code in MySQL: 1142

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

• Error code in OceanBase Database: 5183

• Error code in MySQL: 1144

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

• Error code in OceanBase Database: 5019

• Error code in MySQL: 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

• Error code in OceanBase Database: 5006

• Error code in MySQL: 1149

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

• Error code in OceanBase Database: 4254

• Error code in MySQL: 1153

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

• Error code in OceanBase Database: 5164

• Error code in MySQL: 1166

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

• Error code in OceanBase Database: 5216

• Error code in MySQL: 1167

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

• Error code in OceanBase Database: 5030

• Error code in MySQL: 1171

ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

• Error code in OceanBase Database: 5256

• Error code in MySQL: 1171

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

• Error code in OceanBase Database: 5294

• Error code in MySQL: 1172

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

• Error code in OceanBase Database: 5047

• Error code in MySQL: 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

• Error code in OceanBase Database: 5865

• Error code in MySQL: 1175

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

• Error code in OceanBase Database: 5289

• Error code in MySQL: 1176

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

• Error code in OceanBase Database: 5236

• Error code in MySQL: 1192

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

• Error code in OceanBase Database: 5044

• Error code in MySQL: 1193

ERROR 1203 (42000): Too many sessions

• Error code in OceanBase Database: 5059

• Error code in MySQL: 1203

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

• Error code in OceanBase Database: 6003

• Error code in MySQL: 1205

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

• Error code in OceanBase Database: 6006

• Error code in MySQL: 1205

ERROR 1210 (HY000): Incorrect arguments to %s

• Error code in OceanBase Database: 4002

• Error code in MySQL: 1210

ERROR 1210 (HY000): Miss argument for %s

• Error code in OceanBase Database: 4272

• Error code in MySQL: 1210

ERROR 1210 (HY000): Miss argument for %s

• Error code in OceanBase Database: 4277

• Error code in MySQL: 1210

ERROR 1213 (HY000): Deadlock

• Error code in OceanBase Database: 4101

• Error code in MySQL: 1213

ERROR 1215 (HY000): Cannot add foreign key constraint

• Error code in OceanBase Database: 5317

• Error code in MySQL: 1215

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

• Error code in OceanBase Database: 5182

• Error code in MySQL: 1221

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

• Error code in OceanBase Database: 9641

• Error code in MySQL: 1221

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

• Error code in OceanBase Database: 5007

• Error code in MySQL: 1222

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

• Error code in OceanBase Database: 4299

• Error code in MySQL: 1225

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

• Error code in OceanBase Database: 5967

• Error code in MySQL: 1226

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

• Error code in OceanBase Database: 5036

• Error code in MySQL: 1227

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

• Error code in OceanBase Database: 5100

• Error code in MySQL: 1228

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

• Error code in OceanBase Database: 5101

• Error code in MySQL: 1229

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

• Error code in OceanBase Database: 4256

• Error code in MySQL: 1230

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

• Error code in OceanBase Database: 5145

• Error code in MySQL: 1231

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

• Error code in OceanBase Database: 5180

• Error code in MySQL: 1232

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

• Error code in OceanBase Database: 5213

• Error code in MySQL: 1234

ERROR 1235 (0A000): %s not supported

• Error code in OceanBase Database: 4007

• Error code in MySQL: 1235

ERROR 1235 (42000): This version of MySQL doesn't yet support 'non-string DEFAULT value for a column in a JSON_TABLE expression'

• Error code in OceanBase Database: 5517

• Error code in MySQL: 1235

• Cause: In the MySQL 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 OceanBase Database to the latest version or modify the default value of the column to the string type.

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

• Error code in OceanBase Database: 6284

• Error code in MySQL: 1235

• Cause: You cannot use references in a JSON schema in the current version of OceanBase Database.

• Solution: Modify the design of the JSON schema 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'

• Error code in OceanBase Database: 9581

• Error code in MySQL: 1235

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

• Error code in OceanBase Database: 5103

• Error code in MySQL: 1238

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

• Error code in OceanBase Database: 5318

• Error code in MySQL: 1239

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

• Error code in OceanBase Database: 5042

• Error code in MySQL: 1241

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

• Error code in OceanBase Database: 5043

• Error code in MySQL: 1243

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

• Error code in OceanBase Database: 5153

• Error code in MySQL: 1242

ERROR 1243 (HY000): Unknown prepared statement handle

• Error code in OceanBase Database: 5560

• Error code in MySQL: 1243

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

• Error code in OceanBase Database: 5225

• Error code in MySQL: 1247

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

• Error code in OceanBase Database: 5238

• Error code in MySQL: 1250

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

• Error code in OceanBase Database: 5238

• Error code in MySQL: 1252

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

• Error code in OceanBase Database: 5144

• Error code in MySQL: 1253

ERROR 1259 (HY000): ZLIB: Input data corrupted

• Error code in OceanBase Database: 5124

• Error code in MySQL: 1259

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

• Error code in OceanBase Database: 5254

• Error code in MySQL: 1260

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

• Error code in OceanBase Database: 5611

• Error code in MySQL: 1261

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

• Error code in OceanBase Database: 5612

• Error code in MySQL: 1262

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

• Error code in OceanBase Database: 4224

• Error code in MySQL: 1264

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

• Error code in OceanBase Database: 5088

• Error code in MySQL: 1264

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

• Error code in OceanBase Database: 5089

• Error code in MySQL: 1264

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

• Error code in OceanBase Database: 5093

• Error code in MySQL: 1264

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

• Error code in OceanBase Database: 5229

• Error code in MySQL: 1264

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

• Error code in OceanBase Database: 4249

• Error code in MySQL: 1265

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

• Error code in OceanBase Database: 4252

• Error code in MySQL: 1265

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

• Error code in OceanBase Database: 5177

• Error code in MySQL: 1267

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

• Error code in OceanBase Database: 5143

• Error code in MySQL: 1273

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

• Error code in OceanBase Database: 5224

• Error code in MySQL: 1280

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

• Error code in OceanBase Database: 5288

• Error code in MySQL: 1283

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

• Error code in OceanBase Database: 7289

• Error code in MySQL: 1283

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

• Solution: Make sure that the columns in the FTS index to be created are of text types, such as VARCHAR, TEXT, and CHAR.

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

• Error code in OceanBase Database: 5259

• Error code in MySQL: 1286

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

• Error code in OceanBase Database: 5516

• Error code in MySQL: 1287

• Cause: This syntax is not supported and will be deleted in later versions.

• Solution: Use the SET variable=expression, ... or SELECT expression(s) INTO variables(s) syntax instead.

ERROR 1288 (HY000): The target table %.*s of the %.*s is not updatable

• Error code in OceanBase Database: 5228

• Error code in MySQL: 1288

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

• Error code in OceanBase Database: 5233

• Error code in MySQL: 1290

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

• Error code in OceanBase Database: 5334

• Error code in MySQL: 1291

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

• Error code in OceanBase Database: 4158

• Error code in MySQL: 1292

ERROR 1292 (22007): Incorrect value

• Error code in OceanBase Database: 4190

• Error code in MySQL: 1292

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

• Error code in OceanBase Database: 4262

• Error code in MySQL: 1292

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

• Error code in OceanBase Database: 4219

• Error code in MySQL: 1292

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

• Error code in OceanBase Database: 5222

• Error code in MySQL: 1292

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

• Error code in OceanBase Database: 5172

• Error code in MySQL: 1294

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

• Error code in OceanBase Database: 5568

• Error code in MySQL: 1295

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

• Error code in OceanBase Database: 5192

• Error code in MySQL: 1298

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

• Error code in OceanBase Database: 5250

• Error code in MySQL: 1300

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

• Error code in OceanBase Database: 5316

• Error code in MySQL: 1301

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

• Error code in OceanBase Database: 5858

• Error code in MySQL: 1302

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

• Error code in OceanBase Database: 5582

• Error code in MySQL: 1303

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

• Error code in OceanBase Database: 5541

• Error code in MySQL: 1304

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

• Error code in OceanBase Database: 5055

• Error code in MySQL: 1305

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

• Error code in OceanBase Database: 5542

• Error code in MySQL: 1305

ERROR 1305 (42000): savepoint does not exist

• Error code in OceanBase Database: 6242

• Error code in MySQL: 1305

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

• Error code in OceanBase Database: 5546 and 9505

• Error code in MySQL: 1308

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

• Error code in OceanBase Database: 5593

• Error code in MySQL: 1308

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

• Error code in OceanBase Database: 9579

• Error code in MySQL: 1309

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

• Error code in OceanBase Database: 5583

• Error code in MySQL: 1313

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

• Error code in OceanBase Database: 9580

• Error code in MySQL: 1314

ERROR 1317 (70100): Query execution was interrupted

• Error code in OceanBase Database: 5065

• Error code in MySQL: 1317

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

• Error code in OceanBase Database: 5555

• Error code in MySQL: 1318

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

• Error code in OceanBase Database: 5545

• Error code in MySQL: 1319

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

• Error code in OceanBase Database: 9575

• Error code in MySQL: 1320

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

• Error code in OceanBase Database: 5580

• Error code in MySQL: 1321

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

• Error code in OceanBase Database: 5584

• Error code in MySQL: 1323

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

• Error code in OceanBase Database: 5547

• Error code in MySQL: 1324

ERROR 1325 (24000): Cursor is already open

• Error code in OceanBase Database: 5589

• Error code in MySQL: 1325

ERROR 1326 (24000): Cursor is not open

• Error code in OceanBase Database: 5590

• Error code in MySQL: 1326

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

• Error code in OceanBase Database: 5543

• Error code in MySQL: 1327

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

• Error code in OceanBase Database: 5544

• Error code in MySQL: 1327

ERROR 1328 (HY000): Incorrect number of FETCH variables

• Error code in OceanBase Database: 5554

• Error code in MySQL: 1328

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

• Error code in OceanBase Database: 4026

• Error code in MySQL: 1329

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

• Error code in OceanBase Database: 5548

• Error code in MySQL: 1330

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

• Error code in OceanBase Database: 5550

• Error code in MySQL: 1330

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

• Error code in OceanBase Database: 5552

• Error code in MySQL: 1330

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

• Error code in OceanBase Database: 5549

• Error code in MySQL: 1331

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

• Error code in OceanBase Database: 5551

• Error code in MySQL: 1332

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

• Error code in OceanBase Database: 5553

• Error code in MySQL: 1333

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

• Error code in OceanBase Database: 5569

• Error code in MySQL: 1336

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

• Error code in OceanBase Database: 5586

• Error code in MySQL: 1337

ERROR 1338 (42000): Cursor declaration after handler declaration

• Error code in OceanBase Database: 5587

• Error code in MySQL: 1338

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

• Error code in OceanBase Database: 5571

• Error code in MySQL: 1339

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

• Error code in OceanBase Database: 5214

• Error code in MySQL: 1347

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

• Error code in OceanBase Database: 5719

• Error code in MySQL: 1348

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

• Error code in OceanBase Database: 4238

• Error code in MySQL: 1349

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

• Error code in OceanBase Database: 5503

• Error code in MySQL: 1350

• Cause: The SELECT statement that you use to query the view contains the INTO clause.

• Solution: Remove the INTO clause from the SELECT statement that you use to query the view.

ERROR 1353 (HY000): View's SELECT and view's field list have different column counts

• Error code in OceanBase Database: 5740

• Error code in MySQL: 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

• Error code in OceanBase Database: 5231

• Error code in MySQL: 1356

ERROR 1360 (HY000): Trigger does not exist

• Error code in OceanBase Database: 5733

• Error code in MySQL: 1360

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

• Error code in OceanBase Database: 9584

• Error code in MySQL: 1362

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

• Error code in OceanBase Database: 9640

• Error code in MySQL: 1363

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

• Error code in OceanBase Database: 4227

• Error code in MySQL: 1364

ERROR 1365 (22012): Divided by zero

• Error code in OceanBase Database: 4078

• Error code in MySQL: 1365

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

• Error code in OceanBase Database: 4219

• Error code in MySQL: 1366

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

• Error code in OceanBase Database: 4226

• Error code in MySQL: 1366

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

• Error code in OceanBase Database: 4258

• Error code in MySQL: 1366

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

• Error code in OceanBase Database: 5332

• Error code in MySQL: 1367

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

• Error code in OceanBase Database: 5972

• Error code in MySQL: 1368

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

• Error code in OceanBase Database: 5971

• Error code in MySQL: 1369

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

• Error code in OceanBase Database: 5387

• Error code in MySQL: 1370

• Cause: Command issuance is denied.

• Solution: Verify whether you have required privileges and whether the stored procedure or function has spelling errors.

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

• Error code in OceanBase Database: 5405

• Error code in MySQL: 1382

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

• Error code in OceanBase Database: 5080

• Error code in MySQL: 1390

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

• Error code in OceanBase Database: 5191

• Error code in MySQL: 1391

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

• Error code in OceanBase Database: 5718

• Error code in MySQL: 1393

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

• Error code in OceanBase Database: 5720

• Error code in MySQL: 1395

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

• Error code in OceanBase Database: 5155

• Error code in MySQL: 1396

ERROR 1397 (XAE04): Unknown XID

• Error code in OceanBase Database: 6245

• Error code in MySQL: 1397

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

• Error code in OceanBase Database: 6249

• Error code in MySQL: 1398

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

• Error code in OceanBase Database: 6246

• Error code in MySQL: 1399

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

• Error code in OceanBase Database: 6258

• Error code in MySQL: 1399

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

• Error code in OceanBase Database: 6248

• Error code in MySQL: 1400

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

• Error code in OceanBase Database: 6250

• Error code in MySQL: 1401

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

• Error code in OceanBase Database: 6252

• Error code in MySQL: 1402

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

• Error code in OceanBase Database: 5167

• Error code in MySQL: 1406

ERROR 1406 (22001): Data too long for column

• Error code in OceanBase Database: 5354

• Error code in MySQL: 1406

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

• Error code in OceanBase Database: 5585

• Error code in MySQL: 1407

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

• Error code in OceanBase Database: 5169

• Error code in MySQL: 1410

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

• Error code in OceanBase Database: 5936

• Error code in MySQL: 1411

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

• Error code in OceanBase Database: 5581

• Error code in MySQL: 1413

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

• Error code in OceanBase Database: 5592

• Error code in MySQL: 1414

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

• Error code in OceanBase Database: 5579

• Error code in MySQL: 1415

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

• Error code in OceanBase Database: 7276

• Error code in MySQL: 1416

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

• Error code in OceanBase Database: 5576

• Error code in MySQL: 1422

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

• Error code in OceanBase Database: 9576

• Error code in MySQL: 1422

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

• Error code in OceanBase Database: 5570

• Error code in MySQL: 1424

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

• Error code in OceanBase Database: 5202

• Error code in MySQL: 1425

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

• Error code in OceanBase Database: 5203

• Error code in MySQL: 1426

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

• Error code in OceanBase Database: 5204

• Error code in MySQL: 1427

ERROR 1435 (HY000): Trigger in wrong schema

• Error code in OceanBase Database: 9582

• Error code in MySQL: 1435

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

• Error code in OceanBase Database: 5205

• Error code in MySQL: 1439

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

• Error code in OceanBase Database: 9578

• Error code in MySQL: 1439

ERROR 1440 (XAE08): The XID already exists

• Error code in OceanBase Database: 6247

• Error code in MySQL: 1440

ERROR 1441 (22008): Datetime overflow

• Error code in OceanBase Database: 4261

• Error code in MySQL: 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

• Error code in OceanBase Database: 5791

• Error code in MySQL: 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

• Error code in OceanBase Database: 11016

• Error code in MySQL: 1444

• Cause: The prepared statement contains recursive calls to itself.

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

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

• Error code in OceanBase Database: 5591

• Error code in MySQL: 1445

ERROR 1449 (HY000): User not exist

• Error code in OceanBase Database: 5035

• Error code in MySQL: 1449

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

• Error code in OceanBase Database: 5314

• Error code in MySQL: 1451

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

• Error code in OceanBase Database: 5618

• Error code in MySQL: 1451

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

• Error code in OceanBase Database: 5315

• Error code in MySQL: 1452

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

• Error code in OceanBase Database: 5567

• Error code in MySQL: 1456

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

• Error code in OceanBase Database: 5588

• Error code in MySQL: 1458

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

• Error code in OceanBase Database: 5239

• Error code in MySQL: 1462

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

• Error code in OceanBase Database: 5247

• Error code in MySQL: 1466

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

• Error code in OceanBase Database: 5184

• Error code in MySQL: 1467

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

• Error code in OceanBase Database: 5181

• Error code in MySQL: 1470

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

• Error code in OceanBase Database: 5717

• Error code in MySQL: 1471

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

• Error code in OceanBase Database: 5246

• Error code in MySQL: 1474

ERROR 1475 (42000): Ambiguous column

• Error code in OceanBase Database: 5015

• Error code in MySQL: 1475

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

• Error code in OceanBase Database: 5878

• Error code in MySQL: 1480

• Cause: The VALUES LESS THAN clause can be used only in the partition definition for RANGE partitioning.

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

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

• Error code in OceanBase Database: 5230

• Error code in MySQL: 1486

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

• Error code in OceanBase Database: 5255

• Error code in MySQL: 1488

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

• Error code in OceanBase Database: 5257

• Error code in MySQL: 1491

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

• Error code in OceanBase Database: 5281

• Error code in MySQL: 1493

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

• Error code in OceanBase Database: 5353

• Error code in MySQL: 1493

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

• Error code in OceanBase Database: 5340

• Error code in MySQL: 1495

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

• Error code in OceanBase Database: 5188

• Error code in MySQL: 1499

ERROR 1500 (HY000): It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning

• Error code in OceanBase Database: 4398
• Error code in MySQL: 1500
• Cause: You have specified an incompatible partitioning method when you create the partitioned table. For example, you may have specified RANGE-LIST partitioning and HASH-KEY partitioning.
• Solution:
  • Change the partitioning method. If you want to use both RANGE-LIST partitioning and HASH-KEY partitioning, you can use a compatible partitioning method. Note that changing the partitioning method or partitioning a partitioned table may affect the existing data and applications. Proceed with caution.
  • Separate the partitions: If you need to use incompatible partitioning methods, you can split the partitioned table into multiple tables and use different partitioning methods for the tables.

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

• Error code in OceanBase Database: 5261

• Error code in MySQL: 1503

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

• Error code in OceanBase Database: 5283

• Error code in MySQL: 1503

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

• Error code in OceanBase Database: 5189

• Error code in MySQL: 1504

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

• Error code in OceanBase Database: 5302

• Error code in MySQL: 1505

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

• Error code in OceanBase Database: 5303

• Error code in MySQL: 1507

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

• Error code in OceanBase Database: 5306

• Error code in MySQL: 1508

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

• Error code in OceanBase Database: 5305

• Error code in MySQL: 1512

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

• Error code in OceanBase Database: 5280

• Error code in MySQL: 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 mode since version 4.2.0. Therefore, the same error code is used for both partitions and subpartitions in MySQL tenants of OceanBase Database.
• Solution: Use another partition name or delete the existing partition with the name.

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

• Error code in OceanBase Database: 5494
• Error code in MySQL: 1517
• Cause: Partition names are duplicate.
• Solution: Use another name or delete the existing partition or subpartition with the name.

ERROR 1517 (HY000): missing or invalid WAIT interval

• Error code in OceanBase Database: 5495
• Error code in MySQL: 1517
• Cause: When you run the WAIT command, the specified wait time parameter is invalid or missing.
• Solution: Check the syntax of the WAIT command and make sure that the wait time parameter is correctly specified.

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

• Error code in OceanBase Database: 5566

• Error code in MySQL: 1520

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

• Error code in OceanBase Database: 11003

• Error code in MySQL: 1524

• Cause:

  • The input plug-in type is not supported.
  • The input plug-in type is supported but the plug-in is not correctly loaded. At present, OceanBase Database supports only the mysql_native_password plug-in type.

• Solution:

  • Check whether the plug-in type is supported.
  • Check whether the plug-in loading statement, plug-in configuration file, and plug-in version are correct.
  • Check whether you have sufficient privileges to load and install plug-ins.

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

• Error code in OceanBase Database: 5241

• Error code in MySQL: 1525

ERROR 1525 (HY000): XML parsing failed

• Error code in OceanBase Database: 9549

• Error code in MySQL: 1525

• Cause: The XML parser returns an error when it parses a document.

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

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

• Error code in OceanBase Database: 5284

• Error code in MySQL: 1526

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

• Error code in OceanBase Database: 9768

• Error code in MySQL: 1537

• Cause: The event to be created already exists.

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

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

• Error code in OceanBase Database: 9769

• Error code in MySQL: 1539

• Cause: You are attempting to access or operate an event that does not exist.

• Solution: Make sure that the event name is correct and the event exists.

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

• Error code in OceanBase Database: 9770

• Error code in MySQL: 1540

• Cause: Your attempt to modify an event failed.

• Solution: Make sure that the syntax of the ALTER EVENT statement is correct and contains the attribute to be modified and its value.

ERROR 1541 (HY000): Failed to drop %.*s

• Error code in OceanBase Database: 9771

• Error code in MySQL: 1541

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

• Solution: Use the corresponding statement to verify the name and existence of the object.

ERROR 1542 (HY000): INTERVAL is either not positive or too big

• Error code in OceanBase Database: 9772

• Error code in MySQL: 1542

• Cause: When you define an event, the specified interval is not a positive value or exceeds the maximum value allowed.

• Solution: Make sure that the INTERVAL value is positive and within a reasonable range.

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

• Error code in OceanBase Database: 9773

• Error code in MySQL: 1543

• Cause: The end time of the event is invalid or earlier than the start time.

• Solution: Make sure that the end time of the event is valid and later than the start time.

ERROR 1544 (HY000): Event execution time is in the past. Event has been disabled

• Error code in OceanBase Database: 9774

• Error code in MySQL: 1544

• Cause: The start time of the event specified during creation is earlier than the current time.

• Solution: Change the start time of the event to a later point in time.

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

• Error code in OceanBase Database: 9775

• Error code in MySQL: 1549

• Cause: Your attempt to drop an event from the mysql.event table failed.

• Solution: Make sure that you have the privilege to drop events.

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

• Error code in OceanBase Database: 9776

• Error code in MySQL: 1551

• Cause: The new name is the same as the existing name when you are attempting to rename an event.

• Solution: Specify a different event name in the ALTER EVENT statement.

ERROR 1552 (HY000): Data for column '%.*s' too long

• Error code in OceanBase Database: 9777

• Error code in MySQL: 1552

• Cause: You are attempting to insert data into a column that exceeds the length limit of the column.

• Solution: Reduce the length of the data to be inserted to ensure that it does not exceed the length limit of the column.

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

• Error code in OceanBase Database: 5310

• Error code in MySQL: 1562

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

• Error code in OceanBase Database: 5286

• Error code in MySQL: 1563

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

• Error code in OceanBase Database: 5262

• Error code in MySQL: 1564

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

• Error code in OceanBase Database: 5285

• Error code in MySQL: 1566

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

• Error code in OceanBase Database: 11002

• Error code in MySQL: 1567

• Cause: The partition name is incorrect.

• Solution: Check whether the partition name is correct.

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

• Error code in OceanBase Database: 5219

• Error code in MySQL: 1568

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

• Error code in OceanBase Database: 9780

• Error code in MySQL: 1576

• Cause: A DDL operation is attempting to directly or indirectly modify itself. When the definition of an event contains a body, it is prohibited to recursively execute the DDL statement of the event.

• Solution: Make sure that the DDL statement does not directly or indirectly reference an event that is being created or modified.

ERROR 1582 (42000): Incorrect parameter count in the call to native function '%.*s'

• Error code in OceanBase Database: 5054

• Error code in MySQL: 1582

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

• Error code in OceanBase Database: 5407

• Error code in MySQL: 1583

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

• Error code in OceanBase Database: 6253

• Error code in MySQL: 1613

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

• Error code in OceanBase Database: 5102

• Error code in MySQL: 1621

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

• Error code in OceanBase Database: 4229

• Error code in MySQL: 1628

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

• Error code in OceanBase Database: 4230

• Error code in MySQL: 1629

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

• Error code in OceanBase Database: 9701

• Error code in MySQL: 1642

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

• Error code in OceanBase Database: 5556

• Error code in MySQL: 1644

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

• Error code in OceanBase Database: 9702

• Error code in MySQL: 1645

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

• Error code in OceanBase Database: 5557

• Error code in MySQL: 1646

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

• Error code in OceanBase Database: 5237

• Error code in MySQL: 1652

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

• Error code in OceanBase Database: 5276

• Error code in MySQL: 1653

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

• Error code in OceanBase Database: 5275

• Error code in MySQL: 1654

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

• Error code in OceanBase Database: 5349

• Error code in MySQL: 1654

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

• Error code in OceanBase Database: 5355

• Error code in MySQL: 1654

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

• Error code in OceanBase Database: 5287

• Error code in MySQL: 1655

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

• Error code in OceanBase Database: 5277

• Error code in MySQL: 1657

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

• Error code in OceanBase Database: 5178

• Error code in MySQL: 1659

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

• Error code in OceanBase Database: 4231

• Error code in MySQL: 1688

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

• Error code in OceanBase Database: 4157

• Error code in MySQL: 1690

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

• Error code in OceanBase Database: 5274

• Error code in MySQL: 1697

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

• Error code in OceanBase Database: 5594

• Error code in MySQL: 1701

ERROR 1706 (HY000): Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'

• Error code in OceanBase Database: 5344

• Error code in MySQL: 1706

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

• Error code in OceanBase Database: 5266

• Error code in MySQL: 1708

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

• Error code in OceanBase Database: 4773

• Error code in MySQL: 1731

• Cause: Some attributes of the partition and the table do not match.

• Solution: Check the attributes of the partition and the table, and make sure that they match.

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

• Error code in OceanBase Database: 11017

• Error code in MySQL: 1732

• Cause: You are attempting to exchange the data of a partition with that of a partitioned table.

• Solution: Exchange the data of the partition with that of a non-partitioned table.

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

• Error code in OceanBase Database: 5146

• Error code in MySQL: 1735

ERROR 1736 (HY000): Tables have different definitions

• Error code in OceanBase Database: 4772

• Error code in MySQL: 1736

• Cause: The two tables have different definitions.

• Solution: Compare the schema definitions of the two tables and make sure that their definitions such as the schema, column type, and number of columns are the same.

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

• Error code in OceanBase Database: 5147

• Error code in MySQL: 1748

ERROR 1758 (35000): Invalid condition number

• Error code in OceanBase Database: 9696

• Error code in MySQL: 1758

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

• Error code in OceanBase Database: 5220

• Error code in MySQL: 1792

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

• Error code in OceanBase Database: 6226

• Error code in MySQL: 1792

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

• Error code in OceanBase Database: 4365

• Error code in MySQL: 1819

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

• Error code in OceanBase Database: 4366

• Error code in MySQL: 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

• Error code in OceanBase Database: 5227

• Error code in MySQL: 1827

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

• Error code in OceanBase Database: 5512

• Error code in MySQL: 1830

• Cause: The NOT NULL constraint cannot be specified on a column because a FOREIGN KEY constraint with the SET NULL action is required for the column.

• Solution: Specify to allow the column to contain NULL values, or modify the FOREIGN KEY constraint to use another action, for example, SET DEFAULT.

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

• Error code in OceanBase Database: 5513

• Error code in MySQL: 1830

• Cause: You cannot define a FOREIGN KEY constraint with the ON DELETE SET NULL clause on a virtual column.

• Solution: Do not define FOREIGN KEY constraints with the ON DELETE SET NULL clause on virtual columns.

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

• Error code in OceanBase Database: 5244

• Error code in MySQL: 1869

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

• Error code in OceanBase Database: 4336

• Error code in MySQL: 1882

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

• Error code in OceanBase Database: 5402

• Error code in MySQL: 3004

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

• Error code in OceanBase Database: 9704

• Error code in MySQL: 3011

ERROR 3020 (2201E): Invalid argument for logarithm

• Error code in OceanBase Database: 5565

• Error code in MySQL: 3020

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

• Error code in OceanBase Database: 5263

• Error code in MySQL: 3028

ERROR 3033 (HY000): Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical

• Error code in OceanBase Database: 7201

• Error code in MySQL: 3033

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

• Error code in OceanBase Database: 7202

• Error code in MySQL: 3034

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

• Error code in OceanBase Database: 7203

• Error code in MySQL: 3035

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

• Error code in OceanBase Database: 7204

• Error code in MySQL: 3036

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

• Error code in OceanBase Database: 7205

• Error code in MySQL: 3037

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

• Error code in OceanBase Database: 7206

• Error code in MySQL: 3038

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

• Error code in OceanBase Database: 7207

• Error code in MySQL: 3039

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

• Error code in OceanBase Database: 7208

• Error code in MySQL: 3040

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

• Error code in OceanBase Database: 7209

• Error code in MySQL: 3041

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

• Error code in OceanBase Database: 7210

• Error code in MySQL: 3042

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

• Error code in OceanBase Database: 7211

• Error code in MySQL: 3043

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

• Error code in OceanBase Database: 7265

• Error code in MySQL: 3044

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

• Error code in OceanBase Database: 7266

• Error code in MySQL: 3045

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

• Error code in OceanBase Database: 7267

• Error code in MySQL: 3046

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

• Error code in OceanBase Database: 7268

• Error code in MySQL: 3047

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

• Error code in OceanBase Database: 7269

• Error code in MySQL: 3048

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

• Error code in OceanBase Database: 7270

• Error code in MySQL: 3049

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

• Error code in OceanBase Database: 5377

• Error code in MySQL: 3530

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

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

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

• Error code in OceanBase Database: 5379

• Error code in MySQL: 3530

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

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

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

• Error code in OceanBase Database: 7271

• Error code in MySQL: 3050

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

• Error code in OceanBase Database: 7272

• Error code in MySQL: 3051

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

• Error code in OceanBase Database: 7273

• Error code in MySQL: 3052

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

• Error code in OceanBase Database: 7274

• Error code in MySQL: 3053

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

• Error code in OceanBase Database: 7275

• Error code in MySQL: 3054

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

• Error code in OceanBase Database: 7212

• Error code in MySQL: 3055

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

• Error code in OceanBase Database: 7213

• Error code in MySQL: 3060

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

• Error code in OceanBase Database: 11013

• Error code in MySQL: 3061

• Cause: The name of the user variable cannot exceed 1024 characters in length.

• Solution: Use a valid user variable name.

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

• Error code in OceanBase Database: 5351

• Error code in MySQL: 3064

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

• Error code in OceanBase Database: 5290

• Error code in MySQL: 3105

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

• Error code in OceanBase Database: 5292

• Error code in MySQL: 3106

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

• Error code in OceanBase Database: 5293

• Error code in MySQL: 3108

ERROR 3118 (HY000): User locked

• Error code in OceanBase Database: 5039

• Error code in MySQL: 3118

ERROR 3122 (HY000): Inconsistent intersection points.

• Error code in OceanBase Database: 7214

• Error code in MySQL: 3122

ERROR 3134 (HY000): Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.

• Error code in OceanBase Database: 7215

• Error code in MySQL: 3134

ERROR 3140 (22032): Invalid JSON text

• Error code in OceanBase Database: 5411

• Error code in MySQL: 3140

ERROR 3141 (22032): Invalid JSON text in argument

• Error code in OceanBase Database: 5412

• Error code in MySQL: 3141

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

• Error code in OceanBase Database: 5413

• Error code in MySQL: 3142

ERROR 3143 (42000): Invalid JSON path expression

• Error code in OceanBase Database: 5414

• Error code in MySQL: 3143

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

• Error code in OceanBase Database: 5415

• Error code in MySQL: 3144

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

• Error code in OceanBase Database: 5416

• Error code in MySQL: 3145

ERROR 3146 (22032): Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required

• Error code in OceanBase Database: 5417

• Error code in MySQL: 3146

ERROR 3147 (22032): Cannot CAST value to JSON

• Error code in OceanBase Database: 5418

• Error code in MySQL: 3147

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

• Error code in OceanBase Database: 5419

• Error code in MySQL: 3148

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

• Error code in OceanBase Database: 5420

• Error code in MySQL: 3149

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

• Error code in OceanBase Database: 5421

• Error code in MySQL: 3150

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

• Error code in OceanBase Database: 5422

• Error code in MySQL: 3151

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

• Error code in OceanBase Database: 9748
• Error code in MySQL: 1351
• Cause: The SELECT statement that you use to query the view contains variables or parameters.
• Solution: Make sure that the query statement does not contain variables or parameters.

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

• Error code in OceanBase Database: 5424

• Error code in MySQL: 3153

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

• Error code in OceanBase Database: 5425

• Error code in MySQL: 3154

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

• Error code in OceanBase Database: 5426

• Error code in MySQL: 3155

ERROR 3156 (22018): Invalid JSON value for CAST

• Error code in OceanBase Database: 5427

• Error code in MySQL: 3156

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

• Error code in OceanBase Database: 5428

• Error code in MySQL: 3157

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

• Error code in OceanBase Database: 5429

• Error code in MySQL: 3158

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

• Error code in OceanBase Database: 11012

• Error code in MySQL: 3162

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

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

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

• Error code in OceanBase Database: 11009

• Error code in MySQL: 3163

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

• Solution: Use a different privilege ID, or delete the existing privilege ID and then retry creating the privilege ID.

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

• Error code in OceanBase Database: 5431

• Error code in MySQL: 3165

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

• Error code in OceanBase Database: 5335

• Error code in MySQL: 3504

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

• Error code in OceanBase Database: 5333

• Error code in MySQL: 3505

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

• Error code in OceanBase Database: 7216

• Error code in MySQL: 3516

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

• Error code in OceanBase Database: 7288

• Error code in MySQL: 3516

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

• Error code in OceanBase Database: 7217

• Error code in MySQL: 3517

ERROR 3518 (SR003): The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.

• Error code in OceanBase Database: 7218

• Error code in MySQL: 3518

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

• Error code in OceanBase Database: 7219

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7220

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7221

• Error code in MySQL: 3521

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

• Error code in OceanBase Database: 11007

• Error code in MySQL: 3523

• Cause: The privilege ID %.*s@%.*s is unknown.

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

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

• Error code in OceanBase Database: 7222

• Error code in MySQL: 3548

ERROR 3548 (SR001): Spatial reference system is empty

• Error code in OceanBase Database: 7285

• Error code in MySQL: 3548

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

• Error code in OceanBase Database: 7286

• Error code in MySQL: 3558

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

• Error code in OceanBase Database: 7287

• Error code in MySQL: 3559

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

• Error code in OceanBase Database: 7283

• Error code in MySQL: 3560

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

• Error code in OceanBase Database: 7223

• Error code in MySQL: 3565

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

• Error code in OceanBase Database: 5742

• Error code in MySQL: 3573

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

• Solution: Use the UNION ALL operation in the recursive CTE.

• Error code in OceanBase Database: 5982

• Error code in MySQL: 3574

ERROR 3575 (HY000): ORDER BY / LIMIT / SELECT DISTINCT / HAVING / WINDOW FUNCTION / GROUP BY in recursive query block of Common Table Expression not supported

• Error code in OceanBase Database: 5758

• Error code in MySQL: 3575

• Cause: The common expression of the recursive query block contains the ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY operator.

• Solution: Do not use the ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY operator in common expressions of recursive query blocks.

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

• Error code in OceanBase Database: 5759

• Error code in MySQL: 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

• Error code in OceanBase Database: 5744

• Error code in MySQL: 3577

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

• Error code in OceanBase Database: 5438

• Error code in MySQL: 3581

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

• Error code in OceanBase Database: 5439

• Error code in MySQL: 3582

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

• Error code in OceanBase Database: 5440

• Error code in MySQL: 3583

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

• Error code in OceanBase Database: 5507

• Error code in MySQL: 3586

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

• Solution: Make sure that the start and end positions of the window are non-negative and non-NULL integers.

ERROR 3587 (HY000): Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type

• Error code in OceanBase Database: 5984

• Error code in MySQL: 3587

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

• Error code in OceanBase Database: 5508

• Error code in MySQL: 3588

• Cause: The window with the RANGE frame contains an ORDER BY expression of the datetime type, which is not allowed.

• Solution: Make sure that the ORDER BY expression of the window with the RANGE frame uses only INTERVAL boundary values and does not use datetime boundary values.

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

• Error code in OceanBase Database: 5509

• Error code in MySQL: 3589

• Cause: The window with the RANGE frame that contains an ORDER BY expression of the numeric type does not support INTERVAL boundary values.

• Solution: Do not use INTERVAL boundary values in windows that contain ORDER BY expressions of the numeric type.

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

• Error code in OceanBase Database: 5510

• Error code in MySQL: 3590

• Cause: The window has non-constant frame boundaries.

• Solution: Make sure that the frame boundaries of the window are constants.

ERROR 3592 (HY000): Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression

• Error code in OceanBase Database: 5985

• Error code in MySQL: 3592

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

• Error code in OceanBase Database: 5983

• Error code in MySQL: 3596

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

• Error code in OceanBase Database: 7263

• Error code in MySQL: 3616

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

• Error code in OceanBase Database: 7264

• Error code in MySQL: 3617

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

• Error code in OceanBase Database: 7224

• Error code in MySQL: 3618

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

• Error code in OceanBase Database: 5408

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7225

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7226

• Error code in MySQL: 3644

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

• Error code in OceanBase Database: 4298

• Error code in MySQL: 3666

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

• Solution: Convert the array or object into a scalar value, or modify the data type of the column so that the column can store the array or object.

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

• Error code in OceanBase Database: 5515

• Error code in MySQL: 3667

• Cause: Each table function must have an alias.

• Solution: Provide an alias for each 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.

• Error code in OceanBase Database: 7227

• Error code in MySQL: 3674

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

• Error code in OceanBase Database: 7228

• Error code in MySQL: 3682

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

• Error code in OceanBase Database: 7229

• Error code in MySQL: 3704

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

• Error code in OceanBase Database: 7230

• Error code in MySQL: 3705

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

• Error code in OceanBase Database: 7284

• Error code in MySQL: 3706

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

• Error code in OceanBase Database: 7231

• Error code in MySQL: 3708

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

• Error code in OceanBase Database: 7232

• Error code in MySQL: 3709

ERROR 3710 (SR006): The spatial reference system name can't be an empty string or start or end with whitespace.

• Error code in OceanBase Database: 7233

• Error code in MySQL: 3710

ERROR 3711 (SR006): The organization name can't be an empty string or start or end with whitespace.

• Error code in OceanBase Database: 7234

• Error code in MySQL: 3711

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

• Error code in OceanBase Database: 7235

• Error code in MySQL: 3712

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

• Error code in OceanBase Database: 7236

• Error code in MySQL: 3713

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

• Error code in OceanBase Database: 7237

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7238

• Error code in MySQL: 3715

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

• Error code in OceanBase Database: 7239

• Error code in MySQL: 3716

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

• Error code in OceanBase Database: 7240

• Error code in MySQL: 3717

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

• Error code in OceanBase Database: 7241

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7242

• Error code in MySQL: 3726

ERROR 3727 (22023): Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.

• Error code in OceanBase Database: 7243

• Error code in MySQL: 3727

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

• Error code in OceanBase Database: 7244

• Error code in MySQL: 3728

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

• Error code in OceanBase Database: 7245

• Error code in MySQL: 3729

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

• Error code in OceanBase Database: 7281

• Error code in MySQL: 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].

• Error code in OceanBase Database: 7246

• Error code in MySQL: 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].

• Error code in OceanBase Database: 7247

• Error code in MySQL: 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.

• Error code in OceanBase Database: 7248

• Error code in MySQL: 3736

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

• Error code in OceanBase Database: 7249

• Error code in MySQL: 3737

ERROR 3738 (SR002): The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.

• Error code in OceanBase Database: 7250

• Error code in MySQL: 3738

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

• Error code in OceanBase Database: 7251

• Error code in MySQL: 3739

ERROR 3740 (SR002): The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.

• Error code in OceanBase Database: 7252

• Error code in MySQL: 3740

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

• Error code in OceanBase Database: 7253

• Error code in MySQL: 3741

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

• Error code in OceanBase Database: 7254

• Error code in MySQL: 3742

ERROR 3743 (22S00): Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

• Error code in OceanBase Database: 7255

• Error code in MySQL: 3743

ERROR 3744 (22S00): Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

• Error code in OceanBase Database: 7256

• Error code in MySQL: 3744

ERROR 3753 (42000): Cannot create a functional index on a function that returns a JSON or GEOMETRY value.

• Error code in OceanBase Database: 7257

• Error code in MySQL: 3753

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

• Error code in OceanBase Database: 5496
• Error code in MySQL: 3754
• Cause: You have used an auto-increment column as part of the function-based index that you want to create.
• Solution: Remove the auto-increment column from the function-based index, or use another column as part of the function-based index.

ERROR 3757 (HY000): Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.

• Error code in OceanBase Database: 5498
• Error code in MySQL: 3757
• Cause: You have used an expression of the BLOB or TEXT type to create a function-based index.
• Solution: Use a CAST function to convert the expression of the BLOB or TEXT type to another type, and then use the converted expression to create the function-based index.

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

• Error code in OceanBase Database: 5905
• Error code in MySQL: 3758
• Cause: You have used an unsupported function to create the function-based index. The SYSDATE function or a user environment is used in the index function.
• Solution: Make sure that the index function is a pure function, such as RNDS, RNPS, WNDS, or WNPS.

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

• Error code in OceanBase Database: 7258

• Error code in MySQL: 3760

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

• Error code in OceanBase Database: 5499
• Error code in MySQL: 3762
• Cause: When you create the function-based index, a single column is used as the index.
• Solution: Use a normal index.

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

• Error code in OceanBase Database: 5987

• Error code in MySQL: 3812

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

• Error code in OceanBase Database: 5786

• Error code in MySQL: 3813

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

• Error code in OceanBase Database: 5991

• Error code in MySQL: 3814

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

• Error code in OceanBase Database: 5992

• Error code in MySQL: 3815

ERROR 3816 (HY000): An expression of a check constraint \'%.*s\' cannot refer to a user or system variable

• Error code in OceanBase Database: 5993

• Error code in MySQL: 3816

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

• Error code in OceanBase Database: 5990

• Error code in MySQL: 3818

ERROR 3819 (HY000): check constraint violated

• Error code in OceanBase Database: 5693

• Error code in MySQL: 3819

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

• Error code in OceanBase Database: 5994

• Error code in MySQL: 3820

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

• Error code in OceanBase Database: 5988

• Error code in MySQL: 3821

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

• Error code in OceanBase Database: 5678

• Error code in MySQL: 3822

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

• Error code in OceanBase Database: 5497
• Error code in MySQL: 3837
• Cause: You cannot delete or rename a column on which a function-based index depends.
• Solution:
  • Delete the function-based index: If the column that you want to delete is part of the function-based index, you can delete the function-based index first, and then delete the column.
  • Modify the function-based index: If the column that you want to delete is part of the function-based index, you can remove the column from the function-based index and then delete the column.

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

• Error code in OceanBase Database: 6285

• Error code in MySQL: 3853

• Cause: An invalid JSON type is used in an argument, which should be an object type.

• Solution: Make sure that the argument is of a valid JSON object type, or convert it into a correct JSON object type.

ERROR 3855 (HY000): Column '%.*s' has a partitioning function dependency and cannot be dropped or renamed.

• Error code in OceanBase Database: 5502
• Error code in MySQL: 3855
• Cause: You cannot delete or rename a column on which a partitioning function depends.

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

• Error code in OceanBase Database: 5986

• Error code in MySQL: 3939

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

• Error code in OceanBase Database: 5692

• Error code in MySQL: 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

• Error code in OceanBase Database: 5989

• Error code in MySQL: 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.

• Error code in OceanBase Database: 11000

• Error code in MySQL: 3942

• Cause: Each row in the VALUES clause must contain 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 contains at least one column.

ERROR 3943 (HY000): A VALUES clause cannot use DEFAULT values, unless used as a source in an INSERT statement.

• Error code in OceanBase Database: 11001

• Error code in MySQL: 3943

• Cause: Default values cannot be used in the VALUES clause unless they are used as a data source in an INSERT statement.

• Solution: Do not use default values in the VALUES clause unless they are 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

• Error code in OceanBase Database: 5859

• Error code in MySQL: 3959

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

• Error code in OceanBase Database: 5432

• Error code in MySQL: 3966

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

• Error code in OceanBase Database: 5433

• Error code in MySQL: 3967