Bug #108272 Possible subquery leak

• Submitted: 24 Aug 2022 18:16
• Modified: 30 Aug 2022 15:57
• Reporter: Pedro Ferreira
• Status: Closed
• Category: MySQL Server: Optimizer
• Severity: S6 (Debug Builds)
• Version: 8.0.30
• OS: Ubuntu (22.04.1)
• CPU Architecture: x86 (x86_x64)
• Tags: order by, SUB QUERY

[24 Aug 2022 18:16] Pedro Ferreira

Description:
On a single client do the query:

SELECT ((SELECT 1 ORDER BY 1) ORDER BY 1);

Then exit, it will trigger an assertion error on the server at block.h:389

assert(Header::number_of_used_chunks() == 0);

The client exit should trigger no assertion on the server.

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

[26 Aug 2022 5:28] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[29 Aug 2022 9:04] Tor Didriksen

Posted by developer:
 
Bug is no longer reproducible in the upcoming 8.0.31