bzr commit into mysql-5.1-telco-7.0 branch (magnus.blaudd:3136)

[Magnus Blåudd]

#At file:///home/msvensson/mysql/bug37983/7.0/ based on revid:magnus.blaudd@stripped57-wkogm56zsvivswwl

 3136 Magnus Blåudd	2009-10-19 [merge]
      Merge

    added:
      mysql-test/suite/ndb_team/t/bug37983.cnf
      mysql-test/suite/ndb_team/t/bug37983.test
=== added file 'mysql-test/suite/ndb_team/t/bug37983.cnf'
--- a/mysql-test/suite/ndb_team/t/bug37983.cnf	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/ndb_team/t/bug37983.cnf	2009-10-19 20:20:39 +0000
@@ -0,0 +1,19 @@
+!include include/default_mysqld.cnf
+!include include/default_ndbd.cnf
+
+[cluster_config]
+DataMemory=                    500M
+IndexMemory=                   50M
+FragmentLogFileSize=           256M
+RedoBuffer=                    32M
+
+[cluster_config.1]
+NoOfReplicas=                  2
+ndbd=,
+ndb_mgmd=
+mysqld=
+
+[mysqld]
+# Make all mysqlds use cluster
+ndbcluster
+

=== added file 'mysql-test/suite/ndb_team/t/bug37983.test'
--- a/mysql-test/suite/ndb_team/t/bug37983.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/ndb_team/t/bug37983.test	2009-10-19 20:20:39 +0000
@@ -0,0 +1,37 @@
+source include/have_ndb.inc;
+
+CREATE TABLE `t1` (
+`c1` int(11) NOT NULL AUTO_INCREMENT,
+`c3` text,
+PRIMARY KEY (`c1`) USING BTREE
+) ENGINE=ndbcluster DEFAULT CHARSET=utf8;
+
+disable_query_log;
+let $i=1000;
+while ($i)
+{
+  let $j = 200;
+  let $separator = ;
+  let $sql = INSERT t1 (c3) VALUES;
+  while($j)
+  {
+    let $sql=$sql$separator(REPEAT('ks87', 512*RAND()));
+    dec $j;
+    let $separator = ,;
+  }
+  eval $sql;
+  dec $i;
+}
+enable_query_log;
+
+select count(*) from t1;
+
+set @start = now();
+select BENCHMARK(5, (select count(*) from t1 where length(c3) < 256));
+set @end = now();
+select TIMESTAMPDIFF(MICROSECOND, @start, @end);
+select TIMEDIFF(@end, @start);
+
+drop table t1;
+
+exit;

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