Hyunsik Choi created TAJO-1023:
----------------------------------
Summary: 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
Fix For: 0.9.0
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)
