[PHOENIX-943] Handle pushed down post-filters for subquery in joins with limit and non-groupby aggregation

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0, 4.0.0
• Fix Version/s: 4.2.0, 3.2.0
• Assignee: Wei Xue
• Reporter: Wei Xue
• Due: 30/May/14
• Created: 22/Apr/14 18:06
• Updated: 21/Nov/15 02:18
• Resolved: 20/Oct/14 15:39

Description

Support cases like:
1) select ... from A join (select id, b from T limit 10) as B on A.id = B.id where B.b = 'b'
2) select ... from A join (select count c from T) as B on A.a = B.c where B.c > 10

These 2 cases cannot be handled by SubselectRewriter#applyPostFilters(), thus JoinCompiler should compile post-filters into query-plans for subqueries.