Debian Codegraph @

mysql-test/suite/rpl/t/rpl_table_options.test

raw
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/
6 eval install plugin example soname '$HA_EXAMPLE_SO';
7 set default_storage_engine=example;
8
9 sync_slave_with_master;
10 connection 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 #
20 create table t1 (a int not null) ull=12340;
21 alter table t1 ull=12350;
22 show create table t1;
23
24 sync_slave_with_master;
25 connection slave;
26 show create table t1;
27 set sql_mode=ignore_bad_table_options;
28 show create table t1;
29
30 connection master;
31 drop table t1;
32 set default_storage_engine=default;
33 select 1;
34
35 # Cleanup
36 uninstall plugin example;
37
38 --source include/rpl_end.inc