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

[Sean Hsuan-Yi Chu (JIRA)]

Sean Hsuan-Yi Chu created CALCITE-662:
-----------------------------------------

             Summary: Query validation fails when an ORDER BY clause is used 
with WITH-CLAUSE
                 Key: CALCITE-662
                 URL: https://issues.apache.org/jira/browse/CALCITE-662
             Project: Calcite
          Issue Type: Bug
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Julian Hyde


This query fails in validation:
{code:sql}
WITH
              x
              AS (SELECT deptno a
                       FROM  emp)
              (SELECT  x.a 
              FROM   x
              ORDER  BY x.a)
{code}

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

{code:sql}
WITH
              x
              AS (SELECT deptno a
                       FROM  emp)
              (SELECT  x.a 
              FROM   x)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)