Debian Codegraph @

mysql-test/suite/innodb/r/innodb-copy-alter-debug.result

raw
1 #
2 # Bug #17479594 AVOID INTERMEDIATE COMMIT WHILE DOING
3 # ALTER TABLE...ALGORITHM=COPY
4 #
5 CREATE TABLE t(a SERIAL, b INT, c INT, d INT) ENGINE=InnoDB;
6 INSERT INTO t(a) VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0);
7 INSERT INTO t(a) SELECT a+16 FROM t;
8 INSERT INTO t(a) SELECT a+33 FROM t;
9 INSERT INTO t(a) VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0);
10 INSERT INTO t(a) SELECT a+81 FROM t;
11 INSERT INTO t(a) SELECT a+162 FROM t;
12 INSERT INTO t(a) SELECT a+324 FROM t;
13 INSERT INTO t(a) SELECT a+648 FROM t;
14 INSERT INTO t(a) SELECT a+1296 FROM t;
15 INSERT INTO t(a) SELECT a+2592 FROM t;
16 INSERT INTO t(a) SELECT a+5186 FROM t;
17 INSERT INTO t(a) VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0);
18 select count(*) from t;
19 count(*)
20 9999
21 UPDATE t SET b=a%7, c=a%11, d=a%13;
22 SET DEBUG='+d,crash_copy_before_commit';
23 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),
24 ADD INDEX(b,d,a,c),ADD INDEX(b,d,c,a),ADD INDEX(a,b,c,d),ADD INDEX(a,b,d,c),
25 ADD INDEX(a,c,b,d),ADD INDEX(a,c,d,b),ADD INDEX(a,d,b,c),ADD INDEX(a,d,c,b),
26 ADD INDEX(c,a,b,d),ADD INDEX(c,a,d,b),ADD INDEX(c,b,a,d),ADD INDEX(c,b,d,a),
27 ADD INDEX(c,d,a,b),ADD INDEX(c,d,b,a),ADD INDEX(d,a,b,c),ADD INDEX(d,a,c,b),
28 ADD INDEX(d,b,a,c),ADD INDEX(d,b,c,a),ADD INDEX(d,c,a,b),ADD INDEX(d,c,b,a),
29 ADD INDEX(a,b,c), ADD INDEX(a,c,b), ADD INDEX(a,c,d), ADD INDEX(a,d,c),
30 ADD INDEX(a,b,d), ADD INDEX(a,d,b), ADD INDEX(b,c,d), ADD INDEX(b,d,c),
31 ALGORITHM=COPY;
32 ERROR HY000: Lost connection to MySQL server during query
33 # restart
34 SHOW CREATE TABLE t;
35 Table Create Table
36 t CREATE TABLE `t` (
37 `a` bigint unsigned NOT NULL AUTO_INCREMENT,
38 `b` int DEFAULT NULL,
39 `c` int DEFAULT NULL,
40 `d` int DEFAULT NULL,
41 UNIQUE KEY `a` (`a`)
42 ) ENGINE=InnoDB AUTO_INCREMENT=10384 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 CHECK TABLE t;
44 Table Op Msg_type Msg_text
45 test.t check status OK
46 DROP TABLE t;
47 CREATE TABLE t1(a INT, b TEXT, c TEXT,
48 FULLTEXT(b), FULLTEXT(c(3)), FULLTEXT(b,c))ENGINE=InnoDB;
49 INSERT INTO t1 VALUES(1, "This is a first b column", "This is a first c column");
50 INSERT INTO t1 VALUES(2, "This is a second b column", "This is a second c column");
51 INSERT INTO t1(a) VALUES(3);
52 INSERT INTO t1 VALUES(4, "This is a third b column", "This is a third c column");
53 DELETE FROM t1 WHERE a = 2;
54 SELECT * FROM t1 WHERE MATCH(b) AGAINST ("first");
55 a b c
56 1 This is a first b column This is a first c column
57 SELECT * FROM t1 WHERE MATCH(c) AGAINST ("first");
58 a b c
59 1 This is a first b column This is a first c column
60 SELECT * FROM t1 WHERE MATCH(b,c) AGAINST ("column");
61 a b c
62 1 This is a first b column This is a first c column
63 4 This is a third b column This is a third c column
64 SHOW CREATE TABLE t1;
65 Table Create Table
66 t1 CREATE TABLE `t1` (
67 `a` int DEFAULT NULL,
68 `b` text,
69 `c` text,
70 FULLTEXT KEY `b` (`b`),
71 FULLTEXT KEY `c` (`c`),
72 FULLTEXT KEY `b_2` (`b`,`c`)
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
74 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
75 SELECT * FROM t1 WHERE MATCH(b) AGAINST ("first");
76 a b c
77 1 This is a first b column This is a first c column
78 SELECT * FROM t1 WHERE MATCH(c) AGAINST ("first");
79 a b c
80 1 This is a first b column This is a first c column
81 SELECT * FROM t1 WHERE MATCH(b,c) AGAINST ("column");
82 a b c
83 1 This is a first b column This is a first c column
84 4 This is a third b column This is a third c column
85 SHOW CREATE TABLE t1;
86 Table Create Table
87 t1 CREATE TABLE `t1` (
88 `a` int DEFAULT NULL,
89 `b` text,
90 `c` text,
91 FULLTEXT KEY `b` (`b`),
92 FULLTEXT KEY `c` (`c`),
93 FULLTEXT KEY `b_2` (`b`,`c`)
94 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 DROP TABLE t1;