mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-02-23 05:43:08 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/binlog/r/binlog_row_img.result
Alexander Barkov 36eba98817 MDEV-19123 Change default charset from latin1 to utf8mb4 
Changing the default server character set from latin1 to utf8mb4.
2024-07-11 10:21:07 +04:00

1367 lines
52 KiB
Text
Raw Permalink Blame History

ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
#
# FULL_NODUP mode works as expected
#
SET binlog_row_image = "FULL_NODUP";
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
c3 INT DEFAULT 1000, c4 TEXT);
CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
FLUSH BINARY LOGS;
#########################################################################
# binlog_row_image = FULL_NODUP
#########################################################################
INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
(2, "insert_to_t1", 2, repeat('a', 20)),
(3, "insert_to_t1", 3, repeat('a', 20));
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t1 WHERE c1 = 1;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
#Q> (2, "insert_to_t1", 2, repeat('a', 20)),
#Q> (3, "insert_to_t1", 3, repeat('a', 20))
### INSERT INTO `test`.`t1`
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1(c1) VALUES(4)
### INSERT INTO `test`.`t1`
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t1 WHERE c1 = 1
### DELETE FROM `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY LOGS;
# t2 has no primary key.
# It will binlog full before and after image for all modes if the
# table has no primary key. FULL_NODUP follows the behavior.
INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
(2, "insert_to_t2", 2, repeat('a', 20)),
(3, "insert_to_t2", 3, repeat('a', 20));
INSERT INTO t2(c1) VALUES(4);
UPDATE t2 SET c2 = "only_c2_changed";
UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t2 WHERE c1 > 2;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
#Q> (2, "insert_to_t2", 2, repeat('a', 20)),
#Q> (3, "insert_to_t2", 3, repeat('a', 20))
### INSERT INTO `test`.`t2`
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2(c1) VALUES(4)
### INSERT INTO `test`.`t2`
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 2
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
#
# MINIMAL mode works as expected
#
SET binlog_row_image = "MINIMAL";
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
c3 INT DEFAULT 1000, c4 TEXT);
CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
FLUSH BINARY LOGS;
#########################################################################
# binlog_row_image = MINIMAL
#########################################################################
INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
(2, "insert_to_t1", 2, repeat('a', 20)),
(3, "insert_to_t1", 3, repeat('a', 20));
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t1 WHERE c1 = 1;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
#Q> (2, "insert_to_t1", 2, repeat('a', 20)),
#Q> (3, "insert_to_t1", 3, repeat('a', 20))
### INSERT INTO `test`.`t1`
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1(c1) VALUES(4)
### INSERT INTO `test`.`t1`
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### SET
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t1 WHERE c1 = 1
### DELETE FROM `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY LOGS;
# t2 has no primary key.
# It will binlog full before and after image for all modes if the
# table has no primary key. FULL_NODUP follows the behavior.
INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
(2, "insert_to_t2", 2, repeat('a', 20)),
(3, "insert_to_t2", 3, repeat('a', 20));
INSERT INTO t2(c1) VALUES(4);
UPDATE t2 SET c2 = "only_c2_changed";
UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t2 WHERE c1 > 2;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
#Q> (2, "insert_to_t2", 2, repeat('a', 20)),
#Q> (3, "insert_to_t2", 3, repeat('a', 20))
### INSERT INTO `test`.`t2`
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2(c1) VALUES(4)
### INSERT INTO `test`.`t2`
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 2
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
#
# NOBLOB mode works as expected
#
SET binlog_row_image = "NOBLOB";
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
c3 INT DEFAULT 1000, c4 TEXT);
CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
FLUSH BINARY LOGS;
#########################################################################
# binlog_row_image = NOBLOB
#########################################################################
INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
(2, "insert_to_t1", 2, repeat('a', 20)),
(3, "insert_to_t1", 3, repeat('a', 20));
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t1 WHERE c1 = 1;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
#Q> (2, "insert_to_t1", 2, repeat('a', 20)),
#Q> (3, "insert_to_t1", 3, repeat('a', 20))
### INSERT INTO `test`.`t1`
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1(c1) VALUES(4)
### INSERT INTO `test`.`t1`
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t1 WHERE c1 = 1
### DELETE FROM `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY LOGS;
# t2 has no primary key.
# It will binlog full before and after image for all modes if the
# table has no primary key. FULL_NODUP follows the behavior.
INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
(2, "insert_to_t2", 2, repeat('a', 20)),
(3, "insert_to_t2", 3, repeat('a', 20));
INSERT INTO t2(c1) VALUES(4);
UPDATE t2 SET c2 = "only_c2_changed";
UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t2 WHERE c1 > 2;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
#Q> (2, "insert_to_t2", 2, repeat('a', 20)),
#Q> (3, "insert_to_t2", 3, repeat('a', 20))
### INSERT INTO `test`.`t2`
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2(c1) VALUES(4)
### INSERT INTO `test`.`t2`
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 2
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
#
# FULL mode works as expected
#
SET binlog_row_image = "FULL";
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
c3 INT DEFAULT 1000, c4 TEXT);
CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
FLUSH BINARY LOGS;
#########################################################################
# binlog_row_image = FULL
#########################################################################
INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
(2, "insert_to_t1", 2, repeat('a', 20)),
(3, "insert_to_t1", 3, repeat('a', 20));
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t1 WHERE c1 = 1;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
#Q> (2, "insert_to_t1", 2, repeat('a', 20)),
#Q> (3, "insert_to_t1", 3, repeat('a', 20))
### INSERT INTO `test`.`t1`
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1(c1) VALUES(4)
### INSERT INTO `test`.`t1`
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t1 WHERE c1 = 1
### DELETE FROM `test`.`t1`
### WHERE
### @1=1 /* INT meta=0 nullable=0 is_null=0 */
### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY LOGS;
# t2 has no primary key.
# It will binlog full before and after image for all modes if the
# table has no primary key. FULL_NODUP follows the behavior.
INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
(2, "insert_to_t2", 2, repeat('a', 20)),
(3, "insert_to_t2", 3, repeat('a', 20));
INSERT INTO t2(c1) VALUES(4);
UPDATE t2 SET c2 = "only_c2_changed";
UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t2 WHERE c1 > 2;
# Verify that rows events are binlogged as expeced.
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
#Q> (2, "insert_to_t2", 2, repeat('a', 20)),
#Q> (3, "insert_to_t2", 3, repeat('a', 20))
### INSERT INTO `test`.`t2`
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2(c1) VALUES(4)
### INSERT INTO `test`.`t2`
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t2`
### WHERE
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=2 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=3 /* INT meta=0 nullable=1 is_null=0 */
### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`
### WHERE
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
### @1=4 /* INT meta=0 nullable=1 is_null=0 */
### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### @3=1 /* INT meta=0 nullable=1 is_null=0 */
### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 2
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
RESET MASTER;
ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
Reference in a new issue View git blame Copy permalink