=== modified file 'sql/sql_resolver.cc'
--- sql/sql_resolver.cc	2012-10-26 13:32:38 +0000
+++ sql/sql_resolver.cc	2013-02-02 10:27:52 +0000
@@ -825,6 +825,10 @@
   bool order_with_sum_func= false;
   for (ORDER *o= subq_select_lex->join->order; o != NULL; o= o->next)
     order_with_sum_func|= (*o->item)->with_sum_func;
+  bool group_in_select_list= true;
+  for (ORDER *g= subq_select_lex->join->group_list; g != NULL; g= g->next)
+    group_in_select_list&= g->in_field_list;
+
   if (subq_select_lex->order_list.elements)
   {
     changelog|= REMOVE_ORDER;
@@ -852,7 +856,8 @@
     clause
   */
   if (subq_select_lex->group_list.elements &&
-      !subq_select_lex->with_sum_func && !subq_select_lex->join->having)
+      !subq_select_lex->with_sum_func && !subq_select_lex->join->having &&
+      group_in_select_list)
   {
     changelog|= REMOVE_GROUP;
     subq_select_lex->join->group_list= NULL;