summaryrefslogtreecommitdiff
path: root/mysql-test/suite/archive
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-11-28 16:39:17 +0100
committerSergei Golubchik <sergii@pisem.net>2013-11-28 16:39:17 +0100
commit38c91c067ba36e1bdc11ded707db9b9f0c84b871 (patch)
tree40ecd9f9293889712e781a194b00ff3f0f52522e /mysql-test/suite/archive
parent1387e71531495b1224bfafd6867ae5fae9cf469c (diff)
downloadmariadb-git-38c91c067ba36e1bdc11ded707db9b9f0c84b871.tar.gz
MDEV-4955 discover of table non-existance on CREATE
when frm file exists, but the table does not. In recover_from_failed_open(), allow the discovery to fail without an error, when open_strategy == TABLE_LIST::OPEN_IF_EXISTS.
Diffstat (limited to 'mysql-test/suite/archive')
-rw-r--r--mysql-test/suite/archive/discover.result6
-rw-r--r--mysql-test/suite/archive/discover.test10
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/archive/discover.result b/mysql-test/suite/archive/discover.result
index a2a0bfcd8d5..c4f4bb4104f 100644
--- a/mysql-test/suite/archive/discover.result
+++ b/mysql-test/suite/archive/discover.result
@@ -130,3 +130,9 @@ a
flush tables;
select * from t1;
ERROR 42S02: Table 'test.t1' doesn't exist
+create table t1 (a int) engine=archive;
+select * from t1;
+a
+flush tables;
+create table t1 (a int) engine=archive;
+drop table t1;
diff --git a/mysql-test/suite/archive/discover.test b/mysql-test/suite/archive/discover.test
index ad53ffa78c8..8dfe09f7b33 100644
--- a/mysql-test/suite/archive/discover.test
+++ b/mysql-test/suite/archive/discover.test
@@ -118,3 +118,13 @@ remove_file $mysqld_datadir/test/t1.ARZ;
select * from t1;
--list_files $mysqld_datadir/test
+#
+# MDEV-4955 discover of table non-existance on CREATE
+#
+create table t1 (a int) engine=archive;
+select * from t1;
+flush tables;
+remove_file $mysqld_datadir/test/t1.ARZ;
+create table t1 (a int) engine=archive;
+drop table t1;
+