Debian Codegraph @

mysql-test/suite/binlog_gtid/t/binlog_gtid_bgc_ticket_manager.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4 --let $option_name = binlog_order_commits
5 --let $option_value = 1
6 --source include/only_with_option.inc
7
8 CREATE TABLE t (
9 c1 INT NOT NULL PRIMARY KEY,
10 c2 INT
11 );
12
13 --let $save_binlog_position_in_sql = 1
14 --source include/save_binlog_position.inc
15
16 --let $gtid_uuid = 435aeb3e-cc91-11ec-a715-6ba04eb9487e
17 --let $auxiliary_connection = default
18
19 --connect(con1,localhost,root,,)
20 --let $statement_connection = con1
21 --let $timestamp = 1
22 --let $statement = SET gtid_next = "$gtid_uuid:1"; INSERT INTO t VALUES (1, 1)
23 --let $sync_point = before_assign_session_to_bgc_ticket
24 --source include/execute_to_conditional_timestamp_sync_point.inc
25
26 --connect(con2,localhost,root,,)
27 --let $statement_connection = con2
28 --let $timestamp = 2
29 --let $statement = SET gtid_next = "$gtid_uuid:2"; INSERT INTO t VALUES (2, 2)
30 --let $sync_point = before_wait_on_ticket
31 --source include/execute_to_conditional_timestamp_sync_point.inc
32
33 --connect(con3,localhost,root,,)
34 --let $statement_connection = con3
35 --let $timestamp = 3
36 --let $statement = SET gtid_next = "$gtid_uuid:3"; INSERT INTO t VALUES (3, 3)
37 --let $sync_point = before_wait_on_ticket
38 --source include/execute_to_conditional_timestamp_sync_point.inc
39
40 --connection default
41 --let $statement_connection = con1
42 --let $timestamp = 1
43 --let $sync_point = before_assign_session_to_bgc_ticket
44 --let $to_sync_point = inside_wait_on_ticket
45 --source include/execute_from_conditional_timestamp_sync_point.inc
46 --let $to_sync_point =
47
48 --let $statement_connection = con1
49 --let $timestamp = 1
50 --let $sync_point = inside_wait_on_ticket
51 --source include/execute_from_conditional_timestamp_sync_point.inc
52
53 --connection default
54 --let $statement_connection = con2
55 --let $timestamp = 2
56 --let $sync_point = before_wait_on_ticket
57 --source include/execute_from_conditional_timestamp_sync_point.inc
58
59 --connection default
60 --let $statement_connection = con3
61 --let $timestamp = 3
62 --let $sync_point = before_wait_on_ticket
63 --source include/execute_from_conditional_timestamp_sync_point.inc
64
65 --connection con1
66 --reap
67 --disconnect con1
68 --connection con2
69 --reap
70 --disconnect con2
71 --connection con3
72 --reap
73 --disconnect con3
74
75 --connection default
76 --let $wait_condition = SELECT COUNT(1) = 3 FROM t
77 --source include/wait_condition.inc
78
79 --let $events_for_1 = Gtid/.*GTID_NEXT= '$gtid_uuid:1' # !Begin # !Insert # !Commit
80 --let $events_for_2 = Gtid/.*GTID_NEXT= '$gtid_uuid:2' # !Begin # !Insert # !Commit
81 --let $events_for_3 = Gtid/.*GTID_NEXT= '$gtid_uuid:3' # !Begin # !Insert # !Commit
82
83 --let $event_sequence = $events_for_2 # $events_for_3 # $events_for_1
84 --source include/assert_binlog_events.inc
85
86 DROP TABLE t;
87 RESET MASTER;