[CALCITE-662] Query validation fails when an ORDER BY clause is used with WITH CLAUSE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 03/Apr/15 18:05
• Updated: 16/Apr/15 08:35
• Resolved: 06/Apr/15 18:09

Description

This query fails in validation:

WITH
              x
              AS (SELECT deptno a
                       FROM  emp)
              (SELECT  x.a 
              FROM   x
              ORDER  BY x.a)

while this one below, basically the same except for the "ORDER BY being gone", succeeds:

WITH
              x
              AS (SELECT deptno a
                       FROM  emp)
              (SELECT  x.a 
              FROM   x)