[CALCITE-633] WITH ... ORDER BY cannot find table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 19/Mar/15 22:58
• Updated: 16/Apr/15 08:35
• Resolved: 23/Mar/15 22:43

Description

Calcite cannot find table alias when resolving the ORDER BY clause of a WITH query. Example:

with e as (select * from emp)
select * from e as e1 order by e1.empno

throws

Table 'E1' not found

Issue Links

• is related to: CALCITE-309 WITH ... ORDER BY query gives AssertionError