Debian Codegraph @

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

raw
1 ==== Generate binlog ====
2 RESET MASTER;
3 CREATE TABLE t (i INT, j JSON);
4 SET @@SESSION.BINLOG_ROW_IMAGE = MINIMAL;
5 INSERT INTO t VALUES (1, '{"a" : 1}');
6 UPDATE t SET j = '1' WHERE i = 1;
7 DELETE FROM t;
8 DROP TABLE t;
9 ==== Check output from mysqlbinlog ====
10 include/save_binlog_position.inc
11 include/mysqlbinlog.inc
12 ### INSERT INTO `test`.`t`
13 ### SET
14 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
15 ### @2='{"a": 1}' /* JSON meta=4 nullable=1 is_null=0 */
16 ### UPDATE `test`.`t`
17 ### WHERE
18 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
19 ### @2='{"a": 1}' /* JSON meta=4 nullable=1 is_null=0 */
20 ### SET
21 ### @2='LONG_JSON
22 ### UPDATE `test`.`t`
23 ### WHERE
24 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
25 ### @2='LONG_JSON
26 ### SET
27 ### @2='1' /* JSON meta=4 nullable=1 is_null=0 */
28 ### DELETE FROM `test`.`t`
29 ### WHERE
30 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
31 ### @2='1' /* JSON meta=4 nullable=1 is_null=0 */