MySQL Bugs: #110979: Update assertion error

Bug #110979	Update assertion error
Submitted:	10 May 2023 15:52	Modified:	11 May 2023 6:22
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S6 (Debug Builds)
Version:	8.0.33	OS:	Ubuntu (22.04)
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	UPDATE

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
This may be related to Bug #73869. Run these statements:

CREATE TABLE t0 (c0 YEAR, c1 INT AS (1) VIRTUAL);
INSERT IGNORE INTO t0 (c0) (SELECT 2100);
SET SESSION BINLOG_ROW_IMAGE = 'MINIMAL';
UPDATE t0 SET c0 = 2000 WHERE utc_date() <> c0;

The update will trigger an assertion error at sql/field.cc:3712
ASSERT_COLUMN_MARKED_FOR_WRITE;

The compilation parameters are the same as issue 108148:

-DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77

How to repeat:
Run the statements above.

Hello Pedro Ferreira,

Thank you for the report and feedback.
Observed that 8.0.33 debug build is affected.

regards,
Umesh