1 include/master-slave.inc
3 CALL mtr.add_suppression('Statement may not be safe to log in statement format.');
4 create table t1 (a int not null auto_increment primary key, b int, key(b));
5 INSERT INTO t1 (a) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
6 INSERT INTO t1 (a) SELECT null FROM t1;
7 INSERT INTO t1 (a) SELECT null FROM t1;
8 INSERT INTO t1 (a) SELECT null FROM t1;
9 INSERT INTO t1 (a) SELECT null FROM t1;
10 INSERT INTO t1 (a) SELECT null FROM t1;
11 INSERT INTO t1 (a) SELECT null FROM t1;
12 INSERT INTO t1 (a) SELECT null FROM t1;
13 INSERT INTO t1 (a) SELECT null FROM t1;
14 INSERT INTO t1 (a) SELECT null FROM t1;
15 INSERT INTO t1 (a) SELECT null FROM t1;
16 INSERT INTO t1 (a) SELECT null FROM t1;
17 INSERT INTO t1 (a) SELECT null FROM t1;
18 INSERT INTO t1 (a) SELECT null FROM t1;
19 update t1 set b=(a/2*rand());
20 delete from t1 order by b limit 10000;
22 Table Op Msg_type Msg_text
23 test.t1 optimize status OK