Debian Codegraph @

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

raw
1 --source include/not_group_replication_plugin.inc
2 -- source include/have_binlog_format_row.inc
3 -- source include/master-slave.inc
4
5 #
6 # BUG#51716: Char column with utf16 character set gives wrong padding on slave
7 #
8
9 CREATE TABLE t1(c1 CHAR(10) CHARACTER SET utf16 DEFAULT 'ola');
10 INSERT INTO t1 VALUES ('abc'); # explicit value is inserted and encoded correctly
11 INSERT INTO t1 VALUES (); # default value is inserted and encoded correctly
12
13 -- echo #### ON MASTER
14 --query_vertical SELECT c1, hex(c1) from t1
15
16 --source include/sync_slave_sql_with_master.inc
17
18 -- echo #### ON SLAVE
19 --query_vertical SELECT c1, hex(c1) FROM t1
20
21 # assertion: tables don't differ
22 -- let $diff_tables=master:t1,slave:t1
23 -- source include/diff_tables.inc
24
25 --connection master
26 DROP TABLE t1;
27
28 --source include/rpl_end.inc