#
# Bug#69680
# Auto_inc value not properly generated with RBR and auto_inc column only on slave

#
## ./mysql-test-run.pl --mysqld=--binlog-format=row 69680

    
--source include/master-slave.inc

--connection master

select @@binlog_format;
select @@sql_mode;

--disable_warnings
DROP TABLE IF EXISTS `tbl`;
--enable_warnings

CREATE TABLE `tbl` (`a` int(11) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `tbl`(a) VALUES (1), (2), (4), (8);


SELECT * FROM `tbl`;

--connection slave

select @@binlog_format;
select @@sql_mode;

SELECT * FROM `tbl`;
ALTER TABLE `tbl` ADD COLUMN i int(11) NOT NULL auto_increment primary key;

--connection master
--echo # Master - Insert 16

INSERT INTO `tbl`(a) VALUES(16);
SELECT * FROM `tbl`;

--connection slave
--echo # On slave
SELECT * FROM `tbl`;

--connection master
--echo # Master Insert 24
INSERT INTO `tbl`(a) VALUES(24);


--connection slave
SHOW SLAVE STATUS;

# Cleanup..