Debian Codegraph @

mysql-test/suite/innodb/r/alter_partitioned_debug.result

raw
1 CREATE TABLE t1 (a INT, b VARCHAR(10)) ENGINE=InnoDB
2 STATS_PERSISTENT=1 STATS_AUTO_RECALC=0
3 PARTITION BY RANGE(a)
4 (PARTITION pa VALUES LESS THAN (3),
5 PARTITION pb VALUES LESS THAN (5));
6 INSERT INTO t1 VALUES(2,'two'),(2,'two'),(4,'four');
7 connect ddl,localhost,root,,test;
8 SET DEBUG_SYNC = 'inplace_after_index_build SIGNAL go WAIT_FOR done';
9 ALTER TABLE t1 ADD UNIQUE KEY (a,b(3));
10 connection default;
11 SET DEBUG_SYNC = 'now WAIT_FOR go';
12 BEGIN;
13 SELECT * FROM t1 FOR UPDATE;
14 a b
15 2 two
16 2 two
17 4 four
18 SET DEBUG_SYNC = 'now SIGNAL done';
19 connection ddl;
20 ERROR 23000: Duplicate entry '2-two' for key 'a'
21 connection default;
22 DELETE FROM t1;
23 SET DEBUG_SYNC = 'RESET';
24 CHECK TABLE t1;
25 Table Op Msg_type Msg_text
26 test.t1 check status OK
27 CREATE TABLE t(a INT, b VARCHAR(10)) ENGINE=InnoDB
28 STATS_PERSISTENT=1 STATS_AUTO_RECALC=1;
29 RENAME TABLE t TO u;
30 DELETE FROM mysql.innodb_table_stats WHERE table_name='u';
31 DELETE FROM mysql.innodb_index_stats WHERE table_name='u';
32 SET STATEMENT debug_dbug='+d,dict_stats_save_exit_notify_and_wait' FOR
33 SELECT * FROM u;
34 connection ddl;
35 SET DEBUG_SYNC='open_tables_after_open_and_process_table
36 WAIT_FOR dict_stats_save_finished';
37 ALTER TABLE t1 EXCHANGE PARTITION pb WITH TABLE u;
38 connect sync,localhost,root;
39 SET DEBUG_SYNC='now SIGNAL dict_stats_save_unblock';
40 disconnect sync;
41 connection default;
42 a b
43 connection ddl;
44 disconnect ddl;
45 connection default;
46 SELECT * FROM u;
47 a b
48 SET DEBUG_SYNC = 'RESET';
49 DROP TABLE t1,u;