diff options
Diffstat (limited to 'mysql-test/t/mysqlcheck.test')
| -rw-r--r-- | mysql-test/t/mysqlcheck.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/mysqlcheck.test b/mysql-test/t/mysqlcheck.test index f5eddff8816..074faa48021 100644 --- a/mysql-test/t/mysqlcheck.test +++ b/mysql-test/t/mysqlcheck.test @@ -11,6 +11,7 @@ drop database if exists client_test_db; DROP SCHEMA test; CREATE SCHEMA test; +use test; # # Bug #13783 mysqlcheck tries to optimize and analyze information_schema # @@ -19,3 +20,17 @@ CREATE SCHEMA test; --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 |