Debian Codegraph @

mysql-test/suite/innodb/r/innodb-alter-tempfile.result

raw
1 call mtr.add_suppression("Cannot find index f2 in InnoDB index dictionary.");
2 call mtr.add_suppression("InnoDB indexes are inconsistent with what defined in .frm for table");
3 call mtr.add_suppression("Table test/t1 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in");
4 call mtr.add_suppression("InnoDB could not find key no 1 with name f2 from dict cache for table");
5 #
6 # Bug #18734396 INNODB IN-PLACE ALTER FAILURES BLOCK FUTURE ALTERS
7 #
8 # Temporary tablename will be unique. This makes sure that future
9 # in-place ALTERs of the same table will not be blocked due to
10 # temporary tablename.
11 CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=innodb;
12 SET debug_dbug='+d,innodb_alter_commit_crash_before_commit';
13 ALTER TABLE t1 ADD PRIMARY KEY (f2, f1);
14 ERROR HY000: Lost connection to server during query
15 # restart
16 show create table t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `f1` int(11) NOT NULL,
20 `f2` int(11) NOT NULL
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
22 # Consecutive Alter table does not create same temporary file name
23 ALTER TABLE t1 ADD PRIMARY KEY (f2, f1);
24 show create table t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `f1` int(11) NOT NULL,
28 `f2` int(11) NOT NULL,
29 PRIMARY KEY (`f2`,`f1`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
31 drop table t1;
32 #
33 # MDEV-22928 InnoDB fails to fetch index type
34 # when index mismatch
35 #
36 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
37 index(f1), index(f2))ENGINE=InnoDB;
38 INSERT INTO t1 VALUES(1, 1), (2, 2);
39 connect con1,localhost,root,,test;
40 SET DEBUG_SYNC="alter_table_inplace_after_commit SIGNAL default_signal WAIT_FOR default_done";
41 ALTER TABLE t1 DROP INDEX f2, ALGORITHM=INPLACE;
42 connection default;
43 set DEBUG_SYNC="now WAIT_FOR default_signal";
44 # restart
45 disconnect con1;
46 SHOW KEYS FROM t1;
47 DROP TABLE t1;
48 #
49 # MDEV-25503 InnoDB hangs on startup during recovery
50 #
51 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=1;
52 connect con1,localhost,root,,;
53 BEGIN;
54 DELETE FROM mysql.innodb_table_stats;
55 connect con2,localhost,root,,;
56 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL blocked WAIT_FOR ever';
57 ALTER TABLE t1 FORCE;
58 connection default;
59 SET DEBUG_SYNC='now WAIT_FOR blocked';
60 # restart
61 SELECT * FROM t1;
62 a
63 DROP TABLE t1;