From d71043b8892ffa6ac1fc66b1ab7e082bcb234bab Mon Sep 17 00:00:00 2001
From: "igor@olga.mysql.com" <>
Date: Mon, 14 May 2007 16:41:09 -0700
Subject: Fixed bug #27937: crash for the the second execution of a prepared
 statement from a UNION query with ORDER BY an expression containing RAND().
 The crash happened because the global order by list in the union query was
 not re-initialized for execution. (Local order by lists were re-initialized
 though).

---
 sql/sql_union.cc | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'sql/sql_union.cc')

diff --git a/sql/sql_union.cc b/sql/sql_union.cc
index f3f814831f5..615d060a5a8 100644
--- a/sql/sql_union.cc
+++ b/sql/sql_union.cc
@@ -135,6 +135,11 @@ st_select_lex_unit::init_prepare_fake_select_lex(THD *thd)
   fake_select_lex->table_list.link_in_list((byte *)&result_table_list,
 					   (byte **)
 					   &result_table_list.next);
+  for (ORDER *order= (ORDER *) global_parameters->order_list.first;
+       order;
+       order= order->next)
+    order->item= &order->item_ptr;
+
   return options_tmp;
 }
 
-- 
cgit v1.2.1