Bug #110527 Analyse histogram assertion error

• Submitted: 28 Mar 8:36
• Modified: 28 Mar 9:41
• 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: ANALYSE, histogram

[28 Mar 8:36] Pedro Ferreira

Description:
Run the following statements:

CREATE TABLE t0 (c0 TEXT);
INSERT INTO t0(c0) VALUES (1);
ANALYZE LOCAL TABLE t0 UPDATE HISTOGRAM ON c0 WITH 2 BUCKETS;
SELECT 1 FROM (SELECT 1) x(x) JOIN t0 ON reverse(1) = t0.c0;

The SELECT query will give an assertion error at sql/histograms/value_map.cc:52

assert(lhs.charset()->number == rhs.charset()->number);

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.

[28 Mar 9:41] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh