Bug #108224 WITH ROLLUP assertion error
Submitted: 22 Aug 2022 14:04 Modified: 27 Jan 2023 16:18
Reporter: Pedro Ferreira Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S6 (Debug Builds)
Version: 8.0.30 OS:Ubuntu (22.04.1)
Assigned to: 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 2023 16:18] Pedro Ferreira
Set the right architecture.