--source include/master-slave.inc

--connection master

 SET ALTER_ALGORITHM= COPY ;

CREATE /* QNO 17 CON_ID 6 */ TABLE AA (

                pk INTEGER AUTO_INCREMENT,

                col_int_nokey INTEGER /*! NULL */,

                col_int_key INTEGER,

                col_date_key DATE,

                col_date_nokey DATE /*! NULL */,

                col_time_key TIME,

                col_time_nokey TIME /*! NULL */,

                col_datetime_key DATETIME,

                col_datetime_nokey DATETIME /*! NULL */,

                col_varchar_key VARCHAR(1),

                col_varchar_nokey VARCHAR(1) /*! NULL */,

                PRIMARY KEY (pk),

                KEY (col_int_key ASC),

                KEY (col_date_key DESC),

                KEY (col_time_key DESC),

                KEY (col_datetime_key ASC),

                KEY (col_varchar_key, col_int_key DESC)

            )  AUTO_INCREMENT=10 ENGINE=MyISAM;

--sync_slave_with_master

--connection master

ALTER  TABLE `AA`  NOWAIT  ADD COLUMN IF NOT EXISTS ( icol9 TINYINT UNSIGNED NOT NULL DEFAULT 9 ), ALGORITHM=COPY, LOCK=EXCLUSIVE, DROP COLUMN IF EXISTS icol9 , ALGORITHM=NOCOPY;

--connection slave

--let $show_slave_sql_error=1

--let $slave_sql_errno=1845

--source include/wait_for_slave_sql_error.inc

# --connection master

#  DROP TABLE AA;

# --sync_slave_with_master

# --source include/rpl_end.inc