return true;

if (WALK(wc->endOffset))

return true;

if (WALK(wc->runCondition))

return true;

}

break;

caseT_CTECycleClause:

return true;

if (WALK(wc->endOffset))

return true;

if (WALK(wc->runCondition))

return true;

}

}

MUTATE(newnode->orderClause,wc->orderClause,List*);

MUTATE(newnode->startOffset,wc->startOffset,Node*);

MUTATE(newnode->endOffset,wc->endOffset,Node*);

MUTATE(newnode->runCondition,wc->runCondition,List*);

return (Node*)newnode;

}

break;

FLATCOPY(newnode,wc,WindowClause);

MUTATE(newnode->startOffset,wc->startOffset,Node*);

MUTATE(newnode->endOffset,wc->endOffset,Node*);

MUTATE(newnode->runCondition,wc->runCondition,List*);

resultlist=lappend(resultlist, (Node*)newnode);

}

sales | 3 | 4800 | 08-01-2007 | 3 | 1 | 3 | 3 | 1

(2 rows)

-- Ensure we remove references to reduced outer joins as nulling rels in run

-- conditions

EXPLAIN (COSTS OFF)

SELECT 1 FROM

(SELECT ntile(e2.salary) OVER (PARTITION BY e1.depname) AS c

FROM empsalary e1 LEFT JOIN empsalary e2 ON TRUE

WHERE e1.empno = e2.empno) s

WHERE s.c = 1;

QUERY PLAN

---------------------------------------------------------

Subquery Scan on s

Filter: (s.c = 1)

-> WindowAgg

Run Condition: (ntile(e2.salary) OVER (?) <= 1)

-> Sort

Sort Key: e1.depname

-> Merge Join

Merge Cond: (e1.empno = e2.empno)

-> Sort

Sort Key: e1.empno

-> Seq Scan on empsalary e1

-> Sort

Sort Key: e2.empno

-> Seq Scan on empsalary e2

(14 rows)

-- Tests to ensure we don't push down the run condition when it's not valid to

-- do so.

-- Ensure we don't push down when the frame options show that the window

FROM empsalary

) eWHERE rn<=1AND c1<=3AND nt<2;

EXPLAIN (COSTS OFF)

(SELECT ntile(e2.salary) OVER (PARTITION BYe1.depname)AS c

FROM empsalary e1LEFT JOIN empsalary e2ON TRUE

WHEREe1.empno=e2.empno) s

WHEREs.c=1;