diff options
| author | unknown <elliot@mysql.com> | 2006-06-23 17:59:24 -0400 |
|---|---|---|
| committer | unknown <elliot@mysql.com> | 2006-06-23 17:59:24 -0400 |
| commit | 3d4632b80fb7fc545794444cc9e1b233d97213fe (patch) | |
| tree | e8416b2247ba4b93cfff1be3c77ad1b1685206df /mysql-test/r/lock_multi.result | |
| parent | b02748fd5c54e05aca990583a4cb0f71a82ee4b4 (diff) | |
| download | mariadb-git-3d4632b80fb7fc545794444cc9e1b233d97213fe.tar.gz | |
Post merge fix.
Diffstat (limited to 'mysql-test/r/lock_multi.result')
| -rw-r--r-- | mysql-test/r/lock_multi.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/lock_multi.result b/mysql-test/r/lock_multi.result index b9500d1d4f9..f8cf539bd02 100644 --- a/mysql-test/r/lock_multi.result +++ b/mysql-test/r/lock_multi.result @@ -80,3 +80,19 @@ lock tables t1 write; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; // unlock tables; drop table t1; +use mysql; +LOCK TABLES columns_priv WRITE, db WRITE, host WRITE, user WRITE; +FLUSH TABLES; +use mysql; + SELECT user.Select_priv FROM user, db WHERE user.user = db.user LIMIT 1; +OPTIMIZE TABLES columns_priv, db, host, user; +Table Op Msg_type Msg_text +mysql.columns_priv optimize status OK +mysql.db optimize status OK +mysql.host optimize status OK +mysql.user optimize status OK +UNLOCK TABLES; +Select_priv +N +use test; +use test; |