Skip to content

Bug Report: Group_concat with separator crashes vtgate during planning #16238

@GuptaManan100

Description

@GuptaManan100

Overview of the Issue

Running a query like -

select group_concat(t3.name SEPARATOR ', ') as "Group Name"
from t1
         join t2 on t1.id = t2.t1_id
         left join t3 on t1.id = t3.id
group by t1.id;

can crash the vtgate if all the three tables, t1, t2 and t3 are sharded on the id columns.

Reproduction Steps

Run the query in a sharded vitess cluster.

Binary Version

main

Operating System and Environment details

-

Log Fragments

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions