summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/t/rpl_row_utf16.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_row_utf16.test')
-rw-r--r--mysql-test/suite/rpl/t/rpl_row_utf16.test26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_row_utf16.test b/mysql-test/suite/rpl/t/rpl_row_utf16.test
new file mode 100644
index 00000000..d5dcdc42
--- /dev/null
+++ b/mysql-test/suite/rpl/t/rpl_row_utf16.test
@@ -0,0 +1,26 @@
+-- source include/have_binlog_format_row.inc
+-- source include/have_utf16.inc
+-- source include/master-slave.inc
+
+#
+# BUG#51716: Char column with utf16 character set gives wrong padding on slave
+#
+
+CREATE TABLE t1(c1 CHAR(10) CHARACTER SET utf16 DEFAULT 'ola');
+INSERT INTO t1 VALUES ('abc'); # explicit value is inserted and encoded correctly
+INSERT INTO t1 VALUES (); # default value is inserted and encoded correctly
+
+--query_vertical SELECT c1, hex(c1) from t1
+
+-- sync_slave_with_master
+
+--query_vertical SELECT c1, hex(c1) FROM t1
+
+# assertion: tables don't differ
+-- let $diff_tables=master:t1,slave:t1
+-- source include/diff_tables.inc
+
+--connection master
+DROP TABLE t1;
+
+--source include/rpl_end.inc