diff options
| author | unknown <jimw@rama.(none)> | 2006-07-24 13:31:20 -0700 |
|---|---|---|
| committer | unknown <jimw@rama.(none)> | 2006-07-24 13:31:20 -0700 |
| commit | 7c981312142968d063d9a75150ba992a04ec18f1 (patch) | |
| tree | 0a34744b847839984e06d4a29f203d7821050b64 /mysql-test/t/mysqlcheck.test | |
| parent | 836499e9b0a6ab4cf4ee778261583a3f86a64a8e (diff) | |
| download | mariadb-git-7c981312142968d063d9a75150ba992a04ec18f1.tar.gz | |
Bug #16502: mysqlcheck gets confused with views
Make mysqlcheck skip over views when processing all of the tables in a
database.
client/mysqlcheck.c:
Use SHOW TABLE STATUS to get table list, and skip over things that don't
have an engine (like a VIEW).
mysql-test/r/mysqlcheck.result:
Add new results
mysql-test/t/mysqlcheck.test:
Add new regression test
Diffstat (limited to 'mysql-test/t/mysqlcheck.test')
| -rw-r--r-- | mysql-test/t/mysqlcheck.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/mysqlcheck.test b/mysql-test/t/mysqlcheck.test index bc88be001ab..338e16363ea 100644 --- a/mysql-test/t/mysqlcheck.test +++ b/mysql-test/t/mysqlcheck.test @@ -9,3 +9,17 @@ --replace_result 'Table is already up to date' OK --exec $MYSQL_CHECK --analyze --optimize --databases test information_schema mysql --exec $MYSQL_CHECK --analyze --optimize information_schema schemata + +# +# Bug #16502: mysqlcheck tries to check views +# +create table t1 (a int); +create view v1 as select * from t1; +--replace_result 'Table is already up to date' OK +--exec $MYSQL_CHECK --analyze --optimize --databases test +--replace_result 'Table is already up to date' OK +--exec $MYSQL_CHECK --all-in-1 --analyze --optimize --databases test +drop view v1; +drop table t1; + +--echo End of 5.0 tests |