Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
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)