1 """MySQL ER Constants
2
3 These constants are error codes for the bulk of the error conditions
4 that may occur.
5
6 """
7
8 HASHCHK = 1000
9 NISAMCHK = 1001
10 NO = 1002
11 YES = 1003
12 CANT_CREATE_FILE = 1004
13 CANT_CREATE_TABLE = 1005
14 CANT_CREATE_DB = 1006
15 DB_CREATE_EXISTS = 1007
16 DB_DROP_EXISTS = 1008
17 DB_DROP_DELETE = 1009
18 DB_DROP_RMDIR = 1010
19 CANT_DELETE_FILE = 1011
20 CANT_FIND_SYSTEM_REC = 1012
21 CANT_GET_STAT = 1013
22 CANT_GET_WD = 1014
23 CANT_LOCK = 1015
24 CANT_OPEN_FILE = 1016
25 FILE_NOT_FOUND = 1017
26 CANT_READ_DIR = 1018
27 CANT_SET_WD = 1019
28 CHECKREAD = 1020
29 DISK_FULL = 1021
30 DUP_KEY = 1022
31 ERROR_ON_CLOSE = 1023
32 ERROR_ON_READ = 1024
33 ERROR_ON_RENAME = 1025
34 ERROR_ON_WRITE = 1026
35 FILE_USED = 1027
36 FILSORT_ABORT = 1028
37 FORM_NOT_FOUND = 1029
38 GET_ERRNO = 1030
39 ILLEGAL_HA = 1031
40 KEY_NOT_FOUND = 1032
41 NOT_FORM_FILE = 1033
42 NOT_KEYFILE = 1034
43 OLD_KEYFILE = 1035
44 OPEN_AS_READONLY = 1036
45 OUTOFMEMORY = 1037
46 OUT_OF_SORTMEMORY = 1038
47 UNEXPECTED_EOF = 1039
48 CON_COUNT_ERROR = 1040
49 OUT_OF_RESOURCES = 1041
50 BAD_HOST_ERROR = 1042
51 HANDSHAKE_ERROR = 1043
52 DBACCESS_DENIED_ERROR = 1044
53 ACCESS_DENIED_ERROR = 1045
54 NO_DB_ERROR = 1046
55 UNKNOWN_COM_ERROR = 1047
56 BAD_NULL_ERROR = 1048
57 BAD_DB_ERROR = 1049
58 TABLE_EXISTS_ERROR = 1050
59 BAD_TABLE_ERROR = 1051
60 NON_UNIQ_ERROR = 1052
61 SERVER_SHUTDOWN = 1053
62 BAD_FIELD_ERROR = 1054
63 WRONG_FIELD_WITH_GROUP = 1055
64 WRONG_GROUP_FIELD = 1056
65 WRONG_SUM_SELECT = 1057
66 WRONG_VALUE_COUNT = 1058
67 TOO_LONG_IDENT = 1059
68 DUP_FIELDNAME = 1060
69 DUP_KEYNAME = 1061
70 DUP_ENTRY = 1062
71 WRONG_FIELD_SPEC = 1063
72 PARSE_ERROR = 1064
73 EMPTY_QUERY = 1065
74 NONUNIQ_TABLE = 1066
75 INVALID_DEFAULT = 1067
76 MULTIPLE_PRI_KEY = 1068
77 TOO_MANY_KEYS = 1069
78 TOO_MANY_KEY_PARTS = 1070
79 TOO_LONG_KEY = 1071
80 KEY_COLUMN_DOES_NOT_EXITS = 1072
81 BLOB_USED_AS_KEY = 1073
82 TOO_BIG_FIELDLENGTH = 1074
83 WRONG_AUTO_KEY = 1075
84 READY = 1076
85 NORMAL_SHUTDOWN = 1077
86 GOT_SIGNAL = 1078
87 SHUTDOWN_COMPLETE = 1079
88 FORCING_CLOSE = 1080
89 IPSOCK_ERROR = 1081
90 NO_SUCH_INDEX = 1082
91 WRONG_FIELD_TERMINATORS = 1083
92 BLOBS_AND_NO_TERMINATED = 1084
93 TEXTFILE_NOT_READABLE = 1085
94 FILE_EXISTS_ERROR = 1086
95 LOAD_INFO = 1087
96 ALTER_INFO = 1088
97 WRONG_SUB_KEY = 1089
98 CANT_REMOVE_ALL_FIELDS = 1090
99 CANT_DROP_FIELD_OR_KEY = 1091
100 INSERT_INFO = 1092
101 INSERT_TABLE_USED = 1093
102 NO_SUCH_THREAD = 1094
103 KILL_DENIED_ERROR = 1095
104 NO_TABLES_USED = 1096
105 TOO_BIG_SET = 1097
106 NO_UNIQUE_LOGFILE = 1098
107 TABLE_NOT_LOCKED_FOR_WRITE = 1099
108 TABLE_NOT_LOCKED = 1100
109 BLOB_CANT_HAVE_DEFAULT = 1101
110 WRONG_DB_NAME = 1102
111 WRONG_TABLE_NAME = 1103
112 TOO_BIG_SELECT = 1104
113 UNKNOWN_ERROR = 1105
114 UNKNOWN_PROCEDURE = 1106
115 WRONG_PARAMCOUNT_TO_PROCEDURE = 1107
116 WRONG_PARAMETERS_TO_PROCEDURE = 1108
117 UNKNOWN_TABLE = 1109
118 FIELD_SPECIFIED_TWICE = 1110
119 INVALID_GROUP_FUNC_USE = 1111
120 UNSUPPORTED_EXTENSION = 1112
121 TABLE_MUST_HAVE_COLUMNS = 1113
122 RECORD_FILE_FULL = 1114
123 UNKNOWN_CHARACTER_SET = 1115
124 TOO_MANY_TABLES = 1116
125 TOO_MANY_FIELDS = 1117
126 TOO_BIG_ROWSIZE = 1118
127 STACK_OVERRUN = 1119
128 WRONG_OUTER_JOIN = 1120
129 NULL_COLUMN_IN_INDEX = 1121
130 CANT_FIND_UDF = 1122
131 CANT_INITIALIZE_UDF = 1123
132 UDF_NO_PATHS = 1124
133 UDF_EXISTS = 1125
134 CANT_OPEN_LIBRARY = 1126
135 CANT_FIND_DL_ENTRY = 1127
136 FUNCTION_NOT_DEFINED = 1128
137 HOST_IS_BLOCKED = 1129
138 HOST_NOT_PRIVILEGED = 1130
139 PASSWORD_ANONYMOUS_USER = 1131
140 PASSWORD_NOT_ALLOWED = 1132
141 PASSWORD_NO_MATCH = 1133
142 UPDATE_INFO = 1134
143 CANT_CREATE_THREAD = 1135
144 WRONG_VALUE_COUNT_ON_ROW = 1136
145 CANT_REOPEN_TABLE = 1137
146 INVALID_USE_OF_NULL = 1138
147 REGEXP_ERROR = 1139
148 MIX_OF_GROUP_FUNC_AND_FIELDS = 1140
149 NONEXISTING_GRANT = 1141
150 TABLEACCESS_DENIED_ERROR = 1142
151 COLUMNACCESS_DENIED_ERROR = 1143
152 ILLEGAL_GRANT_FOR_TABLE = 1144
153 GRANT_WRONG_HOST_OR_USER = 1145
154 NO_SUCH_TABLE = 1146
155 NONEXISTING_TABLE_GRANT = 1147
156 NOT_ALLOWED_COMMAND = 1148
157 SYNTAX_ERROR = 1149
158 DELAYED_CANT_CHANGE_LOCK = 1150
159 TOO_MANY_DELAYED_THREADS = 1151
160 ABORTING_CONNECTION = 1152
161 NET_PACKET_TOO_LARGE = 1153
162 NET_READ_ERROR_FROM_PIPE = 1154
163 NET_FCNTL_ERROR = 1155
164 NET_PACKETS_OUT_OF_ORDER = 1156
165 NET_UNCOMPRESS_ERROR = 1157
166 NET_READ_ERROR = 1158
167 NET_READ_INTERRUPTED = 1159
168 NET_ERROR_ON_WRITE = 1160
169 NET_WRITE_INTERRUPTED = 1161
170 TOO_LONG_STRING = 1162
171 TABLE_CANT_HANDLE_BLOB = 1163
172 TABLE_CANT_HANDLE_AUTO_INCREMENT = 1164
173 DELAYED_INSERT_TABLE_LOCKED = 1165
174 WRONG_COLUMN_NAME = 1166
175 WRONG_KEY_COLUMN = 1167
176 WRONG_MRG_TABLE = 1168
177 DUP_UNIQUE = 1169
178 BLOB_KEY_WITHOUT_LENGTH = 1170
179 PRIMARY_CANT_HAVE_NULL = 1171
180 TOO_MANY_ROWS = 1172
181 REQUIRES_PRIMARY_KEY = 1173
182 NO_RAID_COMPILED = 1174
183 UPDATE_WITHOUT_KEY_IN_SAFE_MODE = 1175
184 KEY_DOES_NOT_EXITS = 1176
185 CHECK_NO_SUCH_TABLE = 1177
186 CHECK_NOT_IMPLEMENTED = 1178
187 CANT_DO_THIS_DURING_AN_TRANSACTION = 1179
188 ERROR_DURING_COMMIT = 1180
189 ERROR_DURING_ROLLBACK = 1181
190 ERROR_DURING_FLUSH_LOGS = 1182
191 ERROR_DURING_CHECKPOINT = 1183
192 NEW_ABORTING_CONNECTION = 1184
193 DUMP_NOT_IMPLEMENTED = 1185
194 FLUSH_MASTER_BINLOG_CLOSED = 1186
195 INDEX_REBUILD = 1187
196 MASTER = 1188
197 MASTER_NET_READ = 1189
198 MASTER_NET_WRITE = 1190
199 FT_MATCHING_KEY_NOT_FOUND = 1191
200 LOCK_OR_ACTIVE_TRANSACTION = 1192
201 UNKNOWN_SYSTEM_VARIABLE = 1193
202 CRASHED_ON_USAGE = 1194
203 CRASHED_ON_REPAIR = 1195
204 WARNING_NOT_COMPLETE_ROLLBACK = 1196
205 TRANS_CACHE_FULL = 1197
206 SLAVE_MUST_STOP = 1198
207 SLAVE_NOT_RUNNING = 1199
208 BAD_SLAVE = 1200
209 MASTER_INFO = 1201
210 SLAVE_THREAD = 1202
211 TOO_MANY_USER_CONNECTIONS = 1203
212 SET_CONSTANTS_ONLY = 1204
213 LOCK_WAIT_TIMEOUT = 1205
214 LOCK_TABLE_FULL = 1206
215 READ_ONLY_TRANSACTION = 1207
216 DROP_DB_WITH_READ_LOCK = 1208
217 CREATE_DB_WITH_READ_LOCK = 1209
218 WRONG_ARGUMENTS = 1210
219 NO_PERMISSION_TO_CREATE_USER = 1211
220 UNION_TABLES_IN_DIFFERENT_DIR = 1212
221 LOCK_DEADLOCK = 1213
222 TABLE_CANT_HANDLE_FT = 1214
223 CANNOT_ADD_FOREIGN = 1215
224 NO_REFERENCED_ROW = 1216
225 ROW_IS_REFERENCED = 1217
226 CONNECT_TO_MASTER = 1218
227 QUERY_ON_MASTER = 1219
228 ERROR_WHEN_EXECUTING_COMMAND = 1220
229 WRONG_USAGE = 1221
230 WRONG_NUMBER_OF_COLUMNS_IN_SELECT = 1222
231 CANT_UPDATE_WITH_READLOCK = 1223
232 MIXING_NOT_ALLOWED = 1224
233 DUP_ARGUMENT = 1225
234 USER_LIMIT_REACHED = 1226
235 SPECIFIC_ACCESS_DENIED_ERROR = 1227
236 LOCAL_VARIABLE = 1228
237 GLOBAL_VARIABLE = 1229
238 NO_DEFAULT = 1230
239 WRONG_VALUE_FOR_VAR = 1231
240 WRONG_TYPE_FOR_VAR = 1232
241 VAR_CANT_BE_READ = 1233
242 CANT_USE_OPTION_HERE = 1234
243 NOT_SUPPORTED_YET = 1235
244 MASTER_FATAL_ERROR_READING_BINLOG = 1236
245 SLAVE_IGNORED_TABLE = 1237
246 INCORRECT_GLOBAL_LOCAL_VAR = 1238
247 WRONG_FK_DEF = 1239
248 KEY_REF_DO_NOT_MATCH_TABLE_REF = 1240
249 OPERAND_COLUMNS = 1241
250 SUBQUERY_NO_1_ROW = 1242
251 UNKNOWN_STMT_HANDLER = 1243
252 CORRUPT_HELP_DB = 1244
253 CYCLIC_REFERENCE = 1245
254 AUTO_CONVERT = 1246
255 ILLEGAL_REFERENCE = 1247
256 DERIVED_MUST_HAVE_ALIAS = 1248
257 SELECT_REDUCED = 1249
258 TABLENAME_NOT_ALLOWED_HERE = 1250
259 NOT_SUPPORTED_AUTH_MODE = 1251
260 SPATIAL_CANT_HAVE_NULL = 1252
261 COLLATION_CHARSET_MISMATCH = 1253
262 SLAVE_WAS_RUNNING = 1254
263 SLAVE_WAS_NOT_RUNNING = 1255
264 TOO_BIG_FOR_UNCOMPRESS = 1256
265 ZLIB_Z_MEM_ERROR = 1257
266 ZLIB_Z_BUF_ERROR = 1258
267 ZLIB_Z_DATA_ERROR = 1259
268 CUT_VALUE_GROUP_CONCAT = 1260
269 WARN_TOO_FEW_RECORDS = 1261
270 WARN_TOO_MANY_RECORDS = 1262
271 WARN_NULL_TO_NOTNULL = 1263
272 WARN_DATA_OUT_OF_RANGE = 1264
273 WARN_DATA_TRUNCATED = 1265
274 WARN_USING_OTHER_HANDLER = 1266
275 CANT_AGGREGATE_2COLLATIONS = 1267
276 DROP_USER = 1268
277 REVOKE_GRANTS = 1269
278 CANT_AGGREGATE_3COLLATIONS = 1270
279 CANT_AGGREGATE_NCOLLATIONS = 1271
280 VARIABLE_IS_NOT_STRUCT = 1272
281 UNKNOWN_COLLATION = 1273
282 SLAVE_IGNORED_SSL_PARAMS = 1274
283 SERVER_IS_IN_SECURE_AUTH_MODE = 1275
284 WARN_FIELD_RESOLVED = 1276
285 BAD_SLAVE_UNTIL_COND = 1277
286 MISSING_SKIP_SLAVE = 1278
287 UNTIL_COND_IGNORED = 1279
288 WRONG_NAME_FOR_INDEX = 1280
289 WRONG_NAME_FOR_CATALOG = 1281
290 WARN_QC_RESIZE = 1282
291 BAD_FT_COLUMN = 1283
292 UNKNOWN_KEY_CACHE = 1284
293 WARN_HOSTNAME_WONT_WORK = 1285
294 UNKNOWN_STORAGE_ENGINE = 1286
295 WARN_DEPRECATED_SYNTAX = 1287
296 NON_UPDATABLE_TABLE = 1288
297 FEATURE_DISABLED = 1289
298 OPTION_PREVENTS_STATEMENT = 1290
299 DUPLICATED_VALUE_IN_TYPE = 1291
300 TRUNCATED_WRONG_VALUE = 1292
301 TOO_MUCH_AUTO_TIMESTAMP_COLS = 1293
302 INVALID_ON_UPDATE = 1294
303 UNSUPPORTED_PS = 1295
304 GET_ERRMSG = 1296
305 GET_TEMPORARY_ERRMSG = 1297
306 UNKNOWN_TIME_ZONE = 1298
307 WARN_INVALID_TIMESTAMP = 1299
308 INVALID_CHARACTER_STRING = 1300
309 WARN_ALLOWED_PACKET_OVERFLOWED = 1301
310 CONFLICTING_DECLARATIONS = 1302
311 SP_NO_RECURSIVE_CREATE = 1303
312 SP_ALREADY_EXISTS = 1304
313 SP_DOES_NOT_EXIST = 1305
314 SP_DROP_FAILED = 1306
315 SP_STORE_FAILED = 1307
316 SP_LILABEL_MISMATCH = 1308
317 SP_LABEL_REDEFINE = 1309
318 SP_LABEL_MISMATCH = 1310
319 SP_UNINIT_VAR = 1311
320 SP_BADSELECT = 1312
321 SP_BADRETURN = 1313
322 SP_BADSTATEMENT = 1314
323 UPDATE_LOG_DEPRECATED_IGNORED = 1315
324 UPDATE_LOG_DEPRECATED_TRANSLATED = 1316
325 QUERY_INTERRUPTED = 1317
326 SP_WRONG_NO_OF_ARGS = 1318
327 SP_COND_MISMATCH = 1319
328 SP_NORETURN = 1320
329 SP_NORETURNEND = 1321
330 SP_BAD_CURSOR_QUERY = 1322
331 SP_BAD_CURSOR_SELECT = 1323
332 SP_CURSOR_MISMATCH = 1324
333 SP_CURSOR_ALREADY_OPEN = 1325
334 SP_CURSOR_NOT_OPEN = 1326
335 SP_UNDECLARED_VAR = 1327
336 SP_WRONG_NO_OF_FETCH_ARGS = 1328
337 SP_FETCH_NO_DATA = 1329
338 SP_DUP_PARAM = 1330
339 SP_DUP_VAR = 1331
340 SP_DUP_COND = 1332
341 SP_DUP_CURS = 1333
342 SP_CANT_ALTER = 1334
343 SP_SUBSELECT_NYI = 1335
344 STMT_NOT_ALLOWED_IN_SF_OR_TRG = 1336
345 SP_VARCOND_AFTER_CURSHNDLR = 1337
346 SP_CURSOR_AFTER_HANDLER = 1338
347 SP_CASE_NOT_FOUND = 1339
348 FPARSER_TOO_BIG_FILE = 1340
349 FPARSER_BAD_HEADER = 1341
350 FPARSER_EOF_IN_COMMENT = 1342
351 FPARSER_ERROR_IN_PARAMETER = 1343
352 FPARSER_EOF_IN_UNKNOWN_PARAMETER = 1344
353 VIEW_NO_EXPLAIN = 1345
354 FRM_UNKNOWN_TYPE = 1346
355 WRONG_OBJECT = 1347
356 NONUPDATEABLE_COLUMN = 1348
357 VIEW_SELECT_DERIVED = 1349
358 VIEW_SELECT_CLAUSE = 1350
359 VIEW_SELECT_VARIABLE = 1351
360 VIEW_SELECT_TMPTABLE = 1352
361 VIEW_WRONG_LIST = 1353
362 WARN_VIEW_MERGE = 1354
363 WARN_VIEW_WITHOUT_KEY = 1355
364 VIEW_INVALID = 1356
365 SP_NO_DROP_SP = 1357
366 SP_GOTO_IN_HNDLR = 1358
367 TRG_ALREADY_EXISTS = 1359
368 TRG_DOES_NOT_EXIST = 1360
369 TRG_ON_VIEW_OR_TEMP_TABLE = 1361
370 TRG_CANT_CHANGE_ROW = 1362
371 TRG_NO_SUCH_ROW_IN_TRG = 1363
372 NO_DEFAULT_FOR_FIELD = 1364
373 DIVISION_BY_ZERO = 1365
374 TRUNCATED_WRONG_VALUE_FOR_FIELD = 1366
375 ILLEGAL_VALUE_FOR_TYPE = 1367
376 VIEW_NONUPD_CHECK = 1368
377 VIEW_CHECK_FAILED = 1369
378 PROCACCESS_DENIED_ERROR = 1370
379 RELAY_LOG_FAIL = 1371
380 PASSWD_LENGTH = 1372
381 UNKNOWN_TARGET_BINLOG = 1373
382 IO_ERR_LOG_INDEX_READ = 1374
383 BINLOG_PURGE_PROHIBITED = 1375
384 FSEEK_FAIL = 1376
385 BINLOG_PURGE_FATAL_ERR = 1377
386 LOG_IN_USE = 1378
387 LOG_PURGE_UNKNOWN_ERR = 1379
388 RELAY_LOG_INIT = 1380
389 NO_BINARY_LOGGING = 1381
390 RESERVED_SYNTAX = 1382
391 WSAS_FAILED = 1383
392 DIFF_GROUPS_PROC = 1384
393 NO_GROUP_FOR_PROC = 1385
394 ORDER_WITH_PROC = 1386
395 LOGGING_PROHIBIT_CHANGING_OF = 1387
396 NO_FILE_MAPPING = 1388
397 WRONG_MAGIC = 1389
398 PS_MANY_PARAM = 1390
399 KEY_PART_0 = 1391
400 VIEW_CHECKSUM = 1392
401 VIEW_MULTIUPDATE = 1393
402 VIEW_NO_INSERT_FIELD_LIST = 1394
403 VIEW_DELETE_MERGE_VIEW = 1395
404 CANNOT_USER = 1396
405 XAER_NOTA = 1397
406 XAER_INVAL = 1398
407 XAER_RMFAIL = 1399
408 XAER_OUTSIDE = 1400
409 XAER_RMERR = 1401
410 XA_RBROLLBACK = 1402
411 NONEXISTING_PROC_GRANT = 1403
412 PROC_AUTO_GRANT_FAIL = 1404
413 PROC_AUTO_REVOKE_FAIL = 1405
414 DATA_TOO_LONG = 1406
415 SP_BAD_SQLSTATE = 1407
416 STARTUP = 1408
417 LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR = 1409
418 CANT_CREATE_USER_WITH_GRANT = 1410
419 WRONG_VALUE_FOR_TYPE = 1411
420 TABLE_DEF_CHANGED = 1412
421 SP_DUP_HANDLER = 1413
422 SP_NOT_VAR_ARG = 1414
423 SP_NO_RETSET = 1415
424 CANT_CREATE_GEOMETRY_OBJECT = 1416
425 FAILED_ROUTINE_BREAK_BINLOG = 1417
426 BINLOG_UNSAFE_ROUTINE = 1418
427 BINLOG_CREATE_ROUTINE_NEED_SUPER = 1419
428 EXEC_STMT_WITH_OPEN_CURSOR = 1420
429 STMT_HAS_NO_OPEN_CURSOR = 1421
430 COMMIT_NOT_ALLOWED_IN_SF_OR_TRG = 1422
431 NO_DEFAULT_FOR_VIEW_FIELD = 1423
432 SP_NO_RECURSION = 1424
433 TOO_BIG_SCALE = 1425
434 TOO_BIG_PRECISION = 1426
435 M_BIGGER_THAN_D = 1427
436 WRONG_LOCK_OF_SYSTEM_TABLE = 1428
437 CONNECT_TO_FOREIGN_DATA_SOURCE = 1429
438 QUERY_ON_FOREIGN_DATA_SOURCE = 1430
439 FOREIGN_DATA_SOURCE_DOESNT_EXIST = 1431
440 FOREIGN_DATA_STRING_INVALID_CANT_CREATE = 1432
441 FOREIGN_DATA_STRING_INVALID = 1433
442 CANT_CREATE_FEDERATED_TABLE = 1434
443 TRG_IN_WRONG_SCHEMA = 1435
444 STACK_OVERRUN_NEED_MORE = 1436
445 TOO_LONG_BODY = 1437
446 WARN_CANT_DROP_DEFAULT_KEYCACHE = 1438
447 TOO_BIG_DISPLAYWIDTH = 1439
448 XAER_DUPID = 1440
449 DATETIME_FUNCTION_OVERFLOW = 1441
450 CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG = 1442
451 VIEW_PREVENT_UPDATE = 1443
452 PS_NO_RECURSION = 1444
453 SP_CANT_SET_AUTOCOMMIT = 1445
454 MALFORMED_DEFINER = 1446
455 VIEW_FRM_NO_USER = 1447
456 VIEW_OTHER_USER = 1448
457 NO_SUCH_USER = 1449
458 FORBID_SCHEMA_CHANGE = 1450
459 ROW_IS_REFERENCED_2 = 1451
460 NO_REFERENCED_ROW_2 = 1452
461 SP_BAD_VAR_SHADOW = 1453
462 TRG_NO_DEFINER = 1454
463 OLD_FILE_FORMAT = 1455
464 SP_RECURSION_LIMIT = 1456
465 SP_PROC_TABLE_CORRUPT = 1457
466 ERROR_LAST = 1457
467