Bug #109459 Insert ignore subquery error
Submitted: 21 Dec 2022 12:21 Modified: 27 Jan 2023 15:20
Reporter: Pedro Ferreira Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:8.0.31 OS:Ubuntu (22.04)
Assigned to: CPU Architecture:x86 (x86_64)
Tags: IGNORE, insert, subquery

[21 Dec 2022 12:21] Pedro Ferreira 
Description:
Run the following queries:

CREATE TABLE t0 (c1 INT);
INSERT IGNORE INTO t0 (c1) VALUES ROW((VALUES ROW(1),ROW(2)));

The insert will trigger an assertion error in sql_select.cc:415

assert(thd->is_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.
[21 Dec 2022 12:31] MySQL Verification Team 
Hello Pedro Ferreira,

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

regards,
Umesh
[21 Dec 2022 13:54] Pedro Ferreira 
Same for UPDATE:

UPDATE IGNORE t0 SET c1 = (VALUES ROW(0),ROW(2));
[5 Jan 2023 10:16] Pedro Ferreira 
And DELETE:

DELETE IGNORE FROM t2 WHERE (VALUES ROW(1),ROW(2));
[27 Jan 2023 15:20] Pedro Ferreira 
Set right OS