File: rpl_free_items.test

package info (click to toggle)
mysql-dfsg 4.0.24-10sarge3
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 56,212 kB
  • ctags: 42,312
  • sloc: ansic: 257,918; cpp: 93,002; perl: 29,480; sh: 24,628; tcl: 19,882; yacc: 3,558; makefile: 2,452; java: 2,300; awk: 1,484; asm: 687; sed: 428; sql: 27
file content (20 lines) | stat: -rw-r--r-- 469 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
source include/master-slave.inc;
create table t1 (a int);
create table t2 (a int);
disable_query_log;
SET @query="INSERT INTO t2 SELECT * FROM t1 WHERE a REGEXP \"0\"";
let $1 = 2000;
while ($1)
{
  eval SET @query=concat(@query, " OR  a REGEXP '$1'");
  dec $1;
}
let $1=`select @query`;
eval $1;
enable_query_log;
# I have seen the slave crash either now or at shutdown
sync_slave_with_master;
connection master;
drop table t1;
drop table t2;
sync_slave_with_master;