diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 16:06:54 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 16:06:54 +0200 |
| commit | 474f45b3dc684b14c3b5ab86303c8aa890d2dce5 (patch) | |
| tree | 4b9ac6b86cb9dfc6ffbb6f7675f97e6081535ab2 /mysql-test | |
| parent | e06cb31719ce31fb1cd7944d1de86d4de9e3eca6 (diff) | |
| download | mariadb-git-474f45b3dc684b14c3b5ab86303c8aa890d2dce5.tar.gz | |
discover of table non-existance on drop
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/archive/discover.result | 12 | ||||
| -rw-r--r-- | mysql-test/suite/archive/discover.test | 12 |
2 files changed, 22 insertions, 2 deletions
diff --git a/mysql-test/suite/archive/discover.result b/mysql-test/suite/archive/discover.result index dc6d124d345..8cae289733b 100644 --- a/mysql-test/suite/archive/discover.result +++ b/mysql-test/suite/archive/discover.result @@ -76,9 +76,19 @@ t1 CREATE TABLE `t1` ( # discover on drop # flush tables; -drop table t0, t1; +drop table t1; show tables; Tables_in_test +t0 +# +# discover of table non-existance on drop +# +select * from t0; +a +flush tables; +select * from t1; +ERROR 42S02: Table 'test.t1' doesn't exist +drop table t0; # # Bug#45377: ARCHIVE tables aren't discoverable after OPTIMIZE # diff --git a/mysql-test/suite/archive/discover.test b/mysql-test/suite/archive/discover.test index 8175511929f..7a588d4654d 100644 --- a/mysql-test/suite/archive/discover.test +++ b/mysql-test/suite/archive/discover.test @@ -62,10 +62,20 @@ show create table t1; --echo # remove_file $mysqld_datadir/test/t1.frm; flush tables; -drop table t0, t1; +drop table t1; show tables; --echo # +--echo # discover of table non-existance on drop +--echo # +select * from t0; +remove_file $mysqld_datadir/test/t0.ARZ; +flush tables; +--error ER_NO_SUCH_TABLE +select * from t1; +drop table t0; + +--echo # --echo # Bug#45377: ARCHIVE tables aren't discoverable after OPTIMIZE --echo # |