View query returns unexpected error when containing subquery

[pcqz]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://asktug.com/t/topic/93840

CREATE TABLE table1 (
id int(0) DEFAULT NULL,
name varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE table2 (
id int(0) DEFAULT NULL,
name varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

insert into table1(id ,name) values(1,'a');
insert into table2(id ,name) values(1,'a');

CREATE view temp_v as 
select t1.id as i1,t2.id as i2,t3.id as i3
from (select tt.id,tt.name from (select id,name from table1) tt) as t1
LEFT JOIN table1 t2 on t1.name = t2.name
LEFT JOIN table2 t3 on t1.name = t3.name;

select * from temp_v;

2. What did you expect to see? (Required)

No error

3. What did you see instead (Required)

mysql>  select * from temp_v;
ERROR 1105 (HY000): line 1 column 158 near "AS `t1` LEFT JOIN `xm_test`.`table1` AS `t2` ON `t1`.`name`=`t2`.`name`) LEFT JOIN `xm_test`.`table2` AS `t3` ON `t1`.`name`=`t3`.`name`" 

4. What is your TiDB version? (Required)

v5.0.2

[zhaoxugang]

this issue seems to belong parser.

[xuyifangreeneyes]

#25647 has fixed the bug and is going to check pick to 5.0/5.1/5.2.

[fuzhe1989]

any update? @lzmhhh123

[lzmhhh123]

any update? @lzmhhh123

The cherry-pick is not easy. I'm waiting for transferring parser to TiDB.

[lzmhhh123]

Now it is done, then we could do it. But the release branch is still not done.

[fuzhe1989]

@lzmhhh123 Any blocking issue? Guess we can cherry-pick to release branches as before.

[lzmhhh123]

@lzmhhh123 Any blocking issue? Guess we can cherry-pick to release branches as before.

There's still another related issue #28476, I'd like to fix it then cherry-pick them together.

[windtalker]

I think it is already fixed in master branch, so should not affect 6.1

[zanmato1984]

Changing labels.

[zimulala]

I tried it and the problem was solved in master(5d4745e).

Since this problem is not critical, I think it can be closed without cherry-pick. You can open it again if you have a problem