Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_nogtid_mix_response_packet.result

raw
1 SET SESSION SESSION_TRACK_GTIDS=ALL_GTIDS;
2 RESET MASTER;
3 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
4 BEGIN;
5 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
6 -- T_______
7
8 INSERT INTO t1 VALUES (1);
9 COMMIT;
10 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
11 -- ________
12
13 BEGIN;
14 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
15 -- T_______
16
17 INSERT INTO t1 VALUES (2);
18 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
19 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
20 -- ________
21
22 INSERT INTO t2 VALUES (1);
23 SELECT * FROM t1;
24 c1
25 1
26 2
27 BEGIN;
28 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
29 -- T_______
30
31 INSERT INTO t1 VALUES (2);
32 SAVEPOINT s;
33 INSERT INTO t1 VALUES (3);
34 ROLLBACK TO SAVEPOINT s;
35 ROLLBACK;
36 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
37 -- ________
38
39 DROP TABLE t1, t2;
40 SET SESSION SESSION_TRACK_GTIDS=OWN_GTID;
41 RESET MASTER;
42 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
43 BEGIN;
44 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
45 -- T_______
46
47 INSERT INTO t1 VALUES (1);
48 COMMIT;
49 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
50 -- ________
51
52 BEGIN;
53 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
54 -- T_______
55
56 INSERT INTO t1 VALUES (2);
57 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
58 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
59 -- ________
60
61 INSERT INTO t2 VALUES (1);
62 SELECT * FROM t1;
63 c1
64 1
65 2
66 BEGIN;
67 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
68 -- T_______
69
70 INSERT INTO t1 VALUES (2);
71 SAVEPOINT s;
72 INSERT INTO t1 VALUES (3);
73 ROLLBACK TO SAVEPOINT s;
74 ROLLBACK;
75 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
76 -- ________
77
78 DROP TABLE t1, t2;
79 SET SESSION SESSION_TRACK_GTIDS=OFF;
80 RESET MASTER;
81 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
82 BEGIN;
83 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
84 -- T_______
85
86 INSERT INTO t1 VALUES (1);
87 COMMIT;
88 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
89 -- ________
90
91 BEGIN;
92 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
93 -- T_______
94
95 INSERT INTO t1 VALUES (2);
96 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
97 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
98 -- ________
99
100 INSERT INTO t2 VALUES (1);
101 SELECT * FROM t1;
102 c1
103 1
104 2
105 BEGIN;
106 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
107 -- T_______
108
109 INSERT INTO t1 VALUES (2);
110 SAVEPOINT s;
111 INSERT INTO t1 VALUES (3);
112 ROLLBACK TO SAVEPOINT s;
113 ROLLBACK;
114 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
115 -- ________
116
117 DROP TABLE t1, t2;