Bug #111585 Order by aggregate assertion error

• Submitted: 27 Jun 2023 15:18
• Modified: 28 Jun 2023 18:28
• Reporter: Pedro Ferreira
• Status: Closed
• Category: MySQL Server: DML
• Severity: S6 (Debug Builds)
• Version: 8.0.33
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)

[27 Jun 2023 15:18] Pedro Ferreira

Description:
Run the following queries:

CREATE TABLE t0 (c0 INT);
(SELECT 1) UNION (SELECT DISTINCT rank() OVER () x FROM t0 GROUP BY t0.c0 ORDER BY min(x));

The UNION query will throw an assertion error at sql/sql_tmp_table.cc:1074
assert(!distinct);

If I run the DISTINCT query outside the UNION I get a proper error.

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 queries above.

[28 Jun 2023 5:59] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[28 Jun 2023 18:28] Jon Stephens

Fixed by BUG#35168639 in MySQL 8.0.34.

Closed.