1--source include/not_windows_embedded.inc 2--source include/have_example_plugin.inc 3--source include/master-slave.inc 4 5--replace_regex /\.dll/.so/ 6eval install plugin example soname '$HA_EXAMPLE_SO'; 7set storage_engine=example; 8 9sync_slave_with_master; 10connection master; 11 12# 13# only master has example engine installed, 14# the slave will have the table created in myisam, 15# that does not have ULL table option. 16# but because the table was created by the replication 17# slave thread, the table will be created anyway, even if 18# the option is unknown. 19# 20create table t1 (a int not null) ull=12340; 21alter table t1 ull=12350; 22show create table t1; 23 24sync_slave_with_master; 25connection slave; 26show create table t1; 27set sql_mode=ignore_bad_table_options; 28show create table t1; 29 30connection master; 31drop table t1; 32set storage_engine=default; 33select 1; 34 35# Cleanup 36uninstall plugin example; 37 38--source include/rpl_end.inc 39