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; > }