rpl_auto_increment_11932.test

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· TEST 代码 · 共 64 行

#
# Test of auto_increment
# BUG#11932
#
# Bug reported that master and slave get out of sync after TRUNCATE
# TABLE.
#
# Test supplied by Are Casilla

source include/master-slave.inc;
--disable_warnings
connection master;
drop database if exists test1;
--enable_warnings
create database test1;
use test1;

CREATE TABLE `t1` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fname` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `t1` VALUES (1, 'blablabla');

CREATE TABLE `t2` (
  `id` int(10) NOT NULL auto_increment,
  `comment` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  AUTO_INCREMENT=3 ;

INSERT INTO `t2` VALUES (1, 'testtest 1');
INSERT INTO `t2` VALUES (2, 'test 2');
  
DELIMITER $;
CREATE PROCEDURE simpleproc3 ()
    NOT DETERMINISTIC
    BEGIN
    INSERT INTO t1 (fname) (SELECT t2.comment FROM t2 WHERE t2.id = '1');
    INSERT INTO t1 (fname) VALUES('test');
    END
    $
DELIMITER ;$

CALL simpleproc3();

select * from t2;

TRUNCATE TABLE `t1`;
CALL simpleproc3();

select * from t1;

save_master_pos;
connection slave;
sync_with_master;

use test1;
select * from t1;

drop database test1;
connection master;
drop database test1;