~drizzle-trunk/drizzle/development

#

# 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;