Bug #108910 Forced secondary engine execution assertion error

• Submitted: 28 Oct 2022 10:58
• Modified: 28 Oct 2022 11:06
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S6 (Debug Builds)
• Version: 8.0.31
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: exists

[28 Oct 2022 10:58] Pedro Ferreira

Description:
The following queries:

SET SESSION USE_SECONDARY_ENGINE = FORCED;
SELECT 1 FROM (SELECT 5) t1(c0) WHERE EXISTS (VALUES ROW(1),ROW(2));

Trigger an assertion error at template_utils.h:100

assert(nullptr != dynamic_cast<Target>(arg));

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

[28 Oct 2022 11:06] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[1 Feb 2023 21:05] Dag Wanvik

Posted by developer:
 
This is a variant of Bug#35014318 Exists query assertion error.