[CALCITE-309] WITH ... ORDER BY query gives AssertionError

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 22/Jun/14 19:45
• Updated: 19/Mar/15 22:59
• Resolved: 23/Jun/14 06:56

Description

A query that has both a WITH clause and an ORDER BY clause gives an assertion error. TPC-DS query #1 reproduces, as does the following simple test case.

with emp2 as (select * from emp)
select * from emp2
order by deptno

Issue Links

• relates to: CALCITE-633 WITH ... ORDER BY cannot find table