Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_binlog_json.result

raw
1 #
2 # Bug#21276751 JSON+MYSQLBINLOG: JSON DATA NOT PRINTING PROPERLY
3 # WHEN USING MYSQLBINLOG UTILITY
4 #
5 include/master-slave.inc
6 Warnings:
7 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
8 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
9 [connection master]
10 CREATE TABLE tab1 (json_col1 JSON);
11 INSERT INTO tab1 (json_col1) VALUES ('{"key": "value", "key2": [1, 2, 3]}');
12 SELECT json_col1 FROM tab1;
13 json_col1
14 {"key": "value", "key2": [1, 2, 3]}
15 include/sync_slave_sql_with_master.inc
16 SELECT json_col1 FROM tab1;
17 json_col1
18 {"key": "value", "key2": [1, 2, 3]}
19 UPDATE tab1 SET json_col1 = JSON_SET(json_col1, '$.key3', 'abc');
20 SELECT json_col1 FROM tab1;
21 json_col1
22 {"key": "value", "key2": [1, 2, 3], "key3": "abc"}
23 include/sync_slave_sql_with_master.inc
24 SELECT json_col1 FROM tab1;
25 json_col1
26 {"key": "value", "key2": [1, 2, 3], "key3": "abc"}
27 UPDATE tab1 SET json_col1 = NULL;
28 SELECT json_col1 FROM tab1;
29 json_col1
30 NULL
31 include/sync_slave_sql_with_master.inc
32 SELECT json_col1 FROM tab1;
33 json_col1
34 NULL
35 UPDATE tab1 SET json_col1 = '[ 1, { "k" : "v" } ]' WHERE json_col1 IS NULL;
36 SELECT json_col1 FROM tab1;
37 json_col1
38 [1, {"k": "v"}]
39 include/sync_slave_sql_with_master.inc
40 SELECT json_col1 FROM tab1;
41 json_col1
42 [1, {"k": "v"}]
43 INSERT INTO tab1 VALUES (NULL);
44 SELECT json_col1 FROM tab1;
45 json_col1
46 [1, {"k": "v"}]
47 NULL
48 include/sync_slave_sql_with_master.inc
49 SELECT json_col1 FROM tab1;
50 json_col1
51 [1, {"k": "v"}]
52 NULL
53 DELETE FROM tab1;
54 SELECT json_col1 FROM tab1;
55 json_col1
56 include/sync_slave_sql_with_master.inc
57 SELECT json_col1 FROM tab1;
58 json_col1
59 DROP TABLE tab1;
60 FLUSH LOGS;
61 include/mysqlbinlog.inc
62 # The proper term is pseudo_replica_mode, but we use this compatibility alias
63 # to make the statement usable on server versions 8.0.24 and older.
64 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
65 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
66 DELIMITER /*!*/;
67 # at #
68 # # server id # end_log_pos # CRC32 # Start: binlog v #, server v # created # at startup
69 ROLLBACK/*!*/;
70 # at #
71 # # server id # end_log_pos # CRC32 # Previous-GTIDs
72 # [empty]
73 # at #
74 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
75 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
76 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
77 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
78 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
79 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
80 SET @@SESSION.GTID_NEXT= '#'/*!*/;
81 # at #
82 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
83 use `test`/*!*/;
84 SET TIMESTAMP=#/*!*/;
85 SET @@session.pseudo_thread_id=#/*!*/;
86 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
87 SET @@session.sql_mode=1168113696/*!*/;
88 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
89 /*!\C utf8mb4 *//*!*/;
90 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
91 SET @@session.lc_time_names=0/*!*/;
92 SET @@session.collation_database=DEFAULT/*!*/;
93 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
94 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
95 CREATE TABLE tab1 (json_col1 JSON)
96 /*!*/;
97 # at #
98 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
99 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
100 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
101 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
102 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
103 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
104 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
105 SET @@SESSION.GTID_NEXT= '#'/*!*/;
106 # at #
107 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
108 SET TIMESTAMP=#/*!*/;
109 BEGIN
110 /*!*/;
111 # at #
112 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
113 # has_generated_invisible_primary_key=0
114 # at #
115 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
116 ### INSERT INTO `test`.`tab1`
117 ### SET
118 ### @1='{"key": "value", "key2": [1, 2, 3]}'
119 # at #
120 # # server id # end_log_pos # CRC32 # Xid = #
121 COMMIT/*!*/;
122 # at #
123 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
124 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
125 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
126 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
127 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
128 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
129 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
130 SET @@SESSION.GTID_NEXT= '#'/*!*/;
131 # at #
132 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
133 SET TIMESTAMP=#/*!*/;
134 BEGIN
135 /*!*/;
136 # at #
137 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
138 # has_generated_invisible_primary_key=0
139 # at #
140 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
141 ### UPDATE `test`.`tab1`
142 ### WHERE
143 ### @1='{"key": "value", "key2": [1, 2, 3]}'
144 ### SET
145 ### @1='{"key": "value", "key2": [1, 2, 3], "key3": "abc"}'
146 # at #
147 # # server id # end_log_pos # CRC32 # Xid = #
148 COMMIT/*!*/;
149 # at #
150 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
151 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
152 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
153 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
154 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
155 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
156 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
157 SET @@SESSION.GTID_NEXT= '#'/*!*/;
158 # at #
159 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
160 SET TIMESTAMP=#/*!*/;
161 BEGIN
162 /*!*/;
163 # at #
164 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
165 # has_generated_invisible_primary_key=0
166 # at #
167 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
168 ### UPDATE `test`.`tab1`
169 ### WHERE
170 ### @1='{"key": "value", "key2": [1, 2, 3], "key3": "abc"}'
171 ### SET
172 ### @1=NULL
173 # at #
174 # # server id # end_log_pos # CRC32 # Xid = #
175 COMMIT/*!*/;
176 # at #
177 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
178 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
179 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
180 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
181 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
182 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
183 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
184 SET @@SESSION.GTID_NEXT= '#'/*!*/;
185 # at #
186 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
187 SET TIMESTAMP=#/*!*/;
188 BEGIN
189 /*!*/;
190 # at #
191 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
192 # has_generated_invisible_primary_key=0
193 # at #
194 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
195 ### UPDATE `test`.`tab1`
196 ### WHERE
197 ### @1=NULL
198 ### SET
199 ### @1='[1, {"k": "v"}]'
200 # at #
201 # # server id # end_log_pos # CRC32 # Xid = #
202 COMMIT/*!*/;
203 # at #
204 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
205 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
206 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
207 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
208 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
209 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
210 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
211 SET @@SESSION.GTID_NEXT= '#'/*!*/;
212 # at #
213 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
214 SET TIMESTAMP=#/*!*/;
215 BEGIN
216 /*!*/;
217 # at #
218 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
219 # has_generated_invisible_primary_key=0
220 # at #
221 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
222 ### INSERT INTO `test`.`tab1`
223 ### SET
224 ### @1=NULL
225 # at #
226 # # server id # end_log_pos # CRC32 # Xid = #
227 COMMIT/*!*/;
228 # at #
229 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
230 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
231 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
232 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
233 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
234 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
235 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
236 SET @@SESSION.GTID_NEXT= '#'/*!*/;
237 # at #
238 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
239 SET TIMESTAMP=#/*!*/;
240 BEGIN
241 /*!*/;
242 # at #
243 # # server id # end_log_pos # CRC32 # Table_map: `test`.`tab1` mapped to number #
244 # has_generated_invisible_primary_key=0
245 # at #
246 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
247 ### DELETE FROM `test`.`tab1`
248 ### WHERE
249 ### @1='[1, {"k": "v"}]'
250 ### DELETE FROM `test`.`tab1`
251 ### WHERE
252 ### @1=NULL
253 # at #
254 # # server id # end_log_pos # CRC32 # Xid = #
255 COMMIT/*!*/;
256 # at #
257 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
258 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
259 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
260 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
261 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
262 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
263 SET @@SESSION.GTID_NEXT= '#'/*!*/;
264 # at #
265 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
266 SET TIMESTAMP=#/*!*/;
267 DROP TABLE `tab1` /* generated by server */
268 /*!*/;
269 # at #
270 # # server id # end_log_pos # CRC32 # Rotate to master-bin.000002 pos: 4
271 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
272 DELIMITER ;
273 # End of log file
274 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
275 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
276 include/rpl_end.inc