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