Detail message: Not unique table/alias‘cc’

[zxf216]

Steps to reproduce the behavior (Required)

Starrocks：

MySQL [(none)]> select * from
-> (
-> (select 1 as a1) cc
-> left join
-> (select 1 as a2) cc
-> on cc.a1 = cc.a2
-> ) aa;
ERROR 1066 (42000): Getting analyzing error. Detail message: Not unique table/alias: 'cc'.

Spark

spark-sql> select * from
> (
> (select 1 as a1) cc
> left join
> (select 1 as a2) cc
> on cc.a1 = cc.a2
> ) aa;
OK
1 1
Time taken: 6.255 seconds, Fetched 1 row(s)

Presto

presto> select * from
-> (
-> (select 1 as a1) cc
-> left join
-> (select 1 as a2) cc
-> on cc.a1 = cc.a2
-> ) aa;
a1 | a2
----+----
1 | 1
(1 row)

Expected behavior (Required)

no error

Real behavior (Required)

ERROR 1066 (42000): Getting analyzing error. Detail message: Not unique table/alias: 'cc'.

StarRocks version (Required)

2.2.5