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)
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.x,
• OS: Any
• CPU Architecture: Any

[23 Sep 2009 11:23] Shane Bester

Description:
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
test.t1
note     : The storage engine for the table doesn't support check
test.t2
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.