Debian Codegraph @

mysql-test/suite/innodb/r/row_format_redundant.result

raw
1 #
2 # Bug#21644827 - FTS, ASSERT !SRV_READ_ONLY_MODE || M_IMPL.M_LOG_MODE ==
3 # MTR_LOG_NO_REDO
4 #
5 create table t1 (a int not null, d varchar(15) not null, b
6 varchar(198) not null, c char(156),
7 fulltext ftsic(c)) engine=InnoDB
8 row_format=redundant;
9 insert into t1 values(123, 'abcdef', 'jghikl', 'mnop');
10 insert into t1 values(456, 'abcdef', 'jghikl', 'mnop');
11 insert into t1 values(789, 'abcdef', 'jghikl', 'mnop');
12 insert into t1 values(134, 'kasdfsdsadf', 'adfjlasdkfjasd', 'adfsadflkasdasdfljasdf');
13 insert into t1 select * from t1;
14 insert into t1 select * from t1;
15 insert into t1 select * from t1;
16 insert into t1 select * from t1;
17 insert into t1 select * from t1;
18 insert into t1 select * from t1;
19 insert into t1 select * from t1;
20 insert into t1 select * from t1;
21 insert into t1 select * from t1;
22 insert into t1 select * from t1;
23 SET GLOBAL innodb_file_per_table=OFF;
24 create table t2 (a int not null, d varchar(15) not null, b
25 varchar(198) not null, c char(156), fulltext ftsic(c)) engine=InnoDB
26 row_format=redundant;
27 insert into t2 select * from t1;
28 create table t3 (a int not null, d varchar(15) not null, b varchar(198),
29 c varchar(150), index k1(c(99), b(56)), index k2(b(5), c(10))) engine=InnoDB
30 row_format=redundant;
31 insert into t3 values(444, 'dddd', 'bbbbb', 'aaaaa');
32 insert into t3 values(555, 'eeee', 'ccccc', 'aaaaa');
33 SET GLOBAL innodb_fast_shutdown=0;
34 # restart: --innodb-read-only
35 SELECT COUNT(*) FROM t1;
36 COUNT(*)
37 4096
38 SELECT COUNT(*) FROM t2;
39 COUNT(*)
40 4096
41 SELECT COUNT(*) FROM t3;
42 COUNT(*)
43 2
44 # restart
45 TRUNCATE TABLE t1;
46 TRUNCATE TABLE t2;
47 TRUNCATE TABLE t3;
48 # restart: --debug=d,ib_table_invalid_flags
49 SELECT * FROM t1;
50 a d b c
51 # restart
52 DROP TABLE t1;
53 DROP TABLE t2;
54 DROP TABLE t3;