Bug #108224 WITH ROLLUP assertion error

• Submitted: 22 Aug 2022 14:04
• Modified: 27 Jan 16:18
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S6 (Debug Builds)
• Version: 8.0.30
• OS: Ubuntu (22.04.1)
• CPU Architecture: x86 (x86_x64)
• Tags: with rollup

[22 Aug 2022 14:04] Pedro Ferreira

Description:
The following query:

SELECT 1 FROM (SELECT 2) t0(c0) GROUP BY TRUE, t0.c0 WITH ROLLUP HAVING TRUE;

Triggers an assertion error at sql_optimizer.cc:4808

assert(cond->real_item()->is_bool_func());

The expected output is 3 rows with a value of 1.

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.

[23 Aug 2022 7:58] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[27 Jan 16:18] Pedro Ferreira

Set the right architecture.