See Tracker item CORE-4528.
Hash/merge joins for non-field (DBKEY or derived expression) equalities are now allowed.
See Tracker item CORE-1482.
The optimizer now considers the ORDER BY optimization when making its decision about join order.