Debian Codegraph @

mysql-test/suite/rpl/t/rpl_auto_increment_11932.test

raw
1 #
2 # Test of auto_increment
3 # BUG#11932
4 #
5 # Bug reported that master and slave get out of sync after TRUNCATE
6 # TABLE.
7 #
8 # Test supplied by Are Casilla
9
10 source include/master-slave.inc;
11 call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
12 --disable_warnings
13 connection master;
14 drop database if exists test1;
15 --enable_warnings
16 create database test1;
17 use test1;
18
19 CREATE TABLE `t1` (
20 `id` int(10) unsigned NOT NULL auto_increment,
21 `fname` varchar(100) default NULL,
22 PRIMARY KEY (`id`)
23 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
24
25 INSERT INTO `t1` VALUES (1, 'blablabla');
26
27 CREATE TABLE `t2` (
28 `id` int(10) NOT NULL auto_increment,
29 `comment` varchar(255) NOT NULL default '',
30 PRIMARY KEY (`id`)
31 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
32
33 INSERT INTO `t2` VALUES (1, 'testtest 1');
34 INSERT INTO `t2` VALUES (2, 'test 2');
35
36 DELIMITER $;
37 CREATE PROCEDURE simpleproc3 ()
38 NOT DETERMINISTIC
39 BEGIN
40 INSERT INTO t1 (fname) (SELECT t2.comment FROM t2 WHERE t2.id = '1');
41 INSERT INTO t1 (fname) VALUES('test');
42 END
43 $
44 DELIMITER ;$
45
46 --disable_warnings
47 CALL simpleproc3();
48 --enable_warnings
49
50 select * from t2;
51
52 TRUNCATE TABLE `t1`;
53 --disable_warnings
54 CALL simpleproc3();
55 --enable_warnings
56
57 select * from t1;
58
59 sync_slave_with_master;
60
61 use test1;
62 select * from t1;
63
64 connection master;
65 drop database test1;
66 --source include/rpl_end.inc