Bug #109821 Subquery optimizer error
Submitted: 27 Jan 2023 12:57 Modified: 30 Jan 2023 8:30
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: subquery

[27 Jan 2023 12:57] Pedro Ferreira 
Description:
Run the following queries:

CREATE TABLE t0 (c0 INT);
CREATE TABLE t1 (c0 INT);
VALUES ROW(1),ROW((SELECT 1 FROM t1 NATURAL JOIN (SELECT 1 FROM t0) t0(c0)));

The values query will trigger an assertion error in sql_planner.cc:4667

assert(nest->nj_counter > 0);

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.
[27 Jan 2023 13:13] Pedro Ferreira 
Set right OS
[27 Jan 2023 15:22] Pedro Ferreira 
Set the right category.
[30 Jan 2023 8:30] MySQL Verification Team 
Hello Pedro Ferreira,

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

regards,
Umesh