[FLINK-29885] SqlValidatorException :Column 'currency' is ambiguous

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Component/s: Documentation, Table SQL / API
• Assignee: Unassigned
• Reporter: ZuoYan
• Created: 04/Nov/22 09:11
• Updated: 04/Nov/22 10:39
• Resolved: 04/Nov/22 10:39

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。