Bug #50295 Additional warning messages noticed for ER_UNKNOWN_STORAGE_ENGINE error
Submitted: 13 Jan 2010 0:19 Modified: 13 Jan 2010 8:38
Reporter: Hema Sridharan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:mysql-backup-backport OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D3 (Medium)

[13 Jan 2010 0:19] Hema Sridharan
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.
[13 Jan 2010 8:38] Sveta Smirnova
Thank you for the report.

Verified as described.