1# restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb-undo-tablespaces=0 --innodb-stats-persistent=0
2SET GLOBAL innodb_file_per_table=1;
3#
4# Bug#21644827 - FTS, ASSERT !SRV_READ_ONLY_MODE || M_IMPL.M_LOG_MODE ==
5#                MTR_LOG_NO_REDO
6#
7SET GLOBAL innodb_file_per_table=ON;
8create table t1 (a int not null, d varchar(15) not null, b
9varchar(198) not null, c char(156)) engine=InnoDB
10row_format=redundant;
11insert into t1 values(123, 'abcdef', 'jghikl', 'mnop');
12insert into t1 values(456, 'abcdef', 'jghikl', 'mnop');
13insert into t1 values(789, 'abcdef', 'jghikl', 'mnop');
14insert into t1 values(134, 'kasdfsdsadf', 'adfjlasdkfjasd', 'adfsadflkasdasdfljasdf');
15insert into t1 select * from t1;
16insert into t1 select * from t1;
17insert into t1 select * from t1;
18insert into t1 select * from t1;
19insert into t1 select * from t1;
20insert into t1 select * from t1;
21insert into t1 select * from t1;
22insert into t1 select * from t1;
23insert into t1 select * from t1;
24insert into t1 select * from t1;
25SET GLOBAL innodb_file_per_table=OFF;
26create table t2 (a int not null, d varchar(15) not null, b
27varchar(198) not null, c char(156), fulltext ftsic(c)) engine=InnoDB
28row_format=redundant;
29insert into t2 select * from t1;
30create table t3 (a int not null, d varchar(15) not null, b varchar(198),
31c varchar(150), index k1(c(99), b(56)), index k2(b(5), c(10))) engine=InnoDB
32row_format=redundant;
33insert into t3 values(444, 'dddd', 'bbbbb', 'aaaaa');
34insert into t3 values(555, 'eeee', 'ccccc', 'aaaaa');
35SET GLOBAL innodb_fast_shutdown=0;
36# restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb-undo-tablespaces=0 --innodb-stats-persistent=0 --innodb-read-only
37SELECT COUNT(*) FROM t1;
38COUNT(*)
394096
40SELECT COUNT(*) FROM t2;
41COUNT(*)
424096
43SELECT COUNT(*) FROM t3;
44COUNT(*)
452
46TRUNCATE TABLE t1;
47ERROR HY000: Table 't1' is read only
48TRUNCATE TABLE t2;
49ERROR HY000: Table 't2' is read only
50TRUNCATE TABLE t3;
51ERROR HY000: Table 't3' is read only
52# restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb-undo-tablespaces=0 --innodb-stats-persistent=0
53TRUNCATE TABLE t1;
54TRUNCATE TABLE t2;
55TRUNCATE TABLE t3;
56corrupted SYS_TABLES.MIX_LEN for test/t1
57corrupted SYS_TABLES.MIX_LEN for test/t2
58corrupted SYS_TABLES.MIX_LEN for test/t3
59# restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb-undo-tablespaces=0 --innodb-stats-persistent=0
60TRUNCATE TABLE t1;
61ERROR 42S02: Table 'test.t1' doesn't exist in engine
62TRUNCATE TABLE t2;
63TRUNCATE TABLE t3;
64SELECT COUNT(*) FROM t1;
65ERROR 42S02: Table 'test.t1' doesn't exist in engine
66SELECT COUNT(*) FROM t2;
67COUNT(*)
680
69SELECT COUNT(*) FROM t3;
70COUNT(*)
710
72RENAME TABLE t1 TO tee_one;
73ERROR HY000: Error on rename of './test/t1' to './test/tee_one' (errno: 155 "The table does not exist in the storage engine")
74DROP TABLE t1;
75Warnings:
76Warning	1932	Table 'test.t1' doesn't exist in engine
77DROP TABLE t2,t3;
78FOUND 5 /\[ERROR\] InnoDB: Table `test`\.`t1` in InnoDB data dictionary contains invalid flags\. SYS_TABLES\.TYPE=1 SYS_TABLES\.MIX_LEN=511\b/ in mysqld.1.err
79# restart
80ib_buffer_pool
81ib_logfile0
82ibdata1
83db.opt
84