[PHOENIX-1332] Support correlated subqueries in comparison with ANY/SOME/ALL

• Type: Sub-task
• Status: Closed
• Priority: Major
• 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: 15/Nov/14
• Created: 08/Oct/14 01:07
• Updated: 21/Nov/15 02:15
• Resolved: 14/Oct/14 20:59

Description

Support grammar like:

select * from OrderTable o where quantity >= ALL(select quantity from OrderTable where item_id = o.item_id)