Looks like a known bug for some years now, without any progress:
http://bugs.mysql.com/bug.php?id=47547
[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.
You'll need to find another workaround, like you are stating with the grep suppression. Is the output that bad to look at or are you wanting a way to pull the errors out and do something with them?
