Bug #109375 Create view with group_concat subquery error
Submitted: 14 Dec 2022 10:42 Modified: 14 Dec 2022 12:54
Reporter: Pedro Ferreira Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S6 (Debug Builds)
Version:8.0.31 OS:Ubuntu (22.04)
Assigned to: CPU Architecture:x86 (x86_64)
Tags: create a view, group_concat, subquery

[14 Dec 2022 10:42] Pedro Ferreira 
Description:
Run the following query:

CREATE VIEW t1 (c1) AS (SELECT GROUP_CONCAT(1 = ALL(SELECT 2)));

The statement will trigger an assertion error in item_subselect.cc:1640

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 query above.
[14 Dec 2022 10:53] MySQL Verification Team 
Hello Pedro Ferreira,

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

regards,
Umesh
[14 Dec 2022 12:46] Pedro Ferreira 
Set the right category
[14 Dec 2022 12:54] Pedro Ferreira 
With a slight difference:

CREATE VIEW t0 (c0) AS (SELECT GROUP_CONCAT((SELECT 1)));

Another assertion is triggered at item_subselect.cc:655:

assert(!thd->lex->is_view_context_analysis());