You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/04/03 20:05:53 UTC
[jira] [Created] (CALCITE-662) Query validation fails when an ORDER
BY clause is used with WITH-CLAUSE
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)