[BUG] 对于子查询join的SQL解析出的字段所属表问题

[jianglianggithub]

Database Type

MYSQL

Database Version

5.7

Druid Version

1.2.24

JDK Version

OPENjdk 8

Error SQL

select a.name1, b.* from (select id , name1 from a) a join (select b.id , name2 from b) b on a.id = b.id 对于该SQL使用如下代码把b.*进行处理的时候出现解析结果不符合实际情况

SQLStatement stmt = SQLUtils.parseSingleStatement(sql, DbType.mysql); repository.resolve(stmt, ResolveAllColumn, ResolveIdentifierAlias); System.out.println(stmt.toString());

控制台输出的结果为

SELECT a.name1, a.id, b.name2
FROM (
    SELECT id, name1
    FROM a
) a
    JOIN (
        SELECT b.id, name2
        FROM b
    ) b
    ON a.id = b.id

正确的结果应该是

SELECT a.name1, b.id, b.name2
FROM (
    SELECT id, name1
    FROM a
) a
    JOIN (
        SELECT b.id, name2
        FROM b
    ) b
    ON a.id = b.id

我认为这是一个SQL解析的BUG

Testcase Code

No response

Stacktrace Info

No response

Error Info

No response