Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT);
2 RESET MASTER;
3 SET TIMESTAMP= UNIX_TIMESTAMP("2031-01-01 12:00:00");
4 INSERT INTO t1 VALUES(1);
5 SET TIMESTAMP= UNIX_TIMESTAMP("2032-01-01 12:00:00");
6 INSERT INTO t1 VALUES(2);
7 SET TIMESTAMP= UNIX_TIMESTAMP("2033-01-01 12:00:00");
8 INSERT INTO t1 VALUES(3);
9 FLUSH LOGS;
10 SET TIMESTAMP= UNIX_TIMESTAMP("2034-01-01 12:00:00");
11 INSERT INTO t1 VALUES(4);
12 SET TIMESTAMP= UNIX_TIMESTAMP("2035-01-01 12:00:00");
13 INSERT INTO t1 VALUES(5);
14 FLUSH LOGS;
15
16 ==== Remote with to-last-log stop-never connection-server-id=0 ====
17
18 ---- to-last-log stop-never connection-server-id ----
19 include/mysqlbinlog.inc
20 # The proper term is pseudo_replica_mode, but we use this compatibility alias
21 # to make the statement usable on server versions 8.0.24 and older.
22 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
23 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
24 DELIMITER /*!*/;
25 ROLLBACK/*!*/;
26 # [empty]
27 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
28 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
29 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
30 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
31 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
32 SET @@SESSION.GTID_NEXT= '#'/*!*/;
33 SET TIMESTAMP=#/*!*/;
34 SET @@session.pseudo_thread_id=#/*!*/;
35 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
36 SET @@session.sql_mode=1168113696/*!*/;
37 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
38 /*!\C utf8mb4 *//*!*/;
39 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
40 SET @@session.lc_time_names=0/*!*/;
41 SET @@session.collation_database=DEFAULT/*!*/;
42 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
43 BEGIN
44 /*!*/;
45 use `test`/*!*/;
46 SET TIMESTAMP=#/*!*/;
47 INSERT INTO t1 VALUES(1)
48 /*!*/;
49 COMMIT/*!*/;
50 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
51 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
52 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
53 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
54 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
55 SET @@SESSION.GTID_NEXT= '#'/*!*/;
56 SET TIMESTAMP=#/*!*/;
57 BEGIN
58 /*!*/;
59 SET TIMESTAMP=#/*!*/;
60 INSERT INTO t1 VALUES(2)
61 /*!*/;
62 COMMIT/*!*/;
63 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
64 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
65 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
66 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
67 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
68 SET @@SESSION.GTID_NEXT= '#'/*!*/;
69 SET TIMESTAMP=#/*!*/;
70 BEGIN
71 /*!*/;
72 SET TIMESTAMP=#/*!*/;
73 INSERT INTO t1 VALUES(3)
74 /*!*/;
75 COMMIT/*!*/;
76 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
77 # [empty]
78 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
79 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
80 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
81 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
82 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
83 SET @@SESSION.GTID_NEXT= '#'/*!*/;
84 SET TIMESTAMP=#/*!*/;
85 BEGIN
86 /*!*/;
87 SET TIMESTAMP=#/*!*/;
88 INSERT INTO t1 VALUES(4)
89 /*!*/;
90 COMMIT/*!*/;
91 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
92 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
93 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
94 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
95 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
96 SET @@SESSION.GTID_NEXT= '#'/*!*/;
97 SET TIMESTAMP=#/*!*/;
98 BEGIN
99 /*!*/;
100 SET TIMESTAMP=#/*!*/;
101 INSERT INTO t1 VALUES(5)
102 /*!*/;
103 COMMIT/*!*/;
104 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
105 # [empty]
106 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
107 DELIMITER ;
108 # End of log file
109 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
110 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
111
112 ==== Remote with connection-server-id= (value other than 0) ====
113
114 ---- to-last-log connection-server-id ----
115 include/mysqlbinlog.inc
116 # The proper term is pseudo_replica_mode, but we use this compatibility alias
117 # to make the statement usable on server versions 8.0.24 and older.
118 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
119 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
120 DELIMITER /*!*/;
121 ROLLBACK/*!*/;
122 # [empty]
123 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
124 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
125 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
126 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
127 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
128 SET @@SESSION.GTID_NEXT= '#'/*!*/;
129 SET TIMESTAMP=#/*!*/;
130 SET @@session.pseudo_thread_id=#/*!*/;
131 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
132 SET @@session.sql_mode=1168113696/*!*/;
133 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
134 /*!\C utf8mb4 *//*!*/;
135 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
136 SET @@session.lc_time_names=0/*!*/;
137 SET @@session.collation_database=DEFAULT/*!*/;
138 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
139 BEGIN
140 /*!*/;
141 use `test`/*!*/;
142 SET TIMESTAMP=#/*!*/;
143 INSERT INTO t1 VALUES(1)
144 /*!*/;
145 COMMIT/*!*/;
146 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
147 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
148 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
149 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
150 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
151 SET @@SESSION.GTID_NEXT= '#'/*!*/;
152 SET TIMESTAMP=#/*!*/;
153 BEGIN
154 /*!*/;
155 SET TIMESTAMP=#/*!*/;
156 INSERT INTO t1 VALUES(2)
157 /*!*/;
158 COMMIT/*!*/;
159 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
160 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
161 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
162 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
163 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
164 SET @@SESSION.GTID_NEXT= '#'/*!*/;
165 SET TIMESTAMP=#/*!*/;
166 BEGIN
167 /*!*/;
168 SET TIMESTAMP=#/*!*/;
169 INSERT INTO t1 VALUES(3)
170 /*!*/;
171 COMMIT/*!*/;
172 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
173 # [empty]
174 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
175 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
176 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
177 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
178 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
179 SET @@SESSION.GTID_NEXT= '#'/*!*/;
180 SET TIMESTAMP=#/*!*/;
181 BEGIN
182 /*!*/;
183 SET TIMESTAMP=#/*!*/;
184 INSERT INTO t1 VALUES(4)
185 /*!*/;
186 COMMIT/*!*/;
187 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
188 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
189 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
190 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
191 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
192 SET @@SESSION.GTID_NEXT= '#'/*!*/;
193 SET TIMESTAMP=#/*!*/;
194 BEGIN
195 /*!*/;
196 SET TIMESTAMP=#/*!*/;
197 INSERT INTO t1 VALUES(5)
198 /*!*/;
199 COMMIT/*!*/;
200 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
201 # [empty]
202 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
203 DELIMITER ;
204 # End of log file
205 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
206 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
207
208 ==== clean up ====
209 DROP TABLE t1;