Initial support for left join, also a negative test for a subquery bug