Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_json_null_for_not_null.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection master]
6 #
7 # Bug#26787468: REPLICATION DOES NOT HANDLE NULL INSERTED
8 # IN JSON NOT NULL COLUMN CORRECTLY
9 #
10 CREATE TABLE t (i INT, j JSON NOT NULL);
11 SET SESSION binlog_row_value_options = 'PARTIAL_JSON';
12 Warnings:
13 Warning 3647 When binlog_row_image=FULL, the option binlog_row_value_options=PARTIAL_JSON will be used only for the after-image. Full values will be written in the before-image, so the saving in disk space due to binlog_row_value_options is limited to less than 50%.
14 include/save_binlog_position.inc
15 INSERT IGNORE INTO t VALUES (1, NULL);
16 Warnings:
17 Warning 1048 Column 'j' cannot be null
18 SELECT * FROM t;
19 i j
20 1 null
21 # mysqlbinlog used to show 'Invalid JSON' for the second column.
22 include/mysqlbinlog.inc
23 ### INSERT INTO `test`.`t`
24 ### SET
25 ### @1=1
26 ### @2='null'
27 include/sync_slave_sql_with_master.inc
28 SELECT * FROM t;
29 i j
30 1 null
31 DROP TABLE t;
32 include/rpl_end.inc