summaryrefslogtreecommitdiff
path: root/mysql-test/extra/rpl_tests/rpl_special_charset.inc
blob: 51119b319d712bc7d2ccc9254db883aaef167820 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#
# This include file is used by more than one test suite
# (currently rpl and binlog_encryption).
# Please check all dependent tests after modifying it
#

################################################################################
# Bug#19855907 IO THREAD AUTHENTICATION ISSUE WITH SOME CHARACTER SETS
# Problem: IO thread fails to connect to master if servers are configured with
#  special character sets like utf16, utf32, ucs2.
#
# Analysis: MySQL server does not support few special character sets like
#  utf16,utf32 and ucs2 as "client's character set"(eg: utf16,utf32, ucs2).
#  When IO thread is trying to connect to Master, it sets server's character
#  set as client's character set. When Slave server is started with these
#  special character sets, IO thread (a connection to Master) fails because
#  of the above said reason.
#
# Fix: If server's character set is not supported as client's character set,
#  then set default's client character set(latin1) as client's character set.
###############################################################################
--source include/master-slave.inc
call mtr.add_suppression("Cannot use utf16 as character_set_client");
CREATE TABLE t1(i VARCHAR(20));
INSERT INTO t1 VALUES (0xFFFF);
--sync_slave_with_master
--let diff_tables=master:t1, slave:t1
--source include/diff_tables.inc
# Cleanup
--connection master
DROP TABLE t1;
--source include/rpl_end.inc