[CALCITE-633] WITH ... ORDER BY cannot find table - ASF JIRA

Details

Calcite cannot find table alias when resolving the ORDER BY clause of a WITH query. Example:

with e as (select * from emp)
select * from e as e1 order by e1.empno

throws

Table 'E1' not found

is related to

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

Hide

Permalink

Julian Hyde added a comment - 23/Mar/15 22:43

Show

Julian Hyde added a comment - 23/Mar/15 22:43 Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/3807827b .

Hide

Permalink

Julian Hyde added a comment - 16/Apr/15 08:35

Resolved in release 1.2.0-incubating (2015-04-16)

Show

Julian Hyde added a comment - 16/Apr/15 08:35 Resolved in release 1.2.0-incubating (2015-04-16)