1# 2# MDEV-5867 ALTER TABLE t1 ENGINE=InnoDB keeps bad options when t1 ENGINE is CONNECT 3# 4# verify that SHOW CREATE TABLE hides unknown options when IGNORE_BAD_TABLE_OPTIONS is not set 5 6--source include/have_example_plugin.inc 7--source include/not_embedded.inc 8 9install soname 'ha_example'; 10 11set sql_mode='ignore_bad_table_options'; 12create table t1 ( 13 a int complex='c,f,f,f' invalid=3 14) engine=example ull=10000 str='dskj' one_or_two='one' yesno=0 15 foobar=barfoo; 16 17create table t2 (a int, key (a) some_option=2014); 18 19show create table t1; 20show create table t2; 21 22set sql_mode=''; 23 24show create table t1; 25show create table t2; 26 27drop table t1, t2; 28 29uninstall soname 'ha_example'; 30 31