WL#10298: Change runtime tests to run with new default charset

Affects: Server-8.0 — Status: Complete

WL#9125 added a new utf8mb4 collation, utf8mb4_800_ci_ai, which implemented the latest UCA (Unicode Collation Algorithm), UCA8.0.0. MySQL will use utf8mb4 as the new default character set. Most of the existing test cases assume the default character set is latin1 and default collation is latin1_swedish_ci. These tests either need to be recorded again or modified accordingly to run with the new default value, or made to run with latin1 if they cannot run with utf8mb4.

User Documentation

Work was done for test suite. No user documentation needed.

The low level design specification contains the list of all the failing tests. These tests need to modified to successfully run with the new default charset. The following MTR setting can be made:

In the mysql-test/include/default_mysqld.cnf, the following setting needs to be added: character-set-server= utf8mb4

And in mysql-test/include/default_client.cnf replace all instances of default-character-set=latin1 with default-character-set=utf8mb4.

S.No	Test name	Reason of failure	Details	Developer Notes
1	funcs_1.memory_storedproc_08	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
2	funcs_1.memory_trig_03e	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
3	funcs_1.innodb_storedproc_07	Result content mismatch	Mismatch in the collation. Result needs to be updated.	Fixed on trunk. Bug #25574867
4	funcs_1.innodb_storedproc_08	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
5	funcs_1.innodb_trig_03e	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
6	funcs_1.myisam_storedproc_07	Result content mismatch	Mismatch in the collation. Result needs to be updated.	Fixed on trunk. Bug #25574867
7	funcs_1.myisam_storedproc_08	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
8	funcs_1.myisam_trig_03e	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
9	funcs_1.is_columns	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
10	funcs_1.is_columns_innodb	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
11	funcs_1.is_columns_memory	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
12	funcs_1.is_columns_myisam	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
13	funcs_1.is_routines	Result content mismatch	Mismatch in the Database collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
14	funcs_1.is_schemata	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
15	funcs_1.is_tables	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
16	funcs_1.is_tables_innodb	Result content mismatch	Mismatch in the table collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
17	funcs_1.is_tables_memory	Result content mismatch	Mismatch in the table collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
18	funcs_1.is_tables_myisam	Result content mismatch	Mismatch in the table collation value. Result needs to be updated.	Fixed on trunk. Bug #25574867
19	funcs_1.is_triggers	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
20	funcs_1.memory_storedproc_07	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
21	funcs_1.storedproc	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
22	funcs_1.is_columns_ci	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
23	funcs_1.is_schemata_ci	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
24	funcs_1.is_tables_ci	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed on trunk. Bug #25574867
26	main.dd_upgrade_test	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
27	main.schema	Result content mismatch	Mismatch in the charset value printed by the SHOW CREATE SCHEMA. Result needs to be updated.	Result recorde
28	main.dd_is_gcov	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
29	main.upgrade	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
30	main.information_schema_parameters	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Result recorded
31	main.information_schema_routines	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Result recorded
32	main.trigger	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
33	main.schema_not_embedded	Result content mismatch	Mismatch in the charset value printed by the SHOW CREATE SCHEMA. Result needs to be updated.	Fixed with --record on WL#7554 branch
34	i_main.lowercase_table-bug18790730	Result content mismatch	Mismatch in the charset value printed by the SHOW CREATE TABLE. Result needs to be updated.	Fixed with --record on WL#7554 branch
35	i_main.foreign_key-bug18790730	Result content mismatch	Mismatch in the charset value printed by the SHOW CREATE TABLE. Result needs to be updated.	Fixed with --record on WL#7554 branch
36	main.events_1	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
37	main.events_2	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
38	main.mysqldump	Result content mismatch	Mismatch in charset, result needs to be verified and updated.	Result recorded
39	main.trigger_notembedded	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Result recorded
40	main.mysql_comments	Result content mismatch	Mismatch in charset values. Result needs to be updated.	Result recorded
41	main.events_bugs	Result content mismatch	Mismatch in charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
42	main.ps	Result content mismatch	Mismatch in charset value. Result needs to be updated.	Fixed with --record on WL#7554 branch
43	main.lowercase_table	Result content mismatch	Mismatch in the charset printed by SHOW CREATE DATABASE statement. Result needs to be updated.	Fixed with --record on WL#7554 branch
44	engines/funcs.db_alter_character_set	Result content mismatch	Mismatch in charset value. Result needs to be updated.	Result recorded
45	engines/funcs.tc_rename_across_database	Result content mismatch	Mismatch in the charset printed by SHOW CREATE TABLE statement. Result needs to be updated.	Result recorded
46	federated.federated	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with test modifications
47	main.sp-lock	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
48	funcs_1.innodb_trig_1011ext	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
49	funcs_1.memory_trig_1011ext	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
50	funcs_1.myisam_trig_1011ext	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
51	main.ps_3innodb	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
52	main.type_timestamp_explicit	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
53	main.type_timestamp	Result content mismatch	Mismatch in the charset value. result needs to be updated.	create table was done with utf8 before switch, now it's removed because utf8 is default.
54	i_main.type_timestamp2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	create table was done with utf8 before switch, now it's removed because utf8 is default.
55	main.mysqldump-max	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result updated
56	main.strict	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Column changed to latin1
57	main.ps_2myisam	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
58	main.ps_4heap	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
59	main.ps_5merge	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
60	main.temp_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
61	main.func_misc	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Changed to latin1 using set names for failing testcase
62	main.schema	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result updated
63	main.type_bit_innodb	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
64	main.type_datetime	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
65	i_main.partition_data_dir	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
66	main.archive_bitfield	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
67	i_main.trigger	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
68	main.type_float	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
69	main.archive_symlink	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
70	main.type_nchar	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
71	i_main.type_timestamp	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
72	i_main.create-bug25092566	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
73	i_main.create	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
74	main.sp_notembedded	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
75	main.type_newdecimal	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
76	i_main.data_dictionary_debug	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
77	main.variables	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
78	main.type_ranges	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
79	main.type_set	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --character_set latin1 in test
80	main.type_year	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
81	main.dd_is_compatibility	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
82	main.sp-bugs	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
83	main.comment_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
84	i_main.wl4179_bugs	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
85	i_main.partition_key	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with set names latin1 in test
86	main.comment_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
87	main.comment_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
88	funcs_1.is_schemata_is_mysql_test	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
89	i_main.key-bug17665767	Result content mismatch	Mismatch in the charset value. result needs to be updated.	create table was done with utf8 before switch, now it's removed because utf8 is default.
90	i_main.key	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
91	main.sp_validation	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
92	main.partition	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
93	main.partition_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Charset changed to latin1 using set names
94	main.partition_column_prune	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
95	main.partition_error	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
96	main.partition_exchange	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
97	main.partition_hash	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
98	main.partition_innodb	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
99	main.partition_innodb_plugin	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
100	main.partition_innodb_tablespace	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
101	main.partition_list	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
102	main.information_schema_part	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
103	main.partition_mgm	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
104	main.partition_mgm_err	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
105	main.partition_not_supported	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
106	main.mdl_tablespace	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded, error message too
107	main.partition_utf8	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
108	main.symlink	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
109	main.synchronization	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
110	main.archive	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
111	i_main.ddl_binlog	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
112	main.tablespace	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
113	main.temporal_literal	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
114	main.type_bit	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
115	main.events_trans	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
116	main.ps_1general	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
117	main.trigger-compat-debug	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
118	main.truncate	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
119	main.flush_block_commit	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
120	main.sp_trans	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
121	main.foreign_key	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
122	main.foreign_key_debug	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
123	main.trigger_mdl	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
124	main.trigger_wl3253	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
125	main.create_not_windows	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
126	main.create_w_max_indexes_64	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
127	main.create-big	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
128	main.dd_is_compatibility_ci	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
129	main.lowercase_table4	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
130	main.named_pipe	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
131	main.ps_1general_ci	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
132	main.import	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
133	main.import_empty_secure_file_priv	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
134	engines/funcs.ai_init_alter_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
135	engines/funcs.ai_init_create_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
136	engines/funcs.ai_init_insert	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
137	engines/funcs.ai_init_insert_id	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
138	engines/funcs.ai_overflow_error	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
139	engines/funcs.ai_reset_by_truncate	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
140	engines/funcs.comment_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
141	engines/funcs.comment_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
142	engines/funcs.comment_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
143	engines/funcs.db_alter_character_set	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
144	engines/funcs.db_alter_character_set_collate	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
145	engines/funcs.db_alter_collate_ascii	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
146	engines/funcs.db_alter_collate_utf8	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
147	engines/funcs.db_create_character_set	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
148	engines/funcs.db_create_character_set_collate	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
149	engines/funcs.ix_index_decimals	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
150	engines/funcs.ix_index_non_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
151	engines/funcs.ix_index_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
152	engines/funcs.ix_index_string_length	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
153	engines/funcs.ix_unique_decimals	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
154	engines/funcs.ix_unique_non_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
155	engines/funcs.ix_unique_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
156	engines/funcs.ix_unique_string_length	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
157	engines/funcs.ix_using_order	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
158	engines/funcs.jp_comment_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --character_set cp932
159	engines/funcs.jp_comment_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --character_set cp932
160	engines/funcs.jp_comment_older_compatibility1	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --character_set cp932
161	engines/funcs.jp_comment_table	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --character_set cp932 in the test
162	engines/funcs.ld_unique_error3	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
163	engines/funcs.ta_2part_column_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
164	engines/funcs.ta_2part_diff_string_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
165	engines/funcs.ta_2part_diff_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
166	engines/funcs.ta_2part_string_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
167	engines/funcs.ta_3part_column_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
168	engines/funcs.ta_3part_string_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
169	engines/funcs.ta_add_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
170	engines/funcs.ta_add_column2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
171	engines/funcs.ta_add_column_first	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
172	engines/funcs.ta_add_column_first2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
173	engines/funcs.ta_add_column_middle	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
174	engines/funcs.ta_add_column_middle2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
175	engines/funcs.ta_add_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
176	engines/funcs.ta_add_string2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
177	engines/funcs.ta_add_string_first	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
178	engines/funcs.ta_add_string_first2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
179	engines/funcs.ta_add_string_middle	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
180	engines/funcs.ta_add_string_middle2	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
181	engines/funcs.ta_add_string_unique_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
182	engines/funcs.ta_add_unique_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
183	engines/funcs.ta_column_from_unsigned	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
184	engines/funcs.ta_column_from_zerofill	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
185	engines/funcs.ta_column_to_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
186	engines/funcs.ta_column_to_not_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
187	engines/funcs.ta_column_to_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
188	engines/funcs.ta_column_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
189	engines/funcs.ta_column_to_unsigned	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
190	engines/funcs.ta_column_to_zerofill	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
191	engines/funcs.ta_drop_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
192	engines/funcs.ta_drop_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
193	engines/funcs.ta_drop_pk_autoincrement	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
194	engines/funcs.ta_drop_pk_number	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
195	engines/funcs.ta_drop_pk_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
196	engines/funcs.ta_drop_string_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
197	engines/funcs.ta_orderby	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
198	engines/funcs.ta_rename	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
199	engines/funcs.ta_set_drop_default	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
200	engines/funcs.ta_string_drop_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
201	engines/funcs.ta_string_to_index	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
202	engines/funcs.ta_string_to_not_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
203	engines/funcs.ta_string_to_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
204	engines/funcs.ta_string_to_pk	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
205	engines/funcs.tc_column_autoincrement	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
206	engines/funcs.tc_column_comment	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
207	engines/funcs.tc_column_comment_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
208	engines/funcs.tc_column_default_decimal	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
209	engines/funcs.tc_column_default_number	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result number
210	engines/funcs.tc_column_default_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
211	engines/funcs.tc_column_enum	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
212	engines/funcs.tc_column_key	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
213	engines/funcs.tc_column_key_length	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
214	engines/funcs.tc_column_length	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
215	engines/funcs.tc_column_length_decimals	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
216	engines/funcs.tc_column_length_zero	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
217	engines/funcs.tc_column_not_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
218	engines/funcs.tc_column_null	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
219	engines/funcs.tc_column_primary_key_number	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
220	engines/funcs.tc_column_primary_key_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
221	engines/funcs.tc_column_serial	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
222	engines/funcs.tc_column_set	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
223	engines/funcs.tc_column_unique_key	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
224	engines/funcs.tc_column_unique_key_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
225	engines/funcs.tc_column_unsigned	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
226	engines/funcs.tc_column_zerofill	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
227	engines/funcs.tc_multicolumn_different	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
228	engines/funcs.tc_multicolumn_same	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
229	engines/funcs.tc_multicolumn_same_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
230	engines/funcs.tc_rename	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
231	engines/funcs.tc_rename_across_database	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
232	engines/funcs.tc_rename_error	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
233	engines/funcs.tc_structure_comment	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
234	engines/funcs.tc_structure_create_like	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
235	engines/funcs.tc_structure_create_like_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
236	engines/funcs.tc_structure_create_select	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
237	engines/funcs.tc_structure_create_select_string	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
238	engines/funcs.tc_structure_string_comment	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
239	engines/funcs.tc_temporary_column	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
240	engines/funcs.tc_temporary_column_length	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
241	funcs_1.is_columns_mysql	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
242	funcs_1.is_tables_mysql	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed on trunk. Bug #25574867
243	main.dd_debug_lowercase1	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Result recorded
244	main.deprecate_eof	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
245	main.events_grant	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
246	main.func_math	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
247	main.session_tracker	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
248	main.sp-error	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
249	main.sp-security	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
250	main.user_var-binlog	Result content mismatch	Mismatch in the charset value. result needs to be updated.	Fixed with --record on WL#7554 branch
251	main.events_restart	Result content mismatch	Mismatch in the charset value. Result needs to be updated.	Result recorded
252	engines/iuds.insert_calendar	Result content mismatch	Result needs to be updated	Result recorded
253	engines/iuds.strings_charsets_update_delete	Result content mismatch	Result needs to be updated	Used _latin2 to insert data
254	engines/iuds.update_delete_calendar	Result content mismatch	Result needs to be updated	Result recorded
255	funcs_1.is_views_ci	Result content mismatch	Result needs to be updated	Result recorded
256	funcs_1.is_views	Result content mismatch	Result needs to be updated	Result recorded
257	main.dd_column_and_index_name_collation	Query failed	Duplicate column name	Set names latin1
258	main.information_schema_db	Result content mismatch	Result needs to be updated	Result recorded
259	main.lowercase_view	Result content mismatch	Result needs to be updated	Result recorded
260	main.metadata	Result content mismatch	Result needs to be updated	Result recorded
261	main.multi_update2	Result content mismatch	Result needs to be updated	Passes now
262	main.ps_ddl	Result content mismatch	Result needs to be updated	Result recorded
263	main.signal	Result content mismatch	Result needs to be updated	Result recorded
264	main.type_date	Result content mismatch	Result needs to be updated	Result recorded
265	main.view_alias	Result content mismatch	Result needs to be updated	Result recorded
266	main.view_grant	Result content mismatch	Result needs to be updated	Result recorded

The following tests need further analysis:

S.No	Test name	Reason of failure	Details	Developer Notes
1	i_main.mysqlshow	Result content mismatch	Mismatch in the characters. Needs to be looked at.	Result recorded
2	main.merge	Result content mismatch	Mismatch in EXPLAIN output	Result recorded
3	main.show_check_ci	Result content mismatch	Mismatch in charset and in length too. Need to verify the results.	Result recorded
4	main.mysql_client_test	Result content mismatch	Mismatch in result	Result recorded
5	main.sp	Result content mismatch	Mismatch in the charset, and in the characters. Verification of result needed.	Fixed with --record on WL#7554 branch
6	main.invalid_collation	Warnings or errors	Server warning: './test/t1' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed	Fixed in Bug#25604702
8	main.show_check	Result content mismatch	Mismatch in charset and length. Verification of results needed.	Fixed with --record on WL#7554 branch
9	main.create	Query failed	CREATE TABLE failed with wrong errno. Column length too big	Fixed with --record on WL#7554 branch
10	main.information_schema	Query failed	CREATE FUNCTION failed. Column length too big	Result recorded
11	main.information_schema_ci	Query failed	CREATE FUNCTION failed. Column length too big	Result recorded
12	main.mix2_myisam	Query failed	CREATE TABLE failed because specified key was too long	Tables created with latin1
13	funcs_1.innodb_func_view	Result content mismatch	Mismatch in warnings	Fixed on trunk. Bug #25574867
14	funcs_1.memory_views	Result content mismatch	Mismatch in order of the result	Fixed on trunk. Bug #25574867
15	funcs_1.myisam_func_view	Query failed	CREATE TABLE failed because specified key was too long	Fixed on trunk. Bug #25574867
16	main.alter_table	Query failed	ALTER TABLE failed, incorrect prefix key	Tables created with charset latin1
17	main.index_merge_myisam	Query failed	SELECT failed. Out of sort memory	Table created with latin1
18	main.type_enum	Server crash	bool dd::Raw_record::store(int, const String_type&, bool): Assertion `rc == TYPE_OK' failed	Fixed with --character_set latin1 in the test
19	i_main.partition_icp	Result content mismatch	Mismatch in the EXPLAIN output	Create table with latin1
20	funcs_1.innodb_views	Result content mismatch	Mismatch in the order of the result	Fixed on trunk. Bug #25574867
21	i_main.partition_innodb	Result content mismatch	Mismatch in the EXPLAIN output	Result recorded
22	i_main.group_by	Result content mismatch	Mismatch in the EXPLAIN output	Create table was done with utf8mb4 prior to the switch, and now that is removed as utf8mb4 is the default.
23	i_main.handler_read	Query failed	Query HANDLER failed. Illegal mix of collations	Create table with latin1
24	main.type_temporal_fractional	Query failed	Query SELECT failed. Illegal mix of collations	Result recorded
25	main.view	Query failed	CREATE VIEW failed. COLLATION 'latin1_german1_ci' is not valid for CHARACTER SET 'utf8mb4'	Result recorded, create some tables with latin1
26	main.compress	Result content mismatch	Mismatch in the EXPLAIN output	Result recorded
27	main.sql_mode	Result content mismatch	Mismatch in the result	some tables created with latin1
28	main.partition_datatype	Query failed	CREATE TABLE failed. The total length of the partitioning fields is too large	Tables created with latin1
29	funcs_1.memory_func_view	Result content mismatch	Mismatch in the warnings and results	Fixed on trunk. Bug #25574867
30	main.partition_explicit_prune	Result content mismatch	Mismatch in the results	Some tables created with latin1
31	funcs_1.myisam_views-big	Result content mismatch	Mismatch in the results	Fixed on trunk. Bug #25574867
32	main.partition_locking	Result content mismatch	Mismatch in the EXPLAIN output	Create table with latin1
33	main.partition_myisam	Result content mismatch	Mismatch in the results	Result recorded
34	main.type_varchar	Query failed	CREATE TABLE failed because the specified key was too long	Tables created with latin1
35	main.repair	Query failed	CREATE TABLE failed because the specified key was too long	Tables created with latin1
36	main.ps_w_max_indexes_64	Result content mismatch	Difference in order of results	Result recorded
37	i_main.alter_table	Query failed	CREATE INDEX failed. BLOB/TEXT column 'a' used in key specification without a key length	table created with latin1
38	main.shm	Result content mismatch	Mismatch in EXPLAIN output	Result recorded
39	engines/funcs.crash_manycolumns_string	Query failed	CREATE TABLE failed. Row size too large	create table with latin1
40	engines/funcs.crash_manyindexes_string	Query failed	CREATE TABLE failed. Row size too large	Create table with latin1
41	engines/funcs.ix_index_lob	Query failed	CREATE INDEX failed because specified key was too long	Create tables with latin1
42	engines/funcs.ix_unique_lob	Query failed	CREATE INDEX failed because specified key was too long	Create tables with latin1
43	engines/iuds.strings_update_delete	Result content mismatch	Mismatch in notes	Passes now
44	i_main.mysql_client_test	Command failed	Command "$I_M_C_T" failed	Passes now