summaryrefslogtreecommitdiff
path: root/mysql-test/suite/archive/archive.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/archive/archive.test')
-rw-r--r--mysql-test/suite/archive/archive.test23
1 files changed, 16 insertions, 7 deletions
diff --git a/mysql-test/suite/archive/archive.test b/mysql-test/suite/archive/archive.test
index 2d184110a2d..b6920827005 100644
--- a/mysql-test/suite/archive/archive.test
+++ b/mysql-test/suite/archive/archive.test
@@ -7,10 +7,6 @@
CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired");
---disable_warnings
-DROP TABLE if exists t1,t2,t3,t4,t5,t6;
---enable_warnings
-
SET default_storage_engine=ARCHIVE;
let $MYSQLD_DATADIR= `SELECT @@datadir`;
@@ -1770,9 +1766,9 @@ select * from t1;
show warnings;
drop table t1;
-#
-# temporary archive
-#
+--echo #
+--echo # temporary archive
+--echo #
create temporary table t1 (a int) engine=archive;
insert t1 values (1),(2),(3);
select * from t1;
@@ -1782,3 +1778,16 @@ select * from t1;
show create table t1;
drop table t1;
+--echo #
+--echo # End of 10.0 tests
+--echo #
+
+--echo #
+--echo # MDEV-27396 DESC index attribute remains in Archive table definition, despite being apparently ignored
+--echo #
+--error ER_CANT_CREATE_TABLE
+create table t (t int auto_increment, key (t desc)) engine=archive;
+
+--echo #
+--echo # End of 10.8 tests
+--echo #