Debian Codegraph @

mysql-test/suite/innodb/t/row_format_redundant.test

raw
1 --source include/have_debug.inc
2
3 --echo #
4 --echo # Bug#21644827 - FTS, ASSERT !SRV_READ_ONLY_MODE || M_IMPL.M_LOG_MODE ==
5 --echo # MTR_LOG_NO_REDO
6 --echo #
7
8 create table t1 (a int not null, d varchar(15) not null, b
9 varchar(198) not null, c char(156),
10 fulltext ftsic(c)) engine=InnoDB
11 row_format=redundant;
12
13 insert into t1 values(123, 'abcdef', 'jghikl', 'mnop');
14 insert into t1 values(456, 'abcdef', 'jghikl', 'mnop');
15 insert into t1 values(789, 'abcdef', 'jghikl', 'mnop');
16 insert into t1 values(134, 'kasdfsdsadf', 'adfjlasdkfjasd', 'adfsadflkasdasdfljasdf');
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 insert into t1 select * from t1;
24 insert into t1 select * from t1;
25 insert into t1 select * from t1;
26 insert into t1 select * from t1;
27
28 SET GLOBAL innodb_file_per_table=OFF;
29 create table t2 (a int not null, d varchar(15) not null, b
30 varchar(198) not null, c char(156), fulltext ftsic(c)) engine=InnoDB
31 row_format=redundant;
32
33 insert into t2 select * from t1;
34
35 create table t3 (a int not null, d varchar(15) not null, b varchar(198),
36 c varchar(150), index k1(c(99), b(56)), index k2(b(5), c(10))) engine=InnoDB
37 row_format=redundant;
38
39 insert into t3 values(444, 'dddd', 'bbbbb', 'aaaaa');
40 insert into t3 values(555, 'eeee', 'ccccc', 'aaaaa');
41
42 # Suppress the known warnings in the read-only-mode
43 --source include/add_mtr_suppression_for_innodb_readonly.inc
44
45 # read-only restart requires the change buffer to be empty; therefore we
46 # do a slow shutdown.
47 SET GLOBAL innodb_fast_shutdown=0;
48 let $restart_parameters = restart: --innodb-read-only;
49 --source include/restart_mysqld.inc
50
51 SELECT COUNT(*) FROM t1;
52 SELECT COUNT(*) FROM t2;
53 SELECT COUNT(*) FROM t3;
54
55 let $restart_parameters = restart;
56 --source include/restart_mysqld.inc
57
58 TRUNCATE TABLE t1;
59 TRUNCATE TABLE t2;
60 TRUNCATE TABLE t3;
61
62 # These messages are relevant only when this debug parameter
63 # "ib_table_invalid_flags" is enabled
64 # In new DD, we don't load table from InnoDB data dictionary.
65 --disable_query_log
66 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Table `test`.`t1` in InnoDB data dictionary contains invalid flags. SYS_TABLES.MIX_LEN=255");
67 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Parent table of FTS auxiliary table test/FTS_.* not found.");
68 --enable_query_log
69
70 let $restart_parameters = restart: --debug=d,ib_table_invalid_flags;
71 --source include/restart_mysqld.inc
72
73 #--error ER_NO_SUCH_TABLE
74 SELECT * FROM t1;
75
76 let $restart_parameters = restart;
77 --source include/restart_mysqld.inc
78
79 DROP TABLE t1;
80 DROP TABLE t2;
81 DROP TABLE t3;