[CALCITE-1535] Give error if ORDER BY clause references ambiguous column name

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Dongming Liu
• Created: 09/Dec/16 08:40
• Updated: 03/Apr/19 12:21
• Resolved: 25/Jan/17 21:43

Description

When I use calcite, I found follow sql can convert to a RelNode correctly.

 
SELECT id AS t1, name AS t1 FROM T ORDER BY t1

The column name t1 for ORDER BY is ambiguous, should check at validation?

Issue Links

• relates to: CALCITE-2977 Exception is not thrown out when there are ambiguous field in select list