[PHOENIX-927] Support derived tables in joins

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.0, 4.1.0
• Labels: enhancement
• Assignee: Wei Xue
• Reporter: Wei Xue
• Due: 25/Apr/14
• Created: 10/Apr/14 18:34
• Updated: 21/Nov/15 02:18
• Resolved: 04/Aug/14 11:39

Description

Support grammar like:
SELECT a.col1, b.col2, c.col3 FROM
(SELECT rk, col1 FROM table1 WHERE col1 LIKE 'foo%' AND col300 IS NULL) AS a
JOIN (SELECT rk, col2 FROM table2 WHERE col2 LIKE 'bar%') AS b ON a.rk=b.rk
JOIN (SELECT rk, col3 FROM table3 ) AS c ON a.rk=c.rk;