[jira] [Created] (OPTIQ-312) Need PushProjectThroughWindowRel

["Vladimir Sitnikov (JIRA)" <ji...@apache.org>]

Vladimir Sitnikov created OPTIQ-312:
---------------------------------------

             Summary: Need PushProjectThroughWindowRel
                 Key: OPTIQ-312
                 URL: https://issues.apache.org/jira/browse/OPTIQ-312
             Project: optiq
          Issue Type: Improvement
            Reporter: Vladimir Sitnikov
            Assignee: Julian Hyde
            Priority: Minor


Currently optiq does not push projects through {{WindowRel}}, thus it feeds excessive data to {{WindowRel}}.

{code:sql}
select *
  from (
    select "empid", "deptno", count(*) over (partition by "deptno") c
      from "hr"."emps"
 )
 where "deptno"=10 and "empid"=100{code}

Optiq should recognize it is required to track just fields {{empid}} and {{deptno}}.

However the java code is as follows (note that empid, name, salary, and commission are projected):
{code:java}
/*  47 */       _list.add(new Object[] {
/*  48 */         row.empid,
/*  49 */         row.deptno,
/*  50 */         row.name,
/*  51 */         row.salary,
/*  52 */         row.commission,
/*  53 */         COUNTa0w0});
{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)