MySQL Bugs: #110077: Lateral join error

Bug #110077	Lateral join error
Submitted:	15 Feb 2023 11:20	Modified:	15 Feb 2023 11:23
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S6 (Debug Builds)
Version:	8.0.32	OS:	Ubuntu (22.04)
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	LATERAL

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Run these queries:

CREATE TABLE t2 (c1 INT, c0 INT NOT NULL);
INSERT INTO t2(c1,c0) VALUES (1,1);
SELECT 1 FROM (SELECT 1 FROM (t2 t1 JOIN LATERAL (VALUES ROW(c0),ROW(1)) t2(c1) USING (c1))) t0(c0);

The SELECT query will trigger an assertion error at sql/field.cc:3761
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 statements above.

Hello Pedro Ferreira,

Thank you for the report and feedback.

regards,
Umesh