diff options
Diffstat (limited to 'mysql-test/suite/archive/archive.result')
| -rw-r--r-- | mysql-test/suite/archive/archive.result | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/mysql-test/suite/archive/archive.result b/mysql-test/suite/archive/archive.result index a491b5bb9ee..67bbd3eb5e6 100644 --- a/mysql-test/suite/archive/archive.result +++ b/mysql-test/suite/archive/archive.result @@ -12731,15 +12731,6 @@ id id name name DROP TABLE t1,t2; flush tables; SHOW CREATE TABLE t1; -ERROR HY000: Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! -SELECT * FROM t1; -ERROR HY000: Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! -INSERT INTO t1 (col1, col2) VALUES (1, "value"); -ERROR HY000: Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! -REPAIR TABLE t1; -Table Op Msg_type Msg_text -test.t1 repair status OK -SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `col1` int(11) DEFAULT NULL, @@ -12747,6 +12738,10 @@ t1 CREATE TABLE `t1` ( ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 SELECT * FROM t1; col1 col2 +INSERT INTO t1 (col1, col2) VALUES (1, "value"); +REPAIR TABLE t1; +Table Op Msg_type Msg_text +test.t1 repair error Corrupt DROP TABLE t1; # # Ensure that TRUNCATE fails for non-empty archive tables. @@ -12811,6 +12806,14 @@ Table Op Msg_type Msg_text test.t1 optimize status OK DROP TABLE t1; # +# Bug#13907676: HA_ARCHIVE::INFO +# +CREATE TABLE t1 (a INT) ENGINE=ARCHIVE; +CREATE TABLE t2 SELECT * FROM t1; +SELECT * FROM t2; +a +DROP TABLE t1, t2; +# # BUG#917689 Using wrong archive table causes crash # create table t1 (a int, b char(50)) engine=archive; @@ -12821,7 +12824,6 @@ select * from t1; ERROR HY000: Table 't1' is marked as crashed and should be repaired show warnings; Level Code Message -Warning 127 Got error 127 when reading table `test`.`t1` Error 1194 Table 't1' is marked as crashed and should be repaired drop table t1; create temporary table t1 (a int) engine=archive; @@ -12835,7 +12837,7 @@ show create table t1; Table Create Table t1 CREATE TEMPORARY TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 DELAY_KEY_WRITE=1 alter table t1 add column b varchar(10); select * from t1; a b |