Bug #109309 PREPARE create index error

• Submitted: 7 Dec 2022 17:34
• Modified: 11 Jun 2024 17:11
• Reporter: Pedro Ferreira
• Status: Closed
• Category: MySQL Server: DDL
• Severity: S6 (Debug Builds)
• Version: 8.0.31, 8.0.30
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: create index, prepare

[7 Dec 2022 17:34] Pedro Ferreira

Description:
Run the following queries:

CREATE TABLE t1 (c1 BOOLEAN);
PREPARE p0 FROM 'CREATE INDEX i1 ON t1 ((?))';
SET @a0 = 1;
EXECUTE p0 USING @a0;

The prepared statement will trigger an assertion error in sql_prepare.cc:2948

assert(false);

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.

[8 Dec 2022 6:59] MySQL Verification Team

Hello Pedro Ferreira,

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

regards,
Umesh

[11 Jun 2024 17:11] Jon Stephens

Fixed in MySQL 9.0.0 by WL#16298. See same for more info.

Closed.