The index can only be used when it covers all ORDER BY columns.
Now that the SubPlanAssembler uses table aliases instead of table names, it should correctly fail the optimization in this case and force a Sort. I will add a test case for this.