Test engines/funcs.db_alter_character_set is unstable

[Laurynas Biveinis]

On 5.6 trunk:

engines/funcs.db_alter_character_set w1 [ fail ]
        Test ended at 2017-05-11 13:14:50

CURRENT_TEST: engines/funcs.db_alter_character_set
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/debian-jessie-64bit/mysql-test/suite/engines/funcs/r/db_alter_character_set.result 2017-05-11 15:15:10.468000000 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/debian-jessie-64bit/build/mysql-test/var/1/log/db_alter_character_set.reject 2017-05-11 16:14:49.928000000 +0300
@@ -1,46 +1,46 @@
 DROP DATABASE IF EXISTS d8;
 SHOW CHARACTER SET;
 Charset Description Default collation Maxlen
-big5 Big5 Traditional Chinese big5_chinese_ci 2
-dec8 DEC West European dec8_swedish_ci 1
-cp850 DOS West European cp850_general_ci 1
-hp8 HP West European hp8_english_ci 1
-koi8r KOI8-R Relcom Russian koi8r_general_ci 1
-latin1 cp1252 West European latin1_swedish_ci 1
-latin2 ISO 8859-2 Central European latin2_general_ci 1
-swe7 7bit Swedish swe7_swedish_ci 1
-ascii US ASCII ascii_general_ci 1
-ujis EUC-JP Japanese ujis_japanese_ci 3
-sjis Shift-JIS Japanese sjis_japanese_ci 2
-hebrew ISO 8859-8 Hebrew hebrew_general_ci 1
-tis620 TIS620 Thai tis620_thai_ci 1
-euckr EUC-KR Korean euckr_korean_ci 2
-koi8u KOI8-U Ukrainian koi8u_general_ci 1
-gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2
-greek ISO 8859-7 Greek greek_general_ci 1
-cp1250 Windows Central European cp1250_general_ci 1
-gbk GBK Simplified Chinese gbk_chinese_ci 2
-latin5 ISO 8859-9 Turkish latin5_turkish_ci 1
-armscii8 ARMSCII-8 Armenian armscii8_general_ci 1
-utf8 UTF-8 Unicode utf8_general_ci 3
-ucs2 UCS-2 Unicode ucs2_general_ci 2
-cp866 DOS Russian cp866_general_ci 1
-keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1
-macce Mac Central European macce_general_ci 1
-macroman Mac West European macroman_general_ci 1
-cp852 DOS Central European cp852_general_ci 1
-latin7 ISO 8859-13 Baltic latin7_general_ci 1
+big5 big5_chinese_ci 2
+dec8 dec8_swedish_ci 1
+cp850 cp850_general_ci 1
+hp8 hp8_english_ci 1
+koi8r koi8r_general_ci 1
+latin1 latin1_swedish_ci 1
+latin2 latin2_general_ci 1
+swe7 swe7_swedish_ci 1
+ascii ascii_general_ci 1
+ujis ujis_japanese_ci 3
+sjis sjis_japanese_ci 2
+hebrew hebrew_general_ci 1
+tis620 tis620_thai_ci 1
+euckr euckr_korean_ci 2
+koi8u koi8u_general_ci 1
+gb2312 gb2312_chinese_ci 2
+greek greek_general_ci 1
+cp1250 cp1250_general_ci 1
+gbk gbk_chinese_ci 2
+latin5 latin5_turkish_ci 1
+armscii8 armscii8_general_ci 1
+utf8 utf8_general_ci 3
+ucs2 ucs2_general_ci 2
+cp866 cp866_general_ci 1
+keybcs2 keybcs2_general_ci 1
+macce macce_general_ci 1
+macroman macroman_general_ci 1
+cp852 cp852_general_ci 1
+latin7 latin7_general_ci 1
 utf8mb4 UTF-8 Unicode utf8mb4_general_ci 4
-cp1251 Windows Cyrillic cp1251_general_ci 1
+cp1251 cp1251_general_ci 1
 utf16 UTF-16 Unicode utf16_general_ci 4
 utf16le UTF-16LE Unicode utf16le_general_ci 4
-cp1256 Windows Arabic cp1256_general_ci 1
-cp1257 Windows Baltic cp1257_general_ci 1
+cp1256 cp1256_general_ci 1
+cp1257 cp1257_general_ci 1
 utf32 UTF-32 Unicode utf32_general_ci 4
-binary Binary pseudo charset binary 1
-geostd8 GEOSTD8 Georgian geostd8_general_ci 1
-cp932 SJIS for Windows Japanese cp932_japanese_ci 2
-eucjpms UJIS for Windows Japanese eucjpms_japanese_ci 3
+binary binary 1
+geostd8 geostd8_general_ci 1
+cp932 cp932_japanese_ci 2
+eucjpms eucjpms_japanese_ci 3
 CREATE DATABASE d8;
 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

Diagnostics added at https://github.com/percona/percona-server/pull/1766, https://github.com/percona/percona-server/pull/1767

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2274