2
# Test of auto_increment
5
# Bug reported that master and slave get out of sync after TRUNCATE
8
# Test supplied by Are Casilla
10
source include/master-slave.inc;
13
drop database if exists test1;
15
create database test1;
19
`id` int(10) unsigned NOT NULL auto_increment,
20
`fname` varchar(100) default NULL,
22
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
24
INSERT INTO `t1` VALUES (1, 'blablabla');
27
`id` int(10) NOT NULL auto_increment,
28
`comment` varchar(255) NOT NULL default '',
30
) ENGINE=MyISAM AUTO_INCREMENT=3 ;
32
INSERT INTO `t2` VALUES (1, 'testtest 1');
33
INSERT INTO `t2` VALUES (2, 'test 2');
36
CREATE PROCEDURE simpleproc3 ()
39
INSERT INTO t1 (fname) (SELECT t2.comment FROM t2 WHERE t2.id = '1');
40
INSERT INTO t1 (fname) VALUES('test');