Debian Codegraph @

mysql-test/suite/binlog/r/binlog_unsafe_commit_db.result

raw
1 RESET MASTER;
2 CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 VARCHAR(200))
3 PARTITION BY HASH (c1) PARTITIONS 4;
4 INSERT INTO t1 VALUES(1, ""), (2, ""), (3, ""),(4, "");
5 #
6 # Verify INSERT after CREATE DATABASE logs correct last_committed
7 #
8 [connection admin_conn]
9 SET debug_sync = "waiting_in_the_middle_of_flush_stage SIGNAL admin_ready
10 WAIT_FOR admin_continue";
11 CREATE DATABASE d1 CHARACTER SET UTF8MB4;
12 [connection insert_conn]
13 SET debug_sync = "now WAIT_FOR admin_ready";
14 SET debug_sync = "bgc_after_enrolling_for_flush_stage SIGNAL insert_ready
15 WAIT_FOR insert_continue";
16 INSERT INTO t1(c2) VALUES("CREATE DATABASE d1 CHARACTER SET UTF8MB4");
17 [connection default]
18 SET debug_sync = "now WAIT_FOR insert_ready";
19 SET debug_sync = "now SIGNAL admin_continue,insert_continue";
20 [connection admin_conn]
21 [connection insert_conn]
22 SET debug_sync = "RESET";
23 include/include/assert_logical_timestamps.inc [3 4]
24 #
25 # Verify INSERT after ALTER DATABASE logs correct last_committed
26 #
27 [connection admin_conn]
28 SET debug_sync = "waiting_in_the_middle_of_flush_stage SIGNAL admin_ready
29 WAIT_FOR admin_continue";
30 ALTER DATABASE d1 DEFAULT CHARACTER SET = 'latin1';
31 [connection insert_conn]
32 SET debug_sync = "now WAIT_FOR admin_ready";
33 SET debug_sync = "bgc_after_enrolling_for_flush_stage SIGNAL insert_ready
34 WAIT_FOR insert_continue";
35 INSERT INTO t1(c2) VALUES("ALTER DATABASE d1 DEFAULT CHARACTER SET = 'latin1'");
36 [connection default]
37 SET debug_sync = "now WAIT_FOR insert_ready";
38 SET debug_sync = "now SIGNAL admin_continue,insert_continue";
39 [connection admin_conn]
40 [connection insert_conn]
41 SET debug_sync = "RESET";
42 include/include/assert_logical_timestamps.inc [5 6]
43 #
44 # Verify INSERT after DROP DATABASE logs correct last_committed
45 #
46 [connection admin_conn]
47 SET debug_sync = "waiting_in_the_middle_of_flush_stage SIGNAL admin_ready
48 WAIT_FOR admin_continue";
49 DROP DATABASE d1;
50 [connection insert_conn]
51 SET debug_sync = "now WAIT_FOR admin_ready";
52 SET debug_sync = "bgc_after_enrolling_for_flush_stage SIGNAL insert_ready
53 WAIT_FOR insert_continue";
54 INSERT INTO t1(c2) VALUES("DROP DATABASE d1");
55 [connection default]
56 SET debug_sync = "now WAIT_FOR insert_ready";
57 SET debug_sync = "now SIGNAL admin_continue,insert_continue";
58 [connection admin_conn]
59 [connection insert_conn]
60 SET debug_sync = "RESET";
61 include/include/assert_logical_timestamps.inc [7 8]
62 DROP TABLE t1;