bzr push into mysql-5.1-telco-7.0-spj branch (ole.john.aske:3227 to 3228)

[Ole John Aske]

 3228 Ole John Aske	2010-10-21
      
      Updated 'main.partitions' testcase after http://lists.mysql.com/commits/121334
      
      As resultset wo/ explicit 'order by' is no longer implicit sorted, a '--sorted_result' should be 
      added to testcase which makes assumptions about the result being sorted.

    modified:
      mysql-test/t/partition.test
 3227 Ole John Aske	2010-10-20
      Cherry picked proposed fix for bug#57601 into telco.7-0.spj bran
      ch:
      Make the optimizer less eager in requesting ordered access when it is actually not needed.

    modified:
      mysql-test/suite/ndb/r/ndb_join_pushdown.result
      sql/opt_range.cc
      sql/opt_range.h
      sql/sql_select.cc
=== modified file 'mysql-test/t/partition.test'
--- a/mysql-test/t/partition.test	2010-03-22 12:30:27 +0000
+++ b/mysql-test/t/partition.test	2010-10-21 07:23:57 +0000
@@ -1556,9 +1556,11 @@ partitions 10;
 show create table t1;
 insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE),
 (18446744073709551613), (18446744073709551612);
+--sorted_result
 select * from t1;
 select * from t1 where a = 18446744073709551615;
 delete from t1 where a = 18446744073709551615;
+--sorted_result
 select * from t1;
 drop table t1;
 

No bundle (reason: useless for push emails).