diff a/sql/sql_select.cc  b/sql/sql_select.cc
7420,7422c7420
<       if (order_tables & OUTER_REF_TABLE_BIT)
<       *simple_order=0;
<       if ((order_tables & RAND_TABLE_BIT) && order->in_field_list)
---
>       if (order_tables & (RAND_TABLE_BIT | OUTER_REF_TABLE_BIT))
7437,7443d7434
<
<             if (order_tables & RAND_TABLE_BIT)
<             {
<               if (change_list)
<                 *prev_ptr= order;
<               prev_ptr= &order->next;
<             }