[FLINK-29458] When two tables have the same field, do not specify the table name,Exception will be thrown：SqlValidatorException :Column 'currency' is ambiguous

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0, 1.16.1
• Component/s: Documentation, Table SQL / API
• Labels: pull-request-available
• Assignee: ZuoYan
• Reporter: ZuoYan
• Created: 28/Sep/22 12:58
• Updated: 24/Nov/22 10:35
• Resolved: 31/Oct/22 06:34

Description

When two tables are join, the two tables have the same field. When querying select, an exception will be thrown if the table name is not specified

exception content

Column 'currency' is ambiguous。

 

Issue Links

• links to: GitHub Pull Request #20983
• links to: GitHub Pull Request #21244