Bug #110572 Hypergraph optimizer assertion error

• Submitted: 30 Mar 2023 14:05
• Modified: 31 Mar 2023 8:03
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S6 (Debug Builds)
• Version: 8.0.32
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: optimiser

[30 Mar 2023 14:05] Pedro Ferreira

Description:
Run these statements:

SET SESSION optimizer_switch ='hypergraph_optimizer=on';
SELECT min(1) WHERE sysdate() = (ROW(2, 5) = ROW(1, 3));

The SELECT query will trigger an assertion error at sql/iterators/basic_row_iterators.h:319

assert(!is_null_row);

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.

[31 Mar 2023 8:03] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh