| 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 */ |