bzr push into mysql-5.1-telco-7.0 branch (jonas.oreland:4840 to 4841)

[Jonas Oreland]

 4841 Jonas Oreland	2012-02-01 [merge]
      ndb - merge index_stat test fixes

    modified:
      mysql-test/suite/ndb/r/ndb_statistics0.result
      mysql-test/suite/ndb/r/ndb_statistics1.result
      mysql-test/suite/ndb/t/ndb_index_stat_enable.inc
      mysql-test/suite/ndb/t/ndb_statistics.inc
      mysql-test/suite/ndb/t/ndb_statistics0.test
      mysql-test/suite/ndb/t/ndb_statistics1.test
 4840 jonas oreland	2012-01-31
      ndb - fix typo

    modified:
      storage/ndb/src/kernel/vm/mt.cpp
=== modified file 'mysql-test/suite/ndb/r/ndb_statistics0.result'
--- a/mysql-test/suite/ndb/r/ndb_statistics0.result	2011-07-02 07:05:32 +0000
+++ b/mysql-test/suite/ndb/r/ndb_statistics0.result	2012-02-01 10:23:10 +0000
@@ -30,12 +30,10 @@ CREATE TABLE t100 LIKE t10;
 INSERT INTO t100(I,J)
 SELECT X.J, X.J+(10*Y.J) FROM t10 AS X,t10 AS Y;
 CREATE TABLE t10000 LIKE t10;
+ALTER TABLE t10000 ENGINE=MYISAM;
 INSERT INTO t10000(I,J)
-SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-WHERE X.J<50;
-INSERT INTO t10000(I,J)
-SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-WHERE X.J>=50;
+SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y;
+ALTER TABLE t10000 ENGINE=NDBCLUSTER;
 ANALYZE TABLE t10,t100,t10000;
 Table	Op	Msg_type	Msg_text
 test.t10	analyze	status	OK

=== modified file 'mysql-test/suite/ndb/r/ndb_statistics1.result'
--- a/mysql-test/suite/ndb/r/ndb_statistics1.result	2011-09-02 06:43:38 +0000
+++ b/mysql-test/suite/ndb/r/ndb_statistics1.result	2012-02-01 10:23:10 +0000
@@ -32,12 +32,10 @@ CREATE TABLE t100 LIKE t10;
 INSERT INTO t100(I,J)
 SELECT X.J, X.J+(10*Y.J) FROM t10 AS X,t10 AS Y;
 CREATE TABLE t10000 LIKE t10;
+ALTER TABLE t10000 ENGINE=MYISAM;
 INSERT INTO t10000(I,J)
-SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-WHERE X.J<50;
-INSERT INTO t10000(I,J)
-SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-WHERE X.J>=50;
+SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y;
+ALTER TABLE t10000 ENGINE=NDBCLUSTER;
 ANALYZE TABLE t10,t100,t10000;
 Table	Op	Msg_type	Msg_text
 test.t10	analyze	status	OK

=== modified file 'mysql-test/suite/ndb/t/ndb_index_stat_enable.inc'
--- a/mysql-test/suite/ndb/t/ndb_index_stat_enable.inc	2011-07-02 07:05:32 +0000
+++ b/mysql-test/suite/ndb/t/ndb_index_stat_enable.inc	2012-02-01 11:12:24 +0000
@@ -30,8 +30,11 @@ if ($is_enable_off)
   eval set @@global.ndb_index_stat_enable = 0;
 
   # stats thread does not (and must not) drop stats tables
-  eval drop table mysql.ndb_index_stat_sample;
-  eval drop table mysql.ndb_index_stat_head;
+  if ($is_table_exists)
+  {
+    eval drop table mysql.ndb_index_stat_sample;
+    eval drop table mysql.ndb_index_stat_head;
+  }
 }
 
 --echo # ndb_index_stat_enable - after

=== modified file 'mysql-test/suite/ndb/t/ndb_statistics.inc'
--- a/mysql-test/suite/ndb/t/ndb_statistics.inc	2011-07-02 07:05:32 +0000
+++ b/mysql-test/suite/ndb/t/ndb_statistics.inc	2012-02-01 10:23:10 +0000
@@ -21,14 +21,12 @@ INSERT INTO t100(I,J)
 
 CREATE TABLE t10000 LIKE t10;
 
-# Insert into t10000 in two chunks to not
-#  exhaust MaxNoOfConcurrentOperations
+# Insert into t10000 into myisam and alter to ndb
+#  not to exhaust MaxNoOfConcurrentOperations
+ALTER TABLE t10000 ENGINE=MYISAM;
 INSERT INTO t10000(I,J)
-  SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-  WHERE X.J<50;
-INSERT INTO t10000(I,J)
-  SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y
-  WHERE X.J>=50;
+  SELECT X.J, X.J+(100*Y.J) FROM t100 AS X,t100 AS Y;
+ALTER TABLE t10000 ENGINE=NDBCLUSTER;
 
 ANALYZE TABLE t10,t100,t10000;
 

=== modified file 'mysql-test/suite/ndb/t/ndb_statistics0.test'
--- a/mysql-test/suite/ndb/t/ndb_statistics0.test	2011-07-02 07:05:32 +0000
+++ b/mysql-test/suite/ndb/t/ndb_statistics0.test	2012-02-01 11:12:24 +0000
@@ -1,6 +1,7 @@
 # index stats OFF
 
 set @is_enable_default = @@global.ndb_index_stat_enable;
+let is_table_exists = `select count(*) <> 2 from information_schema.tables where table_name in ('ndb_index_stat_head', 'ndb_index_stat_sample') and table_schema='mysql'`;
 
 set @is_enable = 0;
 source ndb_index_stat_enable.inc;

=== modified file 'mysql-test/suite/ndb/t/ndb_statistics1.test'
--- a/mysql-test/suite/ndb/t/ndb_statistics1.test	2011-07-02 07:05:32 +0000
+++ b/mysql-test/suite/ndb/t/ndb_statistics1.test	2012-02-01 11:12:24 +0000
@@ -1,6 +1,7 @@
 # index stats ON
 
 set @is_enable_default = @@global.ndb_index_stat_enable;
+let is_table_exists = `select count(*) <> 2 from information_schema.tables where table_name in ('ndb_index_stat_head', 'ndb_index_stat_sample') and table_schema='mysql'`;
 
 set @is_enable = 1;
 source ndb_index_stat_enable.inc;

No bundle (reason: useless for push emails).