bzr push into mysql-trunk branch (hemant.hk.kumar:3953 to 3954)

[Hemant Kumar]

 3954 Hemant Kumar	2012-06-06
      Moving memcached tests out from experimental list, since they are not failing anymore.

    modified:
      mysql-test/collections/default.experimental
 3953 Vasil Dimov	2012-06-06
      Followup to WL#6189 Turn InnoDB persistent statistics ON by default
      
      Adjust mtr tests, part 27.
      
      Persistent stats use a different sampling algorithm so it is possible
      that the stats numbers differ from transient stats.
      
      Also, persistent stats are updated less frequently or with a delay, so
      it is possible that persistent stats are not up to date as transient were
      even if both algorithms would return the same results.
      
      The order of the returned rows by a SELECT query depends on the stats and
      thus, if possible, we fix tests by prepending "-- sorted_result" to SELECTs
      that happen to return rows in different order.
      
      If possible, each failing test was fixed by manually running ANALYZE TABLE.
      This is doable if both transient and persistent sampling algorithms end up
      with the same numbers for the given table and its data.
      
      If persistent stats result in different stats, then test failures were fixed
      by forcing the usage of transient stats for the table by using
      CREATE TABLE ... STATS_PERSISTENT=0.
      
      Intentionally do not fix the tests by using persistent stats and adjustin
      the output of EXPLAIN in .result files because a different execution plan
      may cause a different code path to be executed, than the one originally
      intended in the test.

    modified:
      mysql-test/include/ctype_utf8mb4.inc
      mysql-test/include/innodb-index.inc
      mysql-test/t/ctype_utf8.test
      mysql-test/t/ctype_utf8mb4.test
=== modified file 'mysql-test/collections/default.experimental'
--- a/mysql-test/collections/default.experimental	2012-05-22 05:16:02 +0000
+++ b/mysql-test/collections/default.experimental	2012-06-06 14:08:29 +0000
@@ -47,7 +47,3 @@ sys_vars.rpl_init_slave_func		 # Bug#125
 rpl.rpl_mixed_mts_rec_crash_safe @solaris          # Bug#12902514 2011-08-19 andrei mts recovery tests are slow
 rpl.rpl_mixed_mts_rec_crash_safe_checksum @solaris # Bug#12902514 2011-08-19 andrei same as rpl_mixed_mts_rec_crash_safe
 rpl.rpl_mixed_mts_crash_safe @solaris              # Bug#12902514 2011-08-19 andrei same as rpl_mixed_mts_rec_crash_safe
-
-# All memcached tests are failing. This could be setup issues on PB2
-# Making experimental until the problems are resolved
-memcached.*

No bundle (reason: useless for push emails).