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 |
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.