Description:
There are some additional warning messages noticed by SHOW WARNINGS statement in 5.X when ER_UNKNOWN_STORAGE_ENGINE is used in the test.
They are,
Warning 1286 Unknown table engine 'PARADOX'
Warning 1286 Unknown table engine 'PARADOX'
When checked with Luis, he said it can be because of the following,
in get_schema_triggers_record:
/*
res can be non zero value when processed table is a view or
error happened during opening of processed table.
*/
if (res)
{
if (thd->is_error())
push_warning(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
thd->stmt_da->sql_errno(), thd->stmt_da->message());
thd->clear_error();
DBUG_RETURN(0);
}
push_warning is not called in mysql-6.0-codebase tree
Same warnings and error messages should be issued by SHOW WARNINGS in MySQL 5.X and 6.0 trees.
How to repeat:
Run the backup_no_engine.test from backup suite in 5.X and 6.0. we can notice the following additional warning messages issued which are not noticed in 6.0
Test run in 5.X produces the following result
---------------------------------------------
BACKUP DATABASE db TO "db.backup";
ERROR 42000: Unknown table engine 'PARADOX'
SHOW WARNINGS;
Level Code Message
Warning 1286 Unknown table engine 'PARADOX'
Warning 1286 Unknown table engine 'PARADOX'
Error 1286 Unknown table engine 'PARADOX'
Error 1662 Can't access storage engine of table `db`.`t2`
Warning 1792 Operation aborted
DROP DATABASE db;
Test run in 6.0 produces the following result
--------------------------------------------
BACKUP DATABASE db TO "db.backup";
ERROR 42000: Unknown storage engine 'PARADOX'
SHOW WARNINGS;
Level Code Message
Error 1286 Unknown storage engine 'PARADOX'
Error 1642 Can't access storage engine of table `db`.`t2`
Warning 1777 Operation aborted
Note that this is not a Backup error but the issue in server code.
Description: There are some additional warning messages noticed by SHOW WARNINGS statement in 5.X when ER_UNKNOWN_STORAGE_ENGINE is used in the test. They are, Warning 1286 Unknown table engine 'PARADOX' Warning 1286 Unknown table engine 'PARADOX' When checked with Luis, he said it can be because of the following, in get_schema_triggers_record: /* res can be non zero value when processed table is a view or error happened during opening of processed table. */ if (res) { if (thd->is_error()) push_warning(thd, MYSQL_ERROR::WARN_LEVEL_WARN, thd->stmt_da->sql_errno(), thd->stmt_da->message()); thd->clear_error(); DBUG_RETURN(0); } push_warning is not called in mysql-6.0-codebase tree Same warnings and error messages should be issued by SHOW WARNINGS in MySQL 5.X and 6.0 trees. How to repeat: Run the backup_no_engine.test from backup suite in 5.X and 6.0. we can notice the following additional warning messages issued which are not noticed in 6.0 Test run in 5.X produces the following result --------------------------------------------- BACKUP DATABASE db TO "db.backup"; ERROR 42000: Unknown table engine 'PARADOX' SHOW WARNINGS; Level Code Message Warning 1286 Unknown table engine 'PARADOX' Warning 1286 Unknown table engine 'PARADOX' Error 1286 Unknown table engine 'PARADOX' Error 1662 Can't access storage engine of table `db`.`t2` Warning 1792 Operation aborted DROP DATABASE db; Test run in 6.0 produces the following result -------------------------------------------- BACKUP DATABASE db TO "db.backup"; ERROR 42000: Unknown storage engine 'PARADOX' SHOW WARNINGS; Level Code Message Error 1286 Unknown storage engine 'PARADOX' Error 1642 Can't access storage engine of table `db`.`t2` Warning 1777 Operation aborted Note that this is not a Backup error but the issue in server code.