Skip navigation links

MySQL Forums :: Stored Procedures :: HOW CAN I CAPTURE DE ERROR


Advanced Search

Re: HOW CAN I CAPTURE DE ERROR
Posted by: Claudio G ()
Date: April 06, 2006 02:41PM

I'm sorry for the length of the message ...
Parte II:


===================================================================
DECLARE EXIT HANDLER FOR 1247 SELECT "42S22 (ER_ILLEGAL_REFERENCE) Reference '%s' not supported (%s)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1248 SELECT "42000 (ER_DERIVED_MUST_HAVE_ALIAS) Every derived table must have its own alias" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1249 SELECT "01000 (ER_SELECT_REDUCED) Select %u was reduced during optimization" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1250 SELECT "42000 (ER_TABLENAME_NOT_ALLOWED_HERE) Table '%s' from one of the SELECTs cannot be used in %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1251 SELECT "08004 (ER_NOT_SUPPORTED_AUTH_MODE) Client does not support authentication protocol requested by server; consider upgrading MySQL client" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1252 SELECT "42000 (ER_SPATIAL_CANT_HAVE_NULL) All parts of a SPATIAL index must be NOT NULL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1253 SELECT "42000 (ER_COLLATION_CHARSET_MISMATCH) COLLATION '%s' is not valid for CHARACTER SET '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1254 SELECT "HY000 (ER_SLAVE_WAS_RUNNING) Slave is already running" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1255 SELECT "HY000 (ER_SLAVE_WAS_NOT_RUNNING) Slave already has been stopped" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1256 SELECT "HY000 (ER_TOO_BIG_FOR_UNCOMPRESS) Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1257 SELECT "HY000 (ER_ZLIB_Z_MEM_ERROR) ZLI" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1258 SELECT "HY000 (ER_ZLIB_Z_BUF_ERROR) ZLI" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1259 SELECT "HY000 (ER_ZLIB_Z_DATA_ERROR) ZLI" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1260 SELECT "HY000 (ER_CUT_VALUE_GROUP_CONCAT) %d line(s) were cut by GROUP_CONCAT()" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1261 SELECT "01000 (ER_WARN_TOO_FEW_RECORDS) Row %ld doesn't contain data for all columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1262 SELECT "01000 (ER_WARN_TOO_MANY_RECORDS) Row %ld was truncated; it contained more data than there were input columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1263 SELECT "22004 (ER_WARN_NULL_TO_NOTNULL) Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1264 SELECT "22003 (ER_WARN_DATA_OUT_OF_RANGE) Out of range value for column '%s' at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1265 SELECT "01000 (WARN_DATA_TRUNCATED) Data truncated for column '%s' at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1266 SELECT "HY000 (ER_WARN_USING_OTHER_HANDLER) Using storage engine %s for table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1267 SELECT "HY000 (ER_CANT_AGGREGATE_2COLLATIONS) Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1268 SELECT "HY000 (ER_DROP_USER) Cannot drop one or more of the requested users" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1269 SELECT "HY000 (ER_REVOKE_GRANTS) Can't revoke all privileges for one or more of the requested users" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1270 SELECT "HY000 (ER_CANT_AGGREGATE_3COLLATIONS) Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1271 SELECT "HY000 (ER_CANT_AGGREGATE_NCOLLATIONS) Illegal mix of collations for operation '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1272 SELECT "HY000 (ER_VARIABLE_IS_NOT_STRUCT) Variable '%s' is not a variable component (can't be used as XXXX.variable_name)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1273 SELECT "HY000 (ER_UNKNOWN_COLLATION) Unknown collatio" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1274 SELECT "HY000 (ER_SLAVE_IGNORED_SSL_PARAMS) SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1275 SELECT "HY000 (ER_SERVER_IS_IN_SECURE_AUTH_MODE) Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1276 SELECT "HY000 (ER_WARN_FIELD_RESOLVED) Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1277 SELECT "HY000 (ER_BAD_SLAVE_UNTIL_COND) Incorrect parameter or combination of parameters for START SLAVE UNTIL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1278 SELECT "HY000 (ER_MISSING_SKIP_SLAVE) It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1279 SELECT "HY000 (ER_UNTIL_COND_IGNORED) SQL thread is not to be started so UNTIL options are ignored" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1280 SELECT "42000 (ER_WRONG_NAME_FOR_INDEX) Incorrect index name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1281 SELECT "42000 (ER_WRONG_NAME_FOR_CATALOG) Incorrect catalog name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1282 SELECT "HY000 (ER_WARN_QC_RESIZE) Query cache failed to set size %lu; new query cache size is %lu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1283 SELECT "HY000 (ER_BAD_FT_COLUMN) Column '%s' cannot be part of FULLTEXT index" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1284 SELECT "HY000 (ER_UNKNOWN_KEY_CACHE) Unknown key cache '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1285 SELECT "HY000 (ER_WARN_HOSTNAME_WONT_WORK) MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1286 SELECT "42000 (ER_UNKNOWN_STORAGE_ENGINE) Unknown table engine '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1287 SELECT "HY000 (ER_UNUSED_1) '%s' is deprecated; use '%s' instead" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1288 SELECT "HY000 (ER_NON_UPDATABLE_TABLE) The target table %s of the %s is not updatable" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1289 SELECT "HY000 (ER_FEATURE_DISABLED) The '%s' feature is disabled; you need MySQL built with '%s' to have it working" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1290 SELECT "HY000 (ER_OPTION_PREVENTS_STATEMENT) The MySQL server is running with the %s option so it cannot execute this statement" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1291 SELECT "HY000 (ER_DUPLICATED_VALUE_IN_TYPE) Column '%s' has duplicated value '%s' in %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1292 SELECT "22007 (ER_TRUNCATED_WRONG_VALUE) Truncated incorrect %s valu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1293 SELECT "HY000 (ER_TOO_MUCH_AUTO_TIMESTAMP_COLS) Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1294 SELECT "HY000 (ER_INVALID_ON_UPDATE) Invalid ON UPDATE clause for '%s' column" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1295 SELECT "HY000 (ER_UNSUPPORTED_PS) This command is not supported in the prepared statement protocol yet" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1296 SELECT "HY000 (ER_GET_ERRMSG) Got error %d '%s' from %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1297 SELECT "HY000 (ER_GET_TEMPORARY_ERRMSG) Got temporary error %d '%s' from %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1298 SELECT "HY000 (ER_UNKNOWN_TIME_ZONE) Unknown or incorrect time zon" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1299 SELECT "HY000 (ER_WARN_INVALID_TIMESTAMP) Invalid TIMESTAMP value in column '%s' at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1300 SELECT "HY000 (ER_INVALID_CHARACTER_STRING) Invalid %s character strin" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1301 SELECT "HY000 (ER_WARN_ALLOWED_PACKET_OVERFLOWED) Result of %s() was larger than max_allowed_packet (%ld) - truncated" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1302 SELECT "HY000 (ER_CONFLICTING_DECLARATIONS) Conflicting declaration" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1303 SELECT "2F003 (ER_SP_NO_RECURSIVE_CREATE) Can't create a %s from within another stored routine" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1304 SELECT "42000 (ER_SP_ALREADY_EXISTS) %s %s already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1305 SELECT "42000 (ER_SP_DOES_NOT_EXIST) %s %s does not exist" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1306 SELECT "HY000 (ER_SP_DROP_FAILED) Failed to DROP %s %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1307 SELECT "HY000 (ER_SP_STORE_FAILED) Failed to CREATE %s %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1308 SELECT "42000 (ER_SP_LILABEL_MISMATCH) %s with no matching labe" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1309 SELECT "42000 (ER_SP_LABEL_REDEFINE) Redefining label %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1310 SELECT "42000 (ER_SP_LABEL_MISMATCH) End-label %s without match" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1311 SELECT "01000 (ER_SP_UNINIT_VAR) Referring to uninitialized variable %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1312 SELECT "0A000 (ER_SP_BADSELECT) PROCEDURE %s can't return a result set in the given context" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1313 SELECT "42000 (ER_SP_BADRETURN) RETURN is only allowed in a FUNCTION" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1314 SELECT "0A000 (ER_SP_BADSTATEMENT) %s is not allowed in stored procedures" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1315 SELECT "42000 (ER_UPDATE_LOG_DEPRECATED_IGNORED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1316 SELECT "42000 (ER_UPDATE_LOG_DEPRECATED_TRANSLATED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1317 SELECT "70100 (ER_QUERY_INTERRUPTED) Query execution was interrupted" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1318 SELECT "42000 (ER_SP_WRONG_NO_OF_ARGS) Incorrect number of arguments for %s %s; expected %u, got %u" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1319 SELECT "42000 (ER_SP_COND_MISMATCH) Undefined CONDITIO" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1320 SELECT "42000 (ER_SP_NORETURN) No RETURN found in FUNCTION %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1321 SELECT "2F005 (ER_SP_NORETURNEND) FUNCTION %s ended without RETURN" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1322 SELECT "42000 (ER_SP_BAD_CURSOR_QUERY) Cursor statement must be a SELECT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1323 SELECT "42000 (ER_SP_BAD_CURSOR_SELECT) Cursor SELECT must not have INTO" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1324 SELECT "42000 (ER_SP_CURSOR_MISMATCH) Undefined CURSO" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1325 SELECT "24000 (ER_SP_CURSOR_ALREADY_OPEN) Cursor is already open" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1326 SELECT "24000 (ER_SP_CURSOR_NOT_OPEN) Cursor is not open" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1327 SELECT "42000 (ER_SP_UNDECLARED_VAR) Undeclared variabl" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1328 SELECT "HY000 (ER_SP_WRONG_NO_OF_FETCH_ARGS) Incorrect number of FETCH variables" as 'ERROR_NO SQLSTATE';
/*DECLARE CONTINUE HANDLER FOR 1329 SELECT "02000 (ER_SP_FETCH_NO_DATA) No data - zero rows fetched, selected, or processed" as 'ERROR_NO SQLSTATE';*/
DECLARE EXIT HANDLER FOR 1330 SELECT "42000 (ER_SP_DUP_PARAM) Duplicate paramete" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1331 SELECT "42000 (ER_SP_DUP_VAR) Duplicate variabl" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1332 SELECT "42000 (ER_SP_DUP_COND) Duplicate conditio" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1333 SELECT "42000 (ER_SP_DUP_CURS) Duplicate curso" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1334 SELECT "HY000 (ER_SP_CANT_ALTER) Failed to ALTER %s %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1335 SELECT "0A000 (ER_SP_SUBSELECT_NYI) Subquery value not supported" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1336 SELECT "0A000 (ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG) %s is not allowed in stored function or trigger" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1337 SELECT "42000 (ER_SP_VARCOND_AFTER_CURSHNDLR) Variable or condition declaration after cursor or handler declaration" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1338 SELECT "42000 (ER_SP_CURSOR_AFTER_HANDLER) Cursor declaration after handler declaration" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1339 SELECT "20000 (ER_SP_CASE_NOT_FOUND) Case not found for CASE statement" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1340 SELECT "HY000 (ER_FPARSER_TOO_BIG_FILE) Configuration file '%s' is too big" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1341 SELECT "HY000 (ER_FPARSER_BAD_HEADER) Malformed file type header in file '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1342 SELECT "HY000 (ER_FPARSER_EOF_IN_COMMENT) Unexpected end of file while parsing comment '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1344 SELECT "HY000 (ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER) Unexpected end of file while skipping unknown parameter '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1345 SELECT "HY000 (ER_VIEW_NO_EXPLAIN) EXPLAIN/SHOW can not be issued; lacking privileges for underlying table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1346 SELECT "HY000 (ER_FRM_UNKNOWN_TYPE) File '%s' has unknown type '%s' in its header" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1347 SELECT "HY000 (ER_WRONG_OBJECT) '%s.%s' is not %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1348 SELECT "HY000 (ER_NONUPDATEABLE_COLUMN) Column '%s' is not updatable" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1349 SELECT "HY000 (ER_VIEW_SELECT_DERIVED) View's SELECT contains a subquery in the FROM clause" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1350 SELECT "HY000 (ER_VIEW_SELECT_CLAUSE) View's SELECT contains a '%s' clause" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1351 SELECT "HY000 (ER_VIEW_SELECT_VARIABLE) View's SELECT contains a variable or parameter" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1352 SELECT "HY000 (ER_VIEW_SELECT_TMPTABLE) View's SELECT refers to a temporary table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1353 SELECT "HY000 (ER_VIEW_WRONG_LIST) View's SELECT and view's field list have different column counts" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1354 SELECT "HY000 (ER_WARN_VIEW_MERGE) View merge algorithm can't be used here for now (assumed undefined algorithm)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1355 SELECT "HY000 (ER_WARN_VIEW_WITHOUT_KEY) View being updated does not have complete key of underlying table in it" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1356 SELECT "HY000 (ER_VIEW_INVALID) View '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1357 SELECT "HY000 (ER_SP_NO_DROP_SP) Can't drop or alter a %s from within another stored routine" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1358 SELECT "HY000 (ER_SP_GOTO_IN_HNDLR) GOTO is not allowed in a stored procedure handler" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1359 SELECT "HY000 (ER_TRG_ALREADY_EXISTS) Trigger already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1360 SELECT "HY000 (ER_TRG_DOES_NOT_EXIST) Trigger does not exist" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1361 SELECT "HY000 (ER_TRG_ON_VIEW_OR_TEMP_TABLE) Trigger's '%s' is view or temporary table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1362 SELECT "HY000 (ER_TRG_CANT_CHANGE_ROW) Updating of %s row is not allowed in %strigger" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1363 SELECT "HY000 (ER_TRG_NO_SUCH_ROW_IN_TRG) There is no %s row in %s trigger" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1364 SELECT "HY000 (ER_NO_DEFAULT_FOR_FIELD) Field '%s' doesn't have a default value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1365 SELECT "22012 (ER_DIVISION_BY_ZERO) Division by 0" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1366 SELECT "HY000 (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD) Incorrect %s valu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1367 SELECT "22007 (ER_ILLEGAL_VALUE_FOR_TYPE) Illegal %s '%s' value found during parsing" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1368 SELECT "HY000 (ER_VIEW_NONUPD_CHECK) CHECK OPTION on non-updatable view '%s.%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1369 SELECT "HY000 (ER_VIEW_CHECK_FAILED) CHECK OPTION failed '%s.%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1370 SELECT "42000 (ER_PROCACCESS_DENIED_ERROR) %s command denied to user '%s'@'%s' for routine '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1371 SELECT "HY000 (ER_RELAY_LOG_FAIL) Failed purging old relay log" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1372 SELECT "HY000 (ER_PASSWD_LENGTH) Password hash should be a %d-digit hexadecimal number" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1373 SELECT "HY000 (ER_UNKNOWN_TARGET_BINLOG) Target log not found in binlog index" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1374 SELECT "HY000 (ER_IO_ERR_LOG_INDEX_READ) I/O error reading log index file" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1375 SELECT "HY000 (ER_BINLOG_PURGE_PROHIBITED) Server configuration does not permit binlog purge" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1376 SELECT "HY000 (ER_FSEEK_FAIL) Failed on fseek()" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1377 SELECT "HY000 (ER_BINLOG_PURGE_FATAL_ERR) Fatal error during log purge" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1378 SELECT "HY000 (ER_LOG_IN_USE) A purgeable log is in use, will not purge" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1379 SELECT "HY000 (ER_LOG_PURGE_UNKNOWN_ERR) Unknown error during log purge" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1380 SELECT "HY000 (ER_RELAY_LOG_INIT) Failed initializing relay log positio" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1381 SELECT "HY000 (ER_NO_BINARY_LOGGING) You are not using binary logging" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1382 SELECT "HY000 (ER_RESERVED_SYNTAX) The '%s' syntax is reserved for purposes internal to the MySQL server" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1383 SELECT "HY000 (ER_WSAS_FAILED) WSAStartup Failed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1384 SELECT "HY000 (ER_DIFF_GROUPS_PROC) Can't handle procedures with different groups yet" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1385 SELECT "HY000 (ER_NO_GROUP_FOR_PROC) Select must have a group with this procedure" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1386 SELECT "HY000 (ER_ORDER_WITH_PROC) Can't use ORDER clause with this procedure" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1387 SELECT "HY000 (ER_LOGGING_PROHIBIT_CHANGING_OF) Binary logging and replication forbid changing the global server %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1388 SELECT "HY000 (ER_NO_FILE_MAPPING) Can't map fil" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1389 SELECT "HY000 (ER_WRONG_MAGIC) Wrong magic in %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1390 SELECT "HY000 (ER_PS_MANY_PARAM) Prepared statement contains too many placeholders" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1391 SELECT "HY000 (ER_KEY_PART_0) Key part '%s' length cannot be 0" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1392 SELECT "HY000 (ER_VIEW_CHECKSUM) View text checksum failed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1393 SELECT "HY000 (ER_VIEW_MULTIUPDATE) Can not modify more than one base table through a join view '%s.%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1394 SELECT "HY000 (ER_VIEW_NO_INSERT_FIELD_LIST) Can not insert into join view '%s.%s' without fields list" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1395 SELECT "HY000 (ER_VIEW_DELETE_MERGE_VIEW) Can not delete from join view '%s.%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1396 SELECT "HY000 (ER_CANNOT_USER) Operation %s failed for %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1397 SELECT "XAE04 (ER_XAER_NOTA) XAER_NOT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1398 SELECT "XAE05 (ER_XAER_INVAL) XAER_INVA" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1399 SELECT "XAE07 (ER_XAER_RMFAIL) XAER_RMFAI" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1400 SELECT "XAE09 (ER_XAER_OUTSIDE) XAER_OUTSID" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1401 SELECT "XAE03 (ER_XAER_RMERR) XAER_RMER" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1402 SELECT "XA100 (ER_XA_RBROLLBACK) XA_RBROLLBAC" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1403 SELECT "42000 (ER_NONEXISTING_PROC_GRANT) There is no such grant defined for user '%s' on host '%s' on routine '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1404 SELECT "HY000 (ER_PROC_AUTO_GRANT_FAIL) Failed to grant EXECUTE and ALTER ROUTINE privileges" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1405 SELECT "HY000 (ER_PROC_AUTO_REVOKE_FAIL) Failed to revoke all privileges to dropped routine" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1406 SELECT "22001 (ER_DATA_TOO_LONG) Data too long for column '%s' at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1407 SELECT "42000 (ER_SP_BAD_SQLSTATE) Bad SQLSTAT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1408 SELECT "HY000 (ER_STARTUP) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1409 SELECT "HY000 (ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR) Can't load value from file with fixed size rows to variable" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1410 SELECT "42000 (ER_CANT_CREATE_USER_WITH_GRANT) You are not allowed to create a user with GRANT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1411 SELECT "HY000 (ER_WRONG_VALUE_FOR_TYPE) Incorrect %s valu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1412 SELECT "HY000 (ER_TABLE_DEF_CHANGED) Table definition has changed, please retry transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1413 SELECT "42000 (ER_SP_DUP_HANDLER) Duplicate handler declared in the same block" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1414 SELECT "42000 (ER_SP_NOT_VAR_ARG) OUT or INOUT argument %d for routine %s is not a variable" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1415 SELECT "0A000 (ER_SP_NO_RETSET) Not allowed to return a result set from a %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1416 SELECT "22003 (ER_CANT_CREATE_GEOMETRY_OBJECT) Cannot get geometry object from data you send to the GEOMETRY field" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1417 SELECT "HY000 (ER_FAILED_ROUTINE_BREAK_BINLOG) A routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1418 SELECT "HY000 (ER_BINLOG_UNSAFE_ROUTINE) This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1419 SELECT "HY000 (ER_BINLOG_CREATE_ROUTINE_NEED_SUPER) You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1420 SELECT "HY000 (ER_EXEC_STMT_WITH_OPEN_CURSOR) You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1421 SELECT "HY000 (ER_STMT_HAS_NO_OPEN_CURSOR) The statement (%lu) has no open cursor." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1422 SELECT "HY000 (ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG) Explicit or implicit commit is not allowed in stored function or trigger." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1423 SELECT "HY000 (ER_NO_DEFAULT_FOR_VIEW_FIELD) Field of view '%s.%s' underlying table doesn't have a default value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1424 SELECT "HY000 (ER_SP_NO_RECURSION) Recursive stored functions and triggers are not allowed." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1425 SELECT "42000 (ER_TOO_BIG_SCALE) Too big scale %d specified for column '%s'. Maximum is %d." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1426 SELECT "42000 (ER_TOO_BIG_PRECISION) Too big precision %d specified for column '%s'. Maximum is %d." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1427 SELECT "42000 (ER_M_BIGGER_THAN_D) For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1428 SELECT "HY000 (ER_WRONG_LOCK_OF_SYSTEM_TABLE) You can't combine write-locking of system '%s.%s' table with other tables" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1429 SELECT "HY000 (ER_CONNECT_TO_FOREIGN_DATA_SOURCE) Unable to connect to foreign data sourc" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1430 SELECT "HY000 (ER_QUERY_ON_FOREIGN_DATA_SOURCE) There was a problem processing the query on the foreign data source. Data source erro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1431 SELECT "HY000 (ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST) The foreign data source you are trying to reference does not exist. Data source erro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1432 SELECT "HY000 (ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE) Can't create federated table. The data source connection string '%s' is not in the correct format" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1433 SELECT "HY000 (ER_FOREIGN_DATA_STRING_INVALID) The data source connection string '%s' is not in the correct format" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1434 SELECT "HY000 (ER_CANT_CREATE_FEDERATED_TABLE) Can't create federated table. Foreign data src erro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1435 SELECT "HY000 (ER_TRG_IN_WRONG_SCHEMA) Trigger in wrong schema" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1436 SELECT "HY000 (ER_STACK_OVERRUN_NEED_MORE) Thread stack overru" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1437 SELECT "42000 (ER_TOO_LONG_BODY) Routine body for '%s' is too long" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1438 SELECT "HY000 (ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) Cannot drop default keycache" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1439 SELECT "42000 (ER_TOO_BIG_DISPLAYWIDTH) Display width out of range for column '%s' (max = %d)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1440 SELECT "XAE08 (ER_XAER_DUPID) XAER_DUPI" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1441 SELECT "22008 (ER_DATETIME_FUNCTION_OVERFLOW) Datetime functio" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1442 SELECT "HY000 (ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG) Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1443 SELECT "HY000 (ER_VIEW_PREVENT_UPDATE) The definition of table '%s' prevents operation %s on table '%s'." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1444 SELECT "HY000 (ER_PS_NO_RECURSION) 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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1445 SELECT "HY000 (ER_SP_CANT_SET_AUTOCOMMIT) Not allowed to set autocommit from a stored function or trigger" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1446 SELECT "HY000 (ER_MALFORMED_DEFINER) Definer is not fully qualified" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1447 SELECT "HY000 (ER_VIEW_FRM_NO_USER) View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1448 SELECT "HY000 (ER_VIEW_OTHER_USER) You need the SUPER privilege for creation view with '%s'@'%s' definer" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1449 SELECT "HY000 (ER_NO_SUCH_USER) There is no '%s'@'%s' registered" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1450 SELECT "HY000 (ER_FORBID_SCHEMA_CHANGE) Changing schema from '%s' to '%s' is not allowed." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1451 SELECT "23000 (ER_ROW_IS_REFERENCED_2) Cannot delete or update a parent ro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1452 SELECT "23000 (ER_NO_REFERENCED_ROW_2) Cannot add or update a child ro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1453 SELECT "42000 (ER_SP_BAD_VAR_SHADOW) Variable '%s' must be quoted with `...`, or renamed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1454 SELECT "HY000 (ER_TRG_NO_DEFINER) No definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1455 SELECT "HY000 (ER_OLD_FILE_FORMAT) '%s' has an old format, you should re-create the '%s' object(s)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1456 SELECT "HY000 (ER_SP_RECURSION_LIMIT) Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1457 SELECT "HY000 (ER_SP_PROC_TABLE_CORRUPT) Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1458 SELECT "HY000 (ER_PARTITION_REQUIRES_VALUES_ERROR) %s PARTITIONING requires definition of VALUES %s for each partition" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1459 SELECT "HY000 (ER_PARTITION_WRONG_VALUES_ERROR) Only %s PARTITIONING can use VALUES %s in partition definition" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1460 SELECT "HY000 (ER_PARTITION_MAXVALUE_ERROR) MAXVALUE can only be used in last partition definition" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1461 SELECT "HY000 (ER_PARTITION_SUBPARTITION_ERROR) Subpartitions can only be hash partitions and by key" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1462 SELECT "HY000 (ER_PARTITION_SUBPART_MIX_ERROR) Must define subpartitions on all partitions if on one partition" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1463 SELECT "HY000 (ER_PARTITION_WRONG_NO_PART_ERROR) Wrong number of partitions defined, mismatch with previous setting" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1464 SELECT "HY000 (ER_PARTITION_WRONG_NO_SUBPART_ERROR) Wrong number of subpartitions defined, mismatch with previous setting" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1465 SELECT "HY000 (ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR) Constant/Random expression in (sub)partitioning function is not allowed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1466 SELECT "HY000 (ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR) Expression in RANGE/LIST VALUES must be constant" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1467 SELECT "HY000 (ER_FIELD_NOT_FOUND_PART_ERROR) Field in list of fields for partition function not found in table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1468 SELECT "HY000 (ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR) List of fields is only allowed in KEY partitions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1469 SELECT "HY000 (ER_INCONSISTENT_PARTITION_INFO_ERROR) The partition info in the frm file is not consistent with what can be written into the frm file" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1470 SELECT "HY000 (ER_PARTITION_FUNC_NOT_ALLOWED_ERROR) The %s function returns the wrong type" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1471 SELECT "HY000 (ER_PARTITIONS_MUST_BE_DEFINED_ERROR) For %s partitions each partition must be defined" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1472 SELECT "HY000 (ER_RANGE_NOT_INCREASING_ERROR) VALUES LESS THAN value must be strictly increasing for each partition" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1473 SELECT "HY000 (ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR) VALUES value must be of same type as partition function" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1474 SELECT "HY000 (ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR) Multiple definition of same constant in list partitioning" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1475 SELECT "HY000 (ER_PARTITION_ENTRY_ERROR) Partitioning can not be used stand-alone in query" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1476 SELECT "HY000 (ER_MIX_HANDLER_ERROR) The mix of handlers in the partitions is not allowed in this version of MySQL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1477 SELECT "HY000 (ER_PARTITION_NOT_DEFINED_ERROR) For the partitioned engine it is necessary to define all %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1478 SELECT "HY000 (ER_TOO_MANY_PARTITIONS_ERROR) Too many partitions (including subpartitions) were defined" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1479 SELECT "HY000 (ER_SUBPARTITION_ERROR) It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1480 SELECT "HY000 (ER_CANT_CREATE_HANDLER_FILE) Failed to create specific handler file" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1481 SELECT "HY000 (ER_BLOB_FIELD_IN_PART_FUNC_ERROR) A BLOB field is not allowed in partition function" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1482 SELECT "HY000 (ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) A %s need to include all fields in the partition function" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1483 SELECT "HY000 (ER_NO_PARTS_ERROR) Number of %s = 0 is not an allowed value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1484 SELECT "HY000 (ER_PARTITION_MGMT_ON_NONPARTITIONED) Partition management on a not partitioned table is not possible" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1485 SELECT "HY000 (ER_FOREIGN_KEY_ON_PARTITIONED) Foreign key condition is not yet supported in conjunction with partitioning" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1487 SELECT "HY000 (ER_DROP_LAST_PARTITION) Cannot remove all partitions, use DROP TABLE instead" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1488 SELECT "HY000 (ER_COALESCE_ONLY_ON_HASH_PARTITION) COALESCE PARTITION can only be used on HASH/KEY partitions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1489 SELECT "HY000 (ER_REORG_HASH_ONLY_ON_SAME_NO) REORGANISE PARTITION can only be used to reorganise partitions not to change their numbers" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1490 SELECT "HY000 (ER_REORG_NO_PARAM_ERROR) REORGANISE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1491 SELECT "HY000 (ER_ONLY_ON_RANGE_LIST_PARTITION) %s PARTITION can only be used on RANGE/LIST partitions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1492 SELECT "HY000 (ER_ADD_PARTITION_SUBPART_ERROR) Trying to Add partition(s) with wrong number of subpartitions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1493 SELECT "HY000 (ER_ADD_PARTITION_NO_NEW_PARTITION) At least one partition must be added" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1494 SELECT "HY000 (ER_COALESCE_PARTITION_NO_PARTITION) At least one partition must be coalesced" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1495 SELECT "HY000 (ER_REORG_PARTITION_NOT_EXIST) More partitions to reorganise than there are partitions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1496 SELECT "HY000 (ER_SAME_NAME_PARTITION) Duplicate partition name %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1497 SELECT "HY000 (ER_NO_BINLOG_ERROR) It is not allowed to shut off binlog on this command" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1498 SELECT "HY000 (ER_CONSECUTIVE_REORG_PARTITIONS) When reorganising a set of partitions they must be in consecutive order" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1499 SELECT "HY000 (ER_REORG_OUTSIDE_RANGE) Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1500 SELECT "HY000 (ER_PARTITION_FUNCTION_FAILURE) Partition function not supported in this version for this handler" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1501 SELECT "HY000 (ER_PART_STATE_ERROR) Partition state cannot be defined from CREATE/ALTER TABLE" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1502 SELECT "HY000 (ER_LIMITED_PART_RANGE) The %s handler only supports 32 bit integers in VALUES" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1503 SELECT "HY000 (ER_PLUGIN_IS_NOT_LOADED) Plugin '%s' is not loaded" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1504 SELECT "HY000 (ER_WRONG_VALUE) Incorrect %s valu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1505 SELECT "HY000 (ER_NO_PARTITION_FOR_GIVEN_VALUE) Table has no partition for value %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1506 SELECT "HY000 (ER_FILEGROUP_OPTION_ONLY_ONCE) It is not allowed to specify %s more than once" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1507 SELECT "HY000 (ER_CREATE_FILEGROUP_FAILED) Failed to create %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1508 SELECT "HY000 (ER_DROP_FILEGROUP_FAILED) Failed to drop %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1509 SELECT "HY000 (ER_TABLESPACE_AUTO_EXTEND_ERROR) The handler doesn't support autoextend of tablespaces" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1510 SELECT "HY000 (ER_WRONG_SIZE_NUMBER) A size parameter was incorrectly specified, either number or on the form 10M" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1511 SELECT "HY000 (ER_SIZE_OVERFLOW_ERROR) The size number was correct but we don't allow the digit part to be more than 2 billion" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1512 SELECT "HY000 (ER_ALTER_FILEGROUP_FAILED) Failed to alte" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1513 SELECT "HY000 (ER_BINLOG_ROW_LOGGING_FAILED) Writing one row to the row-based binary log failed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1514 SELECT "HY000 (ER_BINLOG_ROW_WRONG_TABLE_DEF) Table definition on master and slave does not match" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1515 SELECT "HY000 (ER_BINLOG_ROW_RBR_TO_SBR) Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1516 SELECT "HY000 (ER_EVENT_ALREADY_EXISTS) Event '%s' already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1518 SELECT "HY000 (ER_EVENT_DOES_NOT_EXIST) Unknown event '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1519 SELECT "HY000 (ER_EVENT_CANT_ALTER) Failed to alter event '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1520 SELECT "HY000 (ER_EVENT_DROP_FAILED) Failed to drop %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1521 SELECT "HY000 (ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG) INTERVAL is either not positive or too big" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1522 SELECT "HY000 (ER_EVENT_ENDS_BEFORE_STARTS) ENDS is either invalid or before STARTS" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1523 SELECT "HY000 (ER_EVENT_EXEC_TIME_IN_THE_PAST) Activation (AT) time is in the past" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1524 SELECT "HY000 (ER_EVENT_OPEN_TABLE_FAILED) Failed to open mysql.event" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1525 SELECT "HY000 (ER_EVENT_NEITHER_M_EXPR_NOR_M_AT) No datetime expression provided" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1526 SELECT "HY000 (ER_COL_COUNT_DOESNT_MATCH_CORRUPTED) Column count of mysql.%s is wrong. Expected %d, found %d. Table probably corrupted" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1527 SELECT "HY000 (ER_CANNOT_LOAD_FROM_TABLE) Cannot load from mysql.%s. Table probably corrupted. See error log." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1528 SELECT "HY000 (ER_EVENT_CANNOT_DELETE) Failed to delete the event from mysql.event" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1530 SELECT "HY000 (ER_EVENT_SAME_NAME) Same old and new event name" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1531 SELECT "HY000 (ER_EVENT_DATA_TOO_LONG) Data for column '%s' too long" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1532 SELECT "HY000 (ER_DROP_INDEX_FK) Cannot drop index '%s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1533 SELECT "HY000 (ER_CANT_WRITE_LOCK_LOG_TABLE) You can't write-lock a log table. Only read access is possible." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1534 SELECT "HY000 (ER_CANT_READ_LOCK_LOG_TABLE) You can't use usual read lock with log tables. Try READ LOCAL instead." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1535 SELECT "42000 (ER_SP_WRONG_NAME) Incorrect routine name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1536 SELECT "23000 (ER_FOREIGN_DUPLICATE_KEY) Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1537 SELECT "HY000 (ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE) Column count of mysql.%s is wrong. Expected %d, found %d. Created with MySQL %d, now running %d. Please use scripts/mysql_fix_privilege_tables" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1538 SELECT "HY000 (ER_TABLE_NEEDS_UPGRADE) Table upgrade required. Please do REPAIR TABLE `%s` to fix it!" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1539 SELECT "HY000 (ER_ILLEGAL_HA_CREATE_OPTION) Table storage engine '%s' does not support the create option '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1540 SELECT "25001 (ER_CANT_CHANGE_TX_ISOLATION) Transaction isolation level can't be changed while a transaction is in progress" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1541 SELECT "HY000 (ER_WARN_DEPRECATED) The syntax '%s' is deprecated and will be removed in MySQL %s. Please use %s instead." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1542 SELECT "42000 (ER_SP_NO_AGGREGATE) AGGREGATE is not supported for stored functions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1543 SELECT "HY000 (ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR) Cannot switch out of the row-based binary log format when the session has open temporary tables" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1544 SELECT "HY000 (ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT) Cannot change the binary logging format inside a stored function or trigger" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1545 SELECT "HY000 (ER_NDB_CANT_SWITCH_BINLOG_FORMAT) The NDB cluster engine does not support changing the binlog format on the fly yet" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1546 SELECT "HY000 (ER_PARTITION_NO_TEMPORARY) Cannot create temporary table with partitions" as 'ERROR_NO SQLSTATE';

DECLARE EXIT HANDLER FOR SQLSTATE '23000' SELECT "23000 ER_DUP_KEY Can't write; duplicate key in table '%s'" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'HY001' SELECT "HY001 ER_OUTOFMEMORY Out of memory; restart server and try again (needed %d bytes)" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'HY000' SELECT "HY000 ER_UNEXPECTED_EOF Unexpected EOF found when reading file '%s' (errno: %d)" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '08004' SELECT "08004 ER_CON_COUNT_ERROR Unexpected EOF found when reading file '%s' (errno: %d)" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '08S01' SELECT "08S01 ER_BAD_HOST_ERROR Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '28000' SELECT "28000 ER_ACCESS_DENIED_ERROR Access denied for user '%s'@'%s' to database '%s'" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '3D000' SELECT "3D000 ER_NO_DB_ERROR Access denied for user '%s'@'%s' (using password: %s)" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42S01' SELECT "42S01 ER_TABLE_EXISTS_ERROR Unknown database '%s'" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42S02' SELECT "42S02 ER_BAD_TABLE_ERROR Table '%s' already exists" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42S22' SELECT "42S22 ER_BAD_FIELD_ERROR Server shutdown in progress" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '21S01' SELECT "21S01 ER_WRONG_VALUE_COUNT Statement has sum functions and columns in same statement" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42S21' SELECT "42S21 ER_DUP_FIELDNAME Identifier name '%s' is too long" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42S12' SELECT "42S12 ER_NO_SUCH_INDEX Can't create IP socket" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '25000' SELECT "25000 ER_CANT_DO_THIS_DURING_AN_TRANSACTION The storage engine for the table doesn't support %s" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '40001' SELECT "40001 ER_LOCK_DEADLOCK Deadlock found when trying to get lock; try restarting transaction" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '21000' SELECT "21000 ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT The used SELECT statements have a different number of columns" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '01000' SELECT "01000 ER_WARN_TOO_FEW_RECORDS Row %ld doesn't contain data for all columns" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '22004' SELECT "22004 ER_WARN_NULL_TO_NOTNULL Row %ld was truncated; it contained more data than there were input columns" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '2F003' SELECT "2F003 ER_SP_NO_RECURSIVE_CREATE Can't create a %s from within another stored routine" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '0A000' SELECT "0A000 ER_SP_BADSELECT PROCEDURE %s can't return a result set in the given context" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '70100' SELECT "70100 ER_QUERY_INTERRUPTED Query execution was interrupted" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '42000' SELECT "42000 ER_SP_WRONG_NO_OF_ARGS Query execution was interrupted" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '2F005' SELECT "2F005 ER_SP_NORETURNEND No RETURN found in FUNCTION %s" as 'SQLSTATE';

DECLARE EXIT HANDLER FOR SQLSTATE '22012' SELECT "22012 ER_DIVISION_BY_ZERO Field '%s' doesn't have a default value" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '22007' SELECT "22007 ER_ILLEGAL_VALUE_FOR_TYPE Incorrect %s value: '%s' for column '%s' at row %ld" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XAE04' SELECT "XAE04 ER_XAER_NOTA Operation %s failed for %s" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XAE07' SELECT "XAE07 ER_XAER_RMFAIL XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XAE09' SELECT "XAE09 ER_XAER_OUTSIDE XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XAE03' SELECT "XAE03 ER_XAER_RMERR XAER_OUTSIDE: Some work is done outside global transaction" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XA100' SELECT "XA100 ER_XA_RBROLLBACK XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '22001' SELECT "22001 ER_DATA_TOO_LONG Data too long for column '%s' at row %ld" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '22003' SELECT "22003 ER_CANT_CREATE_GEOMETRY_OBJECT Not allowed to return a result set from a %s" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE 'XAE08' SELECT "XAE08 ER_XAER_DUPID Display width out of range for column '%s' (max = %d)" as 'SQLSTATE';
DECLARE EXIT HANDLER FOR SQLSTATE '22008' SELECT "22008 ER_DATETIME_FUNCTION_OVERFLOW XAER_DUPID: The XID already exists" as 'SQLSTATE';
/* handler gigante END */

Options: ReplyQuote


Subject Views Written By Posted
HOW CAN I CAPTURE DE ERROR 2204 Fabio Deodoro 04/05/2006 08:06AM
Re: HOW CAN I CAPTURE DE ERROR 1820 Roland Bouman 04/05/2006 05:13PM
Re: HOW CAN I CAPTURE DE ERROR 1585 Fabio Deodoro 04/06/2006 06:33AM
Re: HOW CAN I CAPTURE DE ERROR 1643 Roland Bouman 04/06/2006 08:37AM
Re: HOW CAN I CAPTURE DE ERROR 5622 Claudio G 04/06/2006 02:37PM
Re: HOW CAN I CAPTURE DE ERROR 7126 Claudio G 04/06/2006 02:41PM
DECLARE EXIT HANDLER FOR 1135 SELECT "HY000 (ER_CANT_CREATE_THREAD) Can't create a new thread (errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug" as 'ERROR_NO SQLSTATE'; 2035 mohamed said 04/24/2006 05:49AM
Re: HOW CAN I CAPTURE DE ERROR 1600 Roland Bouman 04/24/2006 08:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.