[sqlite] BUG: sqlite 3.8.11.x left join

[Mark Brand]

Hi,

For the query below, versions 3.8.11.0 and 3.8.11.1 return only 1 row. 
For some reason, the LEFT JOIN seems to behave like a JOIN.

Older versions (tested 3.8.7.4 and 3.8.10.2) correctly return 2 rows.

SELECT *
FROM (
     SELECT 'apple' fruit
     UNION ALL SELECT 'banana'
) a
JOIN (
     SELECT 'apple' fruit
     UNION ALL SELECT 'banana'
) b ON a.fruit=b.fruit
LEFT JOIN (
     SELECT 1 isyellow
) c ON b.fruit='banana'
;

regards,

Mark