Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3 --source include/have_debug.inc
4 --source include/have_debug_sync.inc
5
6 CREATE TABLE t1 (a INT, b VARCHAR(10)) ENGINE=InnoDB
7 STATS_PERSISTENT=1 STATS_AUTO_RECALC=0
8 PARTITION BY RANGE(a)
9 (PARTITION pa VALUES LESS THAN (3),
10 PARTITION pb VALUES LESS THAN (5));
11
12 INSERT INTO t1 VALUES(2,'two'),(2,'two'),(4,'four');
13
14 connect ddl,localhost,root,,test;
15 SET DEBUG_SYNC = 'inplace_after_index_build SIGNAL go WAIT_FOR done';
16 send ALTER TABLE t1 ADD UNIQUE KEY (a,b(3));
17
18 connection default;
19 SET DEBUG_SYNC = 'now WAIT_FOR go';
20 BEGIN;
21 SELECT * FROM t1 FOR UPDATE;
22 SET DEBUG_SYNC = 'now SIGNAL done';
23
24 connection ddl;
25 --error ER_DUP_ENTRY
26 reap;
27
28 connection default;
29 DELETE FROM t1;
30
31 SET DEBUG_SYNC = 'RESET';
32
33 CHECK TABLE t1;
34
35 CREATE TABLE t(a INT, b VARCHAR(10)) ENGINE=InnoDB
36 STATS_PERSISTENT=1 STATS_AUTO_RECALC=1;
37 RENAME TABLE t TO u;
38 DELETE FROM mysql.innodb_table_stats WHERE table_name='u';
39 DELETE FROM mysql.innodb_index_stats WHERE table_name='u';
40
41 send SET STATEMENT debug_dbug='+d,dict_stats_save_exit_notify_and_wait' FOR
42 SELECT * FROM u;
43
44 connection ddl;
45 SET DEBUG_SYNC='open_tables_after_open_and_process_table
46 WAIT_FOR dict_stats_save_finished';
47 send ALTER TABLE t1 EXCHANGE PARTITION pb WITH TABLE u;
48
49 connect sync,localhost,root;
50 let $wait_condition=
51 select count(*) = 1 from information_schema.processlist
52 where state = 'debug sync point: now'
53 and info like 'SET STATEMENT debug_dbug%SELECT * FROM u';
54 --source include/wait_condition.inc
55 let $wait_condition=
56 select count(*) = 1 from information_schema.processlist
57 where state = 'Waiting for table metadata lock'
58 and info like 'ALTER TABLE t1 EXCHANGE PARTITION pb WITH TABLE u';
59 --source include/wait_condition.inc
60 SET DEBUG_SYNC='now SIGNAL dict_stats_save_unblock';
61 disconnect sync;
62
63 connection default;
64 reap;
65 connection ddl;
66 reap;
67 disconnect ddl;
68 connection default;
69 SELECT * FROM u;
70 SET DEBUG_SYNC = 'RESET';
71
72 DROP TABLE t1,u;