Unknown column in 'on clause' exception occurs when mysql join have duplicate table aliases

[strongduanmu]

Bug Report

Which version of ShardingSphere did you use?

022baef

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

All

Expected behavior

Execute sql successfully

Actual behavior

Reason analyze (If you can)

When Column Binder is executed, the corresponding columns of the table in tableBinderContexts are retrieved. When multiple tables in one SQL use the same alias, overlap may occur. Therefore, it needs to be transformed into Multimap. When the alias is repeated, it is searched from the value collection.

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).