Bug #18244 mysqlcheck

• Submitted: 15 Mar 2006 2:04
• Modified: 15 Mar 2006 2:55
• Reporter: Eddie Cheung
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.19
• OS: Solaris (Solaris 8 SPARC 64bit)
• CPU Architecture: Any

[15 Mar 2006 2:04] Eddie Cheung

Description:
When I run mysqlcheck on checking all tables and all databases, it also checks the created View and return Error that 

cpdb.all_song_tables
error    : 'cpdb.all_song_tables' is not BASE TABLE
cpdb.full_song_tables
error    : 'cpdb.full_song_tables' is not BASE TABLE
cpdb.mv_song_tables
error    : 'cpdb.mv_song_tables' is not BASE TABLE
cpdb.rt_song_tables
error    : 'cpdb.rt_song_tables' is not BASE TABLE
cpdb.vrt_song_tables
error    : 'cpdb.vrt_song_tables' is not BASE TABLE

where cpdb.*_tables are View, not really a table.

How to repeat:
Create dummy table in a database
Create dummy view in that database

run 

/usr/local/mysql/bin/mysqlcheck -s -a -A

Suggested fix:
Give an option to check on View and skip checking "view" while checking "table".

[15 Mar 2006 2:55] MySQL Verification Team

Thank you for the bug report. Duplicate of bug http://bugs.mysql.com/bug.php?id=16502.