MySQL Bugs: #109473: Update assertion error

Bug #109473	Update assertion error
Submitted:	23 Dec 2022 15:41	Modified:	24 Dec 2022 13:42
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S6 (Debug Builds)
Version:	8.0.31	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:
Run the following queries:

CREATE TABLE t1 (c1 BOOLEAN);
SET SESSION BINLOG_FORMAT = STATEMENT;
CREATE TABLE t0 AS (SELECT 2 FROM t1);
INSERT INTO t1(c1) VALUES (1),(0),(0),(0),(1);
SELECT 1 FROM t1 JOIN (SELECT c0 FROM t0) t0(c1);
UPDATE t1 SET c1 = 1 ORDER BY c1;

The update will trigger an assertion error in field.cc:3254

ASSERT_COLUMN_MARKED_FOR_READ;

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 queries above.

Hello Pedro Ferreira,

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

regards,
Umesh