the name resolve of query is really different from MySQL

[xiongjiwei]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

select * from (select 1 as a) t where test.t.a=1;
select * from (select 1 as a) t, test.t where test.t.a=1;
select * from (select 1 as a) t, test.t where t.a=1;
select * from (select 1 as a) t, t where test.t.a=1;

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

run success except for 3th.

3. What did you see instead (Required)

all failed

4. What is your TiDB version? (Required)

[longfeiss]

Is there any document about how MySQL search table in queries?

[xiongjiwei]

Is there any document about how MySQL search table in queries?

sorry, I cannot find the official doc about it, maybe you can take a look at https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html

[dveeden]

https://dev.mysql.com/doc/dev/mysql-server/latest/ might be useful here. sql/sql_resolver.cc and sql/table.cc might contain some of the info you are looking for.

[winoros]

This is one is also familiar with #25364. We need a discussion about the behavior.