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 | c4bfacd7770c5b55c81caec16bc58687f8d974e1 (patch) | |
| tree | 0a34744b847839984e06d4a29f203d7821050b64 /mysql-test/r/mysqlcheck.result | |
| parent | dc50ce997083b4f3d3e4ab237c6a1f5e11cfd90f (diff) | |
| download | mariadb-git-c4bfacd7770c5b55c81caec16bc58687f8d974e1.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/r/mysqlcheck.result')
| -rw-r--r-- | mysql-test/r/mysqlcheck.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/mysqlcheck.result b/mysql-test/r/mysqlcheck.result index 8c98e18aa9b..df0835b830c 100644 --- a/mysql-test/r/mysqlcheck.result +++ b/mysql-test/r/mysqlcheck.result @@ -32,3 +32,10 @@ mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK +create table t1 (a int); +create view v1 as select * from t1; +test.t1 OK +test.t1 OK +drop view v1; +drop table t1; +End of 5.0 tests |