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

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

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