Bug #13346 | mysqlchek on information_schema | ||
---|---|---|---|
Submitted: | 20 Sep 2005 10:52 | Modified: | 20 Sep 2005 13:12 |
Reporter: | Ludger Kluitmann | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.12 | OS: | Linux (Linux) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[20 Sep 2005 10:52]
Ludger Kluitmann
[20 Sep 2005 13:12]
MySQL Verification Team
Below is the behavior with current source server: miguel@hegel:~/dbs/5.0> bin/mysqlcheck --all-databases information_schema.CHARACTER_SETS note : The storage engine for the table doesn't support check information_schema.COLLATIONS note : The storage engine for the table doesn't support check information_schema.COLLATION_CHARACTER_SET_APPLICABILITY note : The storage engine for the table doesn't support check information_schema.COLUMNS OK information_schema.COLUMN_PRIVILEGES note : The storage engine for the table doesn't support check information_schema.KEY_COLUMN_USAGE note : The storage engine for the table doesn't support check information_schema.ROUTINES OK information_schema.SCHEMATA note : The storage engine for the table doesn't support check information_schema.SCHEMA_PRIVILEGES note : The storage engine for the table doesn't support check information_schema.STATISTICS note : The storage engine for the table doesn't support check information_schema.TABLES note : The storage engine for the table doesn't support check information_schema.TABLE_CONSTRAINTS note : The storage engine for the table doesn't support check information_schema.TABLE_PRIVILEGES note : The storage engine for the table doesn't support check information_schema.TRIGGERS OK information_schema.VIEWS OK information_schema.USER_PRIVILEGES note : The storage engine for the table doesn't support check test.jj OK test.tb OK test.tb_v OK test.test OK
[20 Sep 2005 13:37]
Ludger Kluitmann
ok so far. But mysqlcheck output could be a bit more readable, maybe like the following example information_schema.CHARACTER_SETS not checked information_schema.COLLATIONS not checked information_schema.COLLATION_CHARACTER_SET_APPLICABILITY not checked information_schema.COLUMNS OK information_schema.COLUMN_PRIVILEGES not checked information_schema.KEY_COLUMN_USAGE not checked information_schema.ROUTINES OK information_schema.SCHEMATA not checked information_schema.SCHEMA_PRIVILEGES not checked . . . . . test.jj OK test.tb OK test.tb_v OK test.test OK note: not checked means the storage engine for the table doesn't support check