Bug#11766384 - 59487: WRONG RESULT WITH STRAIGHT_JOIN AND RIGHT JOIN
BUG#11752239 - 43368: STRAIGHT_JOIN DOESN'T WORK FOR NESTED JOINS 
BUG#11766858 - 60080: STRAIGHT_JOIN IS NOT ENFORCED WHEN RIGHT-HAND TABLE IS ITSELF A JOIN 
dependencies were not propagated when a nested join was flattened.