Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
5.7.23-25, 8.0.13-3, 5.6.43-84.3
-
None
Description
Originally reported at https://bugs.mysql.com/bug.php?id=93917
Description:
Bug #56007
seems to be silently fixed. However, the same issue exists for a BLOB column.
How to repeat:
Run the attached test case, then check binary logs on the slave.
Test column changes recorded correctly.
Original update:
UPDATE BLACK SET TEXTCOL='teststring_update' where ID=1;
Binlog entry:
-
-
- UPDATE `test`.`BLACK`
- WHERE
- @1=1 /* LONGINT meta=0 nullable=1 is_null=0 */
- @2='teststring' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- @3='TESTBLOB' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- SET
- @1=1 /* LONGINT meta=0 nullable=1 is_null=0 */
- @2='teststring_update' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- @3='TESTBLOB' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
-
Update for a BLOB column not.
Original update:
UPDATE BLACK SET BLOBCOL='testblob_update' where ID=2;
Binlog entry:
-
-
- UPDATE `test`.`BLACK`
- WHERE
- @1=2 /* LONGINT meta=0 nullable=1 is_null=0 */
- @2='TESTSTRING_2' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- @3='testblob_u' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- SET
- @1=2 /* LONGINT meta=0 nullable=1 is_null=0 */
- @2='TESTSTRING_2' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
- @3='testblob_update' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
-