MySQL Bugs: #109874: DELETE assertion error

Bug #109874	DELETE assertion error
Submitted:	1 Feb 2023 12:38	Modified:	2 Feb 2023 8:27
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S6 (Debug Builds)
Version:	8.0.32	OS:	Ubuntu (22.04)
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	delete

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
This issue may be a duplicate of #108983. Run these queries

SET SESSION SQL_MODE = '';
CREATE TABLE t0 (c1 BOOLEAN);
INSERT INTO t0(c1) VALUES (1);
CREATE INDEX i1 ON t0 (c1, (CAST(X'30575172DB8E23407D25E196ADF68CA2AD11F5B5A8A27B4F' AS CHAR)));

Then restart the connection and do:

DELETE FROM t0;

It will trigger an assertion on the server at ut0dbg.cc:99

my_abort();

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.32 debug build is affected.

regards,
Umesh