Bug #115696 MySQL reports a error when group by has a lateral subquery.

Description:
It reports error message: Duplicate column name 'a'

How to repeat:
following SQL:

create table t1(a int);
select (select ti1.a as c0
                from
                  t1 as ti1,
                  lateral (select to1.a as c00,
                        to1.a as c11
                      from
                        t1 as ti2) as subq_0 limit 1) as c1
      from
        t1 as to1 group by 1;

Note, If remove 'group by 1' from above SQL, the query can be executed successfully.

Hello Diancheng Wang,

Thank you for the report and feedback.

regards,
Umesh

Documented fix as follows in the MySQL 9.1.0 changelog:

    A GROUP BY query containing a LATERAL subquery raised a spurious
    duplicate column error.

Closed.