Debian Codegraph @

mysql-test/suite/rpl/r/rpl_table_options.result

raw
1 include/master-slave.inc
2 [connection master]
3 install plugin example soname 'ha_example.so';
4 set default_storage_engine=example;
5 connection slave;
6 connection master;
7 create table t1 (a int not null) ull=12340;
8 alter table t1 ull=12350;
9 Warnings:
10 Note 1105 EXAMPLE DEBUG: ULL 12340 -> 12350
11 show create table t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `a` int(11) NOT NULL
15 ) ENGINE=EXAMPLE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `ull`=12350
16 connection slave;
17 connection slave;
18 show create table t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `a` int(11) NOT NULL
22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci /* `ull`=12350 */
23 set sql_mode=ignore_bad_table_options;
24 show create table t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `a` int(11) NOT NULL
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `ull`=12350
29 connection master;
30 drop table t1;
31 set default_storage_engine=default;
32 select 1;
33 1
34 1
35 uninstall plugin example;
36 include/rpl_end.inc