Bug #47547 mysqlcheck --silent is not silent enough
Submitted: 23 Sep 2009 11:23 Modified: 23 Sep 2009 11:49
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.x, OS:Any
Assigned to: CPU Architecture:Any

[23 Sep 2009 11:23] Shane Bester
mysqlcheck has the --silent option which is not silent enough. It prints out warnings and notes still:

"-s, --silent        Print only error messages."

shell>./mysqlcheck test --check --silent
note     : The storage engine for the table doesn't support check
warning  : Found row where the auto_increment column has the value 0

How to repeat:
drop table if exists t2,t1;
create table t1(a int)engine=memory;
create table t2(a int auto_increment primary key)engine=myisam;
insert into t2 values (1);
update t2 set a=0;

mysqlcheck test -uroot --check --silent

Suggested fix:
don't print out warnings and notes when operating in silent mode.
[23 Sep 2009 11:49] Valeriy Kravchuk
Thank you for the problem report. Verified just as described.