Bug #109840 Analyze then Rollup assertion error
Submitted: 30 Jan 2023 12:30 Modified: 30 Jan 2023 12:49
Reporter: Pedro Ferreira Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S6 (Debug Builds)
Version:8.0.32 OS:Ubuntu (22.04)
Assigned to: CPU Architecture:x86 (x86_64)
Tags: analyze, rollup

[30 Jan 2023 12:30] Pedro Ferreira 
Description:
Run the following queries:

CREATE TABLE t2 (c2 INT);
ANALYZE LOCAL TABLE t2 UPDATE HISTOGRAM ON c2;
INSERT INTO t2(c2) VALUES (-825647915),(-1913850479),(-575255943),(1691009715),(838710039),(-818119799),(485186404),(-988531300),(-909382048),(-248391195);
SELECT 1 FROM t2 GROUP BY c2 WITH ROLLUP;

The SELECT query will trigger an assertion error at cost_model.cc:582

assert(histogram->get_num_distinct_values() >= 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 statements above.
[30 Jan 2023 12:49] MySQL Verification Team 
Hello Pedro Ferreira,

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

regards,
Umesh