60 lines
1.8 KiB
Plaintext
60 lines
1.8 KiB
Plaintext
# ==== Purpose ====
|
|
#
|
|
# Verify that mysqlbinlog is able to print JSON columns for row
|
|
# events correctly (NULL if the value is NULL, blob format otherwise).
|
|
#
|
|
# ==== Implementation ====
|
|
#
|
|
# Generate INSERT/UPDATE/DELETE with NULL and non-NULL values in both
|
|
# pre- and post-image. Then run mysqlbinlog to show the result.
|
|
|
|
--echo #
|
|
--echo # Bug#21276751 JSON+MYSQLBINLOG: JSON DATA NOT PRINTING PROPERLY
|
|
--echo # WHEN USING MYSQLBINLOG UTILITY
|
|
--echo #
|
|
|
|
--source include/have_binlog_format_row.inc
|
|
--source include/master-slave.inc
|
|
|
|
connection master;
|
|
CREATE TABLE tab1 (json_col1 JSON);
|
|
INSERT INTO tab1 (json_col1) VALUES ('{"key": "value", "key2": [1, 2, 3]}');
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
UPDATE tab1 SET json_col1 = JSON_SET(json_col1, '$.key3', 'abc');
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
UPDATE tab1 SET json_col1 = NULL;
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
UPDATE tab1 SET json_col1 = '[ 1, { "k" : "v" } ]' WHERE json_col1 IS NULL;
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
INSERT INTO tab1 VALUES (NULL);
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
DELETE FROM tab1;
|
|
SELECT json_col1 FROM tab1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
SELECT json_col1 FROM tab1;
|
|
connection master;
|
|
DROP TABLE tab1;
|
|
|
|
FLUSH LOGS;
|
|
|
|
--let $MYSQLD_DATADIR= `select @@datadir`
|
|
--let $mysqlbinlog_parameters= --base64-output=decode-rows --verbose $MYSQLD_DATADIR/master-bin.000001
|
|
--source include/mysqlbinlog.inc
|
|
|
|
--source include/rpl_end.inc
|