Bug #101862 insert into t1 values (),(); failed when binlog_row_image=minimal

• Submitted: 4 Dec 2020 1:31
• Modified: 4 Dec 2020 10:00
• Reporter: Qilu Wei
• Status: Verified
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[4 Dec 2020 1:31] Qilu Wei

Description:
set binlog_format=ROW;

create table t1 (a int, b int);

mysql> set binlog_row_image=full;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (),();
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> set binlog_row_image=minimal;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values (),();
ERROR 1534 (HY000): Writing one row to the row-based binary log failed

How to repeat:
As above.

[4 Dec 2020 10:00] MySQL Verification Team

Thank you for the bug report.

[10 Dec 2020 13:32] Erlend Dahl

Posted by developer:
 
5.6 and 5.7 behave in the same way, just turn on the binlog (--log-bin=1, the default changed in 8.0).