[
https://issues.apache.org/jira/browse/TAJO-1023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-1023:
-------------------------------
Fix Version/s: (was: 0.9.0)
> Filter may be omitted when same aliased tables are used in inline views.
> ------------------------------------------------------------------------
>
> Key: TAJO-1023
> URL: https://issues.apache.org/jira/browse/TAJO-1023
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Priority: Minor
>
> The following query reproduces the problem mentioned in subject. In this
> case, {{a.row_num >= 3}} disappears during filter push down rewrite.
> {code}
> select
> a.r_name, a.row_num
> from (
> select
> r_name,
> r_regionkey,
> row_number() over (order by r_name) as row_num
> from
> region a
> ) a join region b on a.r_regionkey = b.r_regionkey
> where
> a.row_num >= 3;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
