Bug #111492 Subquery ref count assertion error

• Submitted: 20 Jun 2023 6:42
• Modified: 24 Jun 2023 1:56
• Reporter: Pedro Ferreira
• Status: Closed
• Category: MySQL Server: Optimizer
• Severity: S6 (Debug Builds)
• Version: 8.0.33
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: subquery

[20 Jun 2023 6:42] Pedro Ferreira

Description:
Run this query:

SELECT 1 FROM (SELECT 1) y(y) WHERE 0 AND (SELECT 1 FROM (SELECT 1) x(x) GROUP BY y.y HAVING 1 = ALL(SELECT min(x.x)));

It will trigger an assertion error at sql/item.h:3199
assert(m_ref_count > 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 query above.

[20 Jun 2023 6:45] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[24 Jun 2023 1:56] Jon Stephens

Fixed in MySQL 8.1.0 by BUG#110369.

See same for more info.

Closed.