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