bzr push into mysql-trunk branch (horst.hunger:3544 to 3545)

[Horst.Hunger]

 3545 Horst.Hunger	2011-01-24
      Due to merge to trunk.

    modified:
      mysql-test/suite/parts/t/partition_exch_qa_14.test
 3544 Jorgen Loland	2011-01-24
      BUG#47853: Implicitly grouped queries do not need to use 
                 temporary tables
      
      A query is implicitly grouped if it contains an aggregate 
      function but no GROUP BY clause. Implicitly grouped queries 
      return zero or one row, so ordering does not make sense. 
      
      This patch removes the order by clause during the prepare()
      stage of the optimizer when implicitly ordered queries are 
      detected.
     @ mysql-test/r/func_group.result
        Updated result file
     @ mysql-test/r/limit.result
        Updated result file
     @ mysql-test/r/subquery_nomat_nosj.result
        Updated result file
     @ mysql-test/r/subquery_none.result
        Updated result file
     @ sql/sql_select.cc
        Remove order by clause during prepare() if the query is implicitly grouped.

    modified:
      mysql-test/r/func_group.result
      mysql-test/r/limit.result
      mysql-test/r/subquery_nomat_nosj.result
      mysql-test/r/subquery_none.result
      sql/sql_select.cc
=== modified file 'mysql-test/suite/parts/t/partition_exch_qa_14.test'
--- a/mysql-test/suite/parts/t/partition_exch_qa_14.test	2010-11-04 13:02:10 +0000
+++ b/mysql-test/suite/parts/t/partition_exch_qa_14.test	2011-01-24 11:51:30 +0000
@@ -1,6 +1,7 @@
 # Author: Horst Hunger
 # Created: 2010-07-13
 
+--source include/not_windows.inc
 --source include/have_partition.inc
 
 let $engine_table= MYISAM;


Attachment: [text/bzr-bundle] bzr/[e-mail]