bzr commit into mysql-5.5-cluster branch (magnus.blaudd:3267) Bug#11764737

[Magnus Blåudd]

#At file:///home/msvensson/mysql/5.5-cluster/ based on revid:magnus.blaudd@strippedlcy

 3267 Magnus Blåudd	2011-03-29
      bug#11764737 Optimizer is overly eager to request ordered access.
       - Update .result files
      - As results are not any longer implicitly ordered even when 'ORDER BY' 
         is *not* specified the order of rows in these results has changes.
            
      - The rows are now ordered in their 'natural' order as determined
           by each storage engine. (Still when 'ORDER BY' is not specifyed)

    modified:
      mysql-test/r/innodb_mysql_lock2.result
      mysql-test/r/partition.result
=== modified file 'mysql-test/r/innodb_mysql_lock2.result'
--- a/mysql-test/r/innodb_mysql_lock2.result	2010-06-17 13:31:51 +0000
+++ b/mysql-test/r/innodb_mysql_lock2.result	2011-03-29 06:30:02 +0000
@@ -605,11 +605,11 @@ begin;
 # Acquire SR metadata lock on t1.
 select * from t1;
 i
+4
 1
+5
 2
 3
-4
-5
 # Switching to connection 'con1'.
 # Sending:
 alter table t1 rebuild partition p0;

=== modified file 'mysql-test/r/partition.result'
--- a/mysql-test/r/partition.result	2011-03-28 13:57:20 +0000
+++ b/mysql-test/r/partition.result	2011-03-29 06:30:02 +0000
@@ -1725,8 +1725,8 @@ insert into t1 values (18446744073709551
 (18446744073709551613), (18446744073709551612);
 select * from t1;
 a
-18446744073709551612
 18446744073709551614
+18446744073709551612
 18446744073709551613
 18446744073709551615
 select * from t1 where a = 18446744073709551615;
@@ -1735,8 +1735,8 @@ a
 delete from t1 where a = 18446744073709551615;
 select * from t1;
 a
-18446744073709551612
 18446744073709551614
+18446744073709551612
 18446744073709551613
 drop table t1;
 CREATE TABLE t1 (

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