Hi, in dev-db/percona-server-5.6.28.76.1 the "main.ctype_ucs" test is failing: main.ctype_ucs w1 [ fail ] Test ended at 2016-01-24 11:35:06 CURRENT_TEST: main.ctype_ucs --- /var/tmp/portage/dev-db/percona-server-5.6.28.76.1/work/mysql/mysql-test/r/ctype_ucs.result 2016-01-09 01:12:24.000000000 +0300 +++ /var/tmp/portage/dev-db/percona-server-5.6.28.76.1/temp/var-tests/1/log/ctype_ucs.reject 2016-01-24 13:35:05.9534 59808 +0300 @@ -200,11 +200,14 @@ CREATE TABLE t1(a INT); LOAD DATA INFILE 'tmpp.txt' INTO TABLE t1 CHARACTER SET ucs2 (@b) SET a=REVERSE(@b); +Warnings: +Warning 1366 Incorrect integer value: '?' for column 'a' at row 1 +Warning 1366 Incorrect integer value: '?' for column 'a' at row 2 # should return 2 zeroes (as the value is truncated) SELECT * FROM t1; a 0 -1 +0 DROP TABLE t1; # Problem # 2 : if you write and read ucs2 data to a file they're lost SELECT '00' UNION SELECT '10' INTO OUTFILE 'tmpp2.txt' CHARACTER SET ucs2; mysqltest: Result content mismatch - saving '/var/tmp/portage/dev-db/percona-server-5.6.28.76.1/temp/var-tests/1/log/main.ctype_ucs/' to '/var/tmp/portage/dev-db/percona-server-5.6.28.76.1/temp/var-tests/log/main.ctype_ucs/' This is upstream issue https://bugs.launchpad.net/percona-server/+bug/1534246 Fixed with https://patch-diff.githubusercontent.com/raw/percona/percona-server/pull/315.patch
