--source include/master-slave.inc

--source include/have_aria.inc

--connection master

USE test;

# No replication error with MyISAM and InnoDB

# Need ROW_FORMAT DYNAMIC for replication error

CREATE TABLE t9 (`col_int_nokey` SMALLINT UNSIGNED DEFAULT 0 ) ROW_FORMAT DYNAMIC ENGINE=Aria;

LOCK TABLE t9 WRITE;

INSERT INTO t9 () VALUES (),(),();

FLUSH TABLES;

ALTER TABLE t9 ADD UNIQUE (`col_int_nokey`), ALGORITHM=COPY;

# or fails with the following in bb-11.0-oalter (1d16113)

# ALTER ONLINE TABLE t9 ADD UNIQUE (`col_int_nokey`);

--connection slave

--connection master

DROP table t9;

--source include/rpl_end.inc

Last_SQL_Errno	1062

Last_SQL_Error	Error 'Duplicate entry '0' for key 'col_int_nokey'' on query. Default database: 'test'. Query: 'ALTER TABLE t9 ADD UNIQUE (`col_int_nokey`), ALGORITHM=COPY'

...

Wrong value for Last_SQL_Errno. Expected '0', got '1062'