Bug #111293 Create table partition by hash subquery assertion error

• Submitted: 6 Jun 2023 11:49
• Modified: 6 Jun 2023 12:03
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S6 (Debug Builds)
• Version: 8.0.33
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: hash, partition, subquery

[6 Jun 2023 11:49] Pedro Ferreira

Description:
Run the query:

CREATE TABLE t0 (c0 INT) PARTITION BY HASH((SELECT DISTINCT 1 x ORDER BY x)) AS (SELECT 1 c0);

It will trigger an assertion error at sql/aggregate_check.cc:116

assert((*order->item)->fixed);

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.

[6 Jun 2023 12:03] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh