← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/rpl_many_optimize.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/rpl_many_optimize.test
 
1
# Test for BUG#7658 "optimize crashes slave thread (1 in 1000)]"
 
2
 
 
3
source include/master-slave.inc;
 
4
 
 
5
create table t1 (a int not null auto_increment primary key, b int, key(b));
 
6
INSERT INTO t1 (a) VALUES (1),(2);
 
7
# Now many OPTIMIZE to test if we crash (BUG#7658)
 
8
let $1=300;
 
9
disable_query_log;
 
10
disable_result_log;
 
11
while ($1)
 
12
{
 
13
 eval OPTIMIZE TABLE t1;
 
14
 dec $1;
 
15
}
 
16
enable_result_log;
 
17
enable_query_log;
 
18
drop table t1;
 
19
# Bug was that slave segfaulted after ~ a hundred of OPTIMIZE (or ANALYZE)
 
20
sync_slave_with_master;
 
21
 
 
22
# End of 4.1 tests