Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4 --source include/not_embedded.inc
5 --source include/no_valgrind_without_big.inc
6
7 --echo #
8 --echo # MDEV-11415 AVOID INTERMEDIATE COMMIT WHILE DOING
9 --echo # ALTER TABLE...ALGORITHM=COPY
10 --echo #
11
12 CREATE TABLE t(a SERIAL, b INT, c INT, d INT) ENGINE=InnoDB;
13 CREATE TABLE t1(a INT, b TEXT, c TEXT,
14 FULLTEXT(b), FULLTEXT(c(3)), FULLTEXT(b,c)) ENGINE=InnoDB;
15
16 let $c = 999;
17 BEGIN;
18 --disable_query_log
19 while ($c) {
20 INSERT INTO t() VALUES();
21 dec $c;
22 }
23 --enable_query_log
24 COMMIT;
25
26 SELECT COUNT(*) FROM t;
27 # try to make the to-be-created secondary index keys randomly distributed
28 UPDATE t SET b=a%7, c=a%11, d=a%13;
29
30 INSERT INTO t1 VALUES(1, 'This is a first b column', 'This is a first c column');
31 INSERT INTO t1 VALUES(2, 'This is a second b column', 'This is a second c column');
32 INSERT INTO t1(a) VALUES(3);
33 INSERT INTO t1 VALUES(4, 'This is a third b column', 'This is a third c column');
34 DELETE FROM t1 WHERE a = 2;
35 SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first');
36 SELECT * FROM t1 WHERE MATCH(c) AGAINST ('first');
37 SELECT * FROM t1 WHERE MATCH(b,c) AGAINST ('column');
38 SHOW CREATE TABLE t1;
39 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
40
41 # kill right after the last write_row(), before the first commit of ALTER TABLE
42 connect (hang,localhost,root);
43
44 SET DEBUG_SYNC='alter_table_copy_trans_commit SIGNAL hung WAIT_FOR ever';
45 send
46 # create 32 secondary indexes
47 ALTER TABLE t ADD INDEX(b,c,d,a),ADD INDEX(b,c,a,d),ADD INDEX(b,a,c,d),ADD INDEX(b,a,d,c),
48 ADD INDEX(b,d,a,c),ADD INDEX(b,d,c,a),ADD INDEX(a,b,c,d),ADD INDEX(a,b,d,c),
49 ADD INDEX(a,c,b,d),ADD INDEX(a,c,d,b),ADD INDEX(a,d,b,c),ADD INDEX(a,d,c,b),
50 ADD INDEX(c,a,b,d),ADD INDEX(c,a,d,b),ADD INDEX(c,b,a,d),ADD INDEX(c,b,d,a),
51 ADD INDEX(c,d,a,b),ADD INDEX(c,d,b,a),ADD INDEX(d,a,b,c),ADD INDEX(d,a,c,b),
52 ADD INDEX(d,b,a,c),ADD INDEX(d,b,c,a),ADD INDEX(d,c,a,b),ADD INDEX(d,c,b,a),
53 ADD INDEX(a,b,c), ADD INDEX(a,c,b), ADD INDEX(a,c,d), ADD INDEX(a,d,c),
54 ADD INDEX(a,b,d), ADD INDEX(a,d,b), ADD INDEX(b,c,d), ADD INDEX(b,d,c),
55 ALGORITHM=COPY;
56
57 connection default;
58 SET DEBUG_SYNC='now WAIT_FOR hung';
59 let $shutdown_timeout=0;
60 --let $restart_parameters= --innodb-force-recovery=3
61 --source include/restart_mysqld.inc
62 disconnect hang;
63 let $shutdown_timeout=;
64 let $datadir=`select @@datadir`;
65 --replace_regex /FTS_[0-9a-f]*_[0-9a-f]*/FTS/
66 --list_files $datadir/test
67 SHOW CREATE TABLE t;
68 SELECT COUNT(*) FROM t;
69 CHECK TABLE t;
70 SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first');
71 SELECT * FROM t1 WHERE MATCH(c) AGAINST ('first');
72 SELECT * FROM t1 WHERE MATCH(b,c) AGAINST ('column');
73 SHOW CREATE TABLE t1;
74 CHECK TABLE t1;
75
76 --let $restart_parameters= --innodb-read-only
77 --source include/restart_mysqld.inc
78 --replace_regex /FTS_[0-9a-f]*_[0-9a-f]*/FTS/
79
80 --list_files $datadir/test
81 SHOW CREATE TABLE t;
82 SELECT COUNT(*) FROM t;
83 CHECK TABLE t;
84 SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first');
85 SELECT * FROM t1 WHERE MATCH(c) AGAINST ('first');
86 SELECT * FROM t1 WHERE MATCH(b,c) AGAINST ('column');
87 SHOW CREATE TABLE t1;
88 CHECK TABLE t1;
89
90 SET GLOBAL innodb_doublewrite=ON;
91 SELECT @@GLOBAL.innodb_doublewrite "OFF expected";
92 SET GLOBAL innodb_buf_flush_list_now=ON;
93
94 --let $restart_parameters=
95 --source include/restart_mysqld.inc
96 --replace_regex /FTS_[0-9a-f]*_[0-9a-f]*/FTS/
97 --list_files $datadir/test
98 DROP TABLE t1,t;