WL#10297: Change InnoDB tests to run with new default charset

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

WL#7554 added a workaround to make some tests pass with utf8mb4. This WL will remove the workaround and fix the tests in replication and binlog suites.

User Documentation

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

The low level design specification contains the list of tests that have the workaround. Remove the workarounds and make changes needed for test to pass

Tests to be migrated

Tests that use alter table :

  • internal/mysql-test/suite/i_innodb/t/innodb_bug14353985.test
  • internal/mysql-test/suite/i_innodb/t/index_redundant_debug.test
  • internal/mysql-test/suite/i_innodb/t/innodb-cascade.test
  • internal/mysql-test/suite/i_innodb/t/innodb-comments.test
  • internal/mysql-test/suite/i_innodb/t/ibuf_free_bit.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug11765218.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug13807811.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14146134.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14488218.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14176821.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14220701.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14503700.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14731482.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14221812.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug16208542.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug16417635.test
  • internal/mysql-test/suite/i_innodb/t/innodb-alter-debug.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug11758237.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14219624.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14584867.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14619030.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug17447500.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14630263.test
  • internal/mysql-test/suite/i_innodb/t/multi_delete-bug19815702.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14548601.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14589582.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14712710.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug16083211.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14755452.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug16174255.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug16868967.test
  • internal/mysql-test/suite/i_innodb_zip/t/bug13453036.test
  • internal/mysql-test/suite/i_innodb_zip/t/rollback_debug.test
  • internal/mysql-test/suite/i_innodb_zip/t/zip.test
  • mysql-test/suite/innodb/t/alter_rename_existing_xtra.test
  • mysql-test/suite/innodb/t/autoinc_debug.test
  • mysql-test/suite/innodb/t/innodb-update-insert.test
  • mysql-test/suite/innodb/t/autoinc_persist.test
  • mysql-test/suite/innodb/t/import.test
  • mysql-test/suite/innodb/t/innodb_bug12661768.test
  • mysql-test/suite/innodb/t/alter_rename_existing.test
  • mysql-test/suite/innodb/t/crc32_endianness.test
  • mysql-test/suite/innodb/t/innodb_bug21704.test
  • mysql-test/suite/innodb/t/innodb_misc1.test
  • mysql-test/suite/innodb/t/alter_page_size.test
  • mysql-test/suite/innodb/t/alter_rename_files.test
  • mysql-test/suite/innodb/t/innodb-autoinc.test
  • mysql-test/suite/innodb/t/autoinc_persist_deadlock.test
  • mysql-test/suite/innodb/t/innodb-autoinc-44030.test
  • mysql-test/suite/innodb/t/innodb_mysql.test
  • mysql-test/suite/innodb/t/auto_increment.test
  • mysql-test/suite/innodb/t/autoinc_persist_debug.test
  • mysql-test/suite/innodb/t/innodb_bug56143.test
  • mysql-test/suite/innodb/t/innodb-index.test
  • mysql-test/suite/innodb/t/cascade_lock_wait.test
  • mysql-test/suite/innodb/t/innodb_prefix_index_restart_server.test
  • mysql-test/suite/innodb/t/innodb-autoinc-18274.test
  • mysql-test/suite/innodb/t/create_tablespace_partition.test
  • mysql-test/suite/innodb/t/innodb-alter-wl6554.test
  • mysql-test/suite/innodb/t/innodb-alter-debug-wl6554.test
  • mysql-test/suite/innodb/t/innodb-wl5522.test
  • mysql-test/suite/innodb/t/innodb-alter-debug.test
  • mysql-test/suite/innodb/t/foreign_key.test
  • mysql-test/suite/innodb/t/index_merge_threshold.test
  • mysql-test/suite/innodb/t/create_tablespace.test
  • mysql-test/suite/innodb/t/innodb-wl5522-1.test
  • mysql-test/suite/innodb/t/default_row_format_16k.test
  • mysql-test/suite/innodb/t/import_update_stats.test
  • mysql-test/suite/innodb/t/innodb-alter-autoinc.test
  • mysql-test/suite/innodb/t/create_tablespace_debug.test
  • mysql-test/suite/innodb/t/default_row_format.test
  • mysql-test/suite/innodb/t/innodb_bug14007649.test
  • mysql-test/suite/innodb/t/default_row_format_compatibility.test
  • mysql-test/suite/innodb/t/innodb_bug51378.test
  • mysql-test/suite/innodb/t/innodb_bug54044.test
  • mysql-test/suite/innodb/t/innodb-index-online-fk.test
  • mysql-test/suite/innodb/t/innodb-multiple-tablespaces.test
  • mysql-test/suite/innodb/t/innodb-wl5980-alter.test
  • mysql-test/suite/innodb/t/innodb_bug14169459.test
  • mysql-test/suite/innodb/t/innodb_wl6326.test
  • mysql-test/suite/innodb/t/innodb-wl5980-discard.test
  • mysql-test/suite/innodb/t/innodb-bug12552164.test
  • mysql-test/suite/innodb/t/innodb-copy-alter-debug.test
  • mysql-test/suite/innodb/t/innodb-import-partition.test
  • mysql-test/suite/innodb/t/innodb-index-debug.test
  • mysql-test/suite/innodb/t/innodb-index-online.test
  • mysql-test/suite/innodb/t/innodb-table-online.test
  • mysql-test/suite/innodb/t/innodb-wl5522-debug.test
  • mysql-test/suite/innodb/t/innodb_stats_table_flag_sample_pages.test
  • mysql-test/suite/innodb/t/log_encrypt_1.test
  • mysql-test/suite/innodb/t/innodb_rename_index.test
  • mysql-test/suite/innodb/t/innodb_stats_flag_global_off.test
  • mysql-test/suite/innodb/t/innodb_stats_flag_global_on.test
  • mysql-test/suite/innodb/t/innodb_stats_table_flag_auto_recalc.test
  • mysql-test/suite/innodb/t/innodb_bulk_create_index.test
  • mysql-test/suite/innodb/t/innodb_bulk_create_index_small.test
  • mysql-test/suite/innodb/t/innodb_ctype_ldml.test
  • mysql-test/suite/innodb/t/innodb_stats_drop_locked.test
  • mysql-test/suite/innodb/t/innodb_tablespace.test
  • mysql-test/suite/innodb/t/innodb_wl8114.test
  • mysql-test/suite/innodb/t/optimizer_temporary_table.test
  • mysql-test/suite/innodb/t/partition.test
  • mysql-test/suite/innodb/t/readahead.test
  • mysql-test/suite/innodb/t/table_compress.test
  • mysql-test/suite/innodb/t/table_encrypt_1.test
  • mysql-test/suite/innodb/t/table_encrypt_debug.test
  • mysql-test/suite/innodb/t/tablespace_per_table.test
  • mysql-test/suite/innodb/t/temp_table_savepoint.test
  • mysql-test/suite/innodb/t/temporary_table.test
  • mysql-test/suite/innodb/t/temporary_table_optimization.test
  • mysql-test/suite/innodb/t/undo_encrypt_basic.test
  • mysql-test/suite/innodb/t/update-cascade.test
  • mysql-test/suite/innodb/t/virtual_basic.test
  • mysql-test/suite/innodb/t/virtual_debug.test
  • mysql-test/suite/innodb/t/virtual_debug_purge.test
  • mysql-test/suite/parts/t/part_exch_valid_key_innodb.test
  • mysql-test/suite/parts/t/part_supported_sql_func_innodb.test
  • mysql-test/suite/parts/t/partition_alter1_1_2_innodb.test
  • mysql-test/suite/parts/t/partition_alter1_1_innodb.test
  • mysql-test/suite/parts/t/partition_alter1_2_innodb.test
  • mysql-test/suite/parts/t/partition_alter2_2_1_innodb.test
  • mysql-test/suite/parts/t/partition_alter4_innodb.test
  • mysql-test/suite/parts/t/partition_analyze.test
  • mysql-test/suite/parts/t/partition_basic_innodb.test
  • mysql-test/suite/parts/t/partition_change_from_range_to_hash_key.test
  • mysql-test/suite/parts/t/partition_key.test
  • mysql-test/suite/parts/t/partition_reorg_merge.test
  • mysql-test/suite/parts/t/partition_syntax_innodb.test
  • mysql-test/suite/parts/t/partition_debug_innodb.test
  • mysql-test/suite/parts/t/partition_debug_sync_innodb.test
  • mysql-test/suite/parts/t/partition_decimal_innodb.test
  • mysql-test/suite/parts/t/partition_engine_innodb.test
  • mysql-test/suite/parts/t/partition_rebuild.test
  • mysql-test/suite/parts/t/partition_datetime_innodb.test
  • mysql-test/suite/parts/t/partition_debug.test
  • mysql-test/suite/parts/t/partition_exch_qa_1_innodb.test
  • mysql-test/suite/parts/t/partition_repair.test
  • mysql-test/suite/parts/t/partition_exchange_innodb.test
  • mysql-test/suite/parts/t/partition_sub1.test
  • mysql-test/suite/parts/t/partition-dml-1-12-innodb.test
  • mysql-test/suite/parts/t/partition_basic_symlink_innodb.test
  • mysql-test/suite/parts/t/partition_char_innodb.test
  • mysql-test/suite/parts/t/partition_icp.test
  • mysql-test/suite/parts/t/partition_optimize.test
  • mysql-test/suite/parts/t/partition_alter2_1_1_innodb.test
  • mysql-test/suite/parts/t/partition_alter2_1_2_innodb.test
  • mysql-test/suite/parts/t/partition_alter2_2_2_innodb.test
  • mysql-test/suite/parts/t/partition_alter3_innodb.test
  • mysql-test/suite/parts/t/partition_auto_increment_innodb.test
  • mysql-test/suite/parts/t/partition_linear_key.test
  • mysql-test/suite/parts/t/partition_special_innodb.test
  • mysql-test/suite/parts/t/partition_sub2.test
  • mysql-test/suite/parts/t/partition_float_innodb.test
  • mysql-test/suite/parts/t/partition_hash_date_function.test
  • mysql-test/suite/parts/t/partition_value.test
  • mysql-test/suite/parts/t/partition_int_innodb.test
  • mysql-test/suite/parts/t/partition_remove.test
  • mysql-test/suite/parts/t/partition_reorg_divide.test
  • mysql-test/suite/parts/t/partition_bit_innodb.test
  • mysql-test/suite/parts/t/partition_check.test
  • mysql-test/suite/parts/t/partition_reorg_hash_key.test
  • mql-test/suite/parts/t/partition_reorganize_innodb.test
  • mysql-test/suite/parts/t/partition_value_specific.test
  • mysql-test/suite/innodb_fts/t/fulltext_misc.test
  • mysql-test/suite/innodb_fts/t/misc_1.test
  • mysql-test/suite/innodb_fts/t/multiple_index.test
  • mysql-test/suite/innodb_fts/t/ngram_1.test
  • mysql-test/suite/innodb_fts/t/stopword.test
  • mysql-test/suite/innodb_gis/t/0.test
  • mysql-test/suite/innodb_gis/t/1.test
  • mysql-test/suite/innodb_gis/t/alter_spatial_index.test
  • mysql-test/suite/innodb_gis/t/create_spatial_index.test
  • mysql-test/suite/innodb_gis/t/geometry.test
  • mysql-test/suite/innodb_gis/t/kill_server.test
  • mysql-test/suite/innodb_gis/t/point_basic.test
  • mysql-test/suite/innodb_gis/t/rt_precise.test
  • mysql-test/suite/innodb_gis/t/rtree.test
  • mysql-test/suite/innodb_gis/t/rtree_debug.test
  • mysql-test/suite/innodb_gis/t/rtree_multi_pk.test
  • mysql-test/suite/innodb_gis/t/rtree_old.test
  • mysql-test/suite/innodb_gis/t/rtree_split.test
  • mysql-test/suite/innodb_gis/t/types.test
  • mysql-test/suite/innodb_zip/t/16k.test
  • mysql-test/suite/innodb_zip/t/cmp_per_index.test
  • mysql-test/suite/innodb_zip/t/create_options.test
  • mysql-test/suite/innodb_zip/t/index_large_prefix.test*mysql-test/suite/innodb_zip/t/prefix_index_liftedlimit.test
  • mysql-test/suite/innodb_zip/t/restart.test
  • mysql-test/suite/innodb_zip/t/wl5522_debug_zip.test
  • mysql-test/suite/innodb_zip/t/wl5522_zip.test
  • mysql-test/suite/innodb_zip/t/wl6915_1.test

Tests that set character-set-server at bootstrap in opt file:

  • internal/mysql-test/suite/i_innodb/t/innodb-alter.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug11753153.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14636528.test
  • internal/mysql-test/suite/i_innodb/t/index_redundant.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14712962.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug14548601.test
  • internal/mysql-test/suite/i_innodb/t/innodb_bug15960850.test
  • internal/mysql-test/suite/i_main/t/partition_innodb.test
  • internal/mysql-test/suite/i_main/t/partition_key.test
  • internal/mysql-test/suite/i_main/t/alter_table.test
  • internal/mysql-test/suite/i_main/t/auto_increment_debug_sync.test
  • internal/mysql-test/suite/i_main/t/partition.test
  • internal/mysql-test/suite/i_main/t/partition_data_dir.test
  • internal/mysql-test/suite/i_main/t/partition_admin.test
  • mysql-test/suite/innodb/t/end_range_check.test
  • mysql-test/suite/innodb/t/innodb-alter.test
  • mysql-test/suite/innodb/t/create_tablespace_replication.test
  • mysql-test/suite/innodb/t/flush-hang.test
  • mysql-test/suite/innodb/t/innodb_bug14007109.test
  • mysql-test/suite/innodb/t/innodb-wl6445.test
  • mysql-test/suite/innodb/t/innodb-system-table-view_cs.test
  • mysql-test/suite/innodb/t/innodb_wl6326_big.test
  • mysql-test/suite/innodb/t/log_encrypt_2.test
  • mysql-test/suite/innodb/t/innodb_bulk_create_index_replication.test
  • mysql-test/suite/innodb/t/table_encrypt_2.test
  • mysql-test/suite/innodb/t/table_encrypt_3.test
  • mysql-test/suite/innodb/t/table_encrypt_4.test
  • mysql-test/suite/innodb/t/table_encrypt_kill.test
  • mysql-test/suite/parts/t/rpl_partition.test
  • mysql-test/suite/parts/t/partition_mgm_lc0_innodb.test
  • mysql-test/suite/parts/t/partition_mgm_lc1_innodb.test
  • mysql-test/suite/innodb_fts/t/misc.test
  • mysql-test/suite/innodb_gis/t/multi_pk.test
  • mysql-test/suite/innodb_zip/t/4k.test
  • mysql-test/suite/innodb_zip/t/8k.test
  • mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test
  • mysql-test/suite/innodb_zip/t/index_large_prefix_8k.test
  • mysql-test/t/partition_not_supported.test

Original list of failing tests

The list below contains all the tests that fail due to a result content mismatch in the charset value, which is expected. The result file needs to be updated after verifying the charset value.

S.No Test name Reason of failure Details Developer Notes
1 innodb.table_encrypt_2 Result content mismatch Mismatch in the charset printed by CREATE statements in mysqldump. Result needs to be updated. Result recorded
2 innodb.log_encrypt_2 Result content mismatch Mismatch in the charset printed by CREATE statements in mysqldump. Result needs to be updated. Result recorded
3 i_innodb.innodb-alter Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
4 innodb.table_encrypt_kill Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
5 i_innodb.innodb_bug14548601 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
6 i_innodb.innodb_bug14712962 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
7 i_innodb.innodb_bug15960850 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
9 innodb_zip.wl5522_debug_zip Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
10 innodb_fts.misc Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
11 innodb.innodb-alter Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
12 innodb.innodb-wl5522-debug Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. test disabled.
13 i_innodb.innodb_bug11753153 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
14 innodb.innodb-wl6445 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
15 innodb.table_encrypt_3 Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
16 innodb.table_compress Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. test disabled
17 innodb.tablespace_per_table_windows Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
18 innodb.table_encrypt_debug Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
19 innodb.innodb-copy-alter-debug Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
20 parts.partition_mgm_lc1_innodb Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
21 parts.partition_mgm_lc0_innodb Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
22 parts.partition_mgm_lc2_innodb Result content mismatch Mismatch in the charset printed by SHOW CREATE TABLE. Result needs to be updated. Result recorded
23 innodb.innodb_ctype_ldml Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
24 innodb.innodb-autoinc-44030 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
25 innodb.innodb-autoinc Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
26 i_innodb.innodb-alter-debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
27 innodb.innodb-index-online Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
28 innodb.innodb-table-online Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
29 innodb.innodb-index-debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
30 innodb.innodb_stats_flag_global_off Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
31 innodb.innodb_stats_flag_global_on Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
32 parts.partition_debug_sync_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
33 i_innodb_zip.rollback_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
34 i_innodb.innodb_bug16868967 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
35 parts.partition_special_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
36 i_innodb.innodb_bug14619030 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
37 main.archive_no_symlink Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
38 main.type_blob Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
39 i_main.partition Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
40 innodb.create_tablespace Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
41 innodb.create_tablespace_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
42 innodb.innodb-alter-debug-wl6554 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
43 i_innodb.innodb_bug11758237 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
44 innodb.innodb_bug51378 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
45 i_innodb.innodb_bug14584867 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
46 innodb.innodb_prefix_index_restart_server Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
47 innodb.create_tablespace_partition Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
48 i_innodb.innodb_bug11765218 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
49 innodb.alter_page_size Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
50 innodb_gis.0 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
51 i_innodb.innodb_bug14589582 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
52 innodb.alter_rename_existing Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
53 innodb.innodb_rename_index Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
54 innodb.alter_rename_existing_xtra Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
55 innodb_gis.1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
56 innodb.default_row_format Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
57 innodb_gis.types Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
58 i_innodb.innodb_bug14630263 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
59 innodb.alter_rename_files Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
60 i_innodb.innodb_bug17447500 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
61 innodb_gis.alter_spatial_index Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
62 i_innodb.innodb_bug14146134 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
63 i_innodb.innodb_bug14176821 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
64 innodb.temporary_table Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
65 innodb_gis.create_spatial_index Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
66 i_innodb.innodb_bug14219624 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
67 innodb.temporary_table_optimization Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
68 i_innodb.innodb_bug14220701 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
69 i_innodb.innodb_bug14221812 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
70 innodb_gis.geometry Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
71 innodb.innodb_stats_drop_locked Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
72 innodb_gis.gis Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
73 i_innodb.innodb_bug14353985 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
74 parts.partition_exchange_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
75 innodb_zip.create_options Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
76 innodb.innodb-index-online-fk Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
77 i_innodb.innodb_bug14488218 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
78 i_innodb.innodb_bug14503700 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
79 innodb.innodb_stats_table_flag_auto_recalc Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
80 innodb_gis.kill_server Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
81 innodb.innodb_bug54044 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
82 innodb.innodb_bug56143 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
83 innodb.innodb_stats_table_flag_sample_page Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
84 innodb.innodb-multiple-tablespaces Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
85 i_innodb.innodb_bug16083211 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
86 innodb.innodb_tablespace Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
87 innodb.log_encrypt_1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
88 i_innodb.innodb_bug16174255 Result content mismatch Mismatch in the charset value. Result needs to be updated. Removed by 3bff56267ccf3dd14a48ed3ff8e8a3592392d2cc
89 innodb.update-cascade Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
90 i_innodb.innodb_bug16208542 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
91 parts.partition-dml-1-12-innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
92 innodb.foreign_key Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
93 parts.partition_bit_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
94 parts.partition_change_from_range_to_hash_key Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
95 parts.partition_check Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
96 innodb.virtual_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
97 innodb_zip.restart Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
98 i_innodb.multi_delete-bug19815702 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
99 parts.partition_datetime_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
100 i_innodb.innodb_bug16417635 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
101 innodb.import Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
102 parts.partition_sub2 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
103 innodb.virtual_debug_purge Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
104 parts.partition_syntax_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
105 parts.partition_value Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
106 parts.partition_float_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
107 parts.partition_value_specific Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
108 parts.partition_hash_date_function Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
109 parts.partition_icp Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
110 innodb_zip.wl5522_zip Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
111 parts.partition_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Removed by 3bff56267ccf3dd14a48ed3ff8e8a3592392d2cc
112 gcol.gcol_column_def_options_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
113 innodb.innodb-alter-debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
114 parts.partition_int_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
115 gcol.gcol_column_def_options_myisam Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
116 innodb.innodb-update-insert Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
117 innodb.innodb-autoinc-18274 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
118 gcol.gcol_keys_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
119 gcol.gcol_keys_myisam Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
120 gcol.gcol_non_stored_columns_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
121 innodb_fts.misc_1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
122 gcol.gcol_non_stored_columns_myisam Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
123 parts.partition_key Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
124 innodb_fts.multiple_index Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
125 i_gcol.gcol-bug22392268 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
126 parts.partition_linear_key Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
127 parts.part_supported_sql_func_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
128 parts.partition_optimize Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
129 innodb.innodb-wl5522 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
130 parts.partition_rebuild Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
131 parts.partition_alter1_1_2_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
132 parts.partition_remove Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
133 parts.partition_reorg_divide Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
134 innodb_fts.ngram_1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
135 innodb_gis.point_basic Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
136 i_innodb.innodb-cascade Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
137 parts.partition_reorg_hash_key Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
138 i_innodb.innodb-comments Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
139 parts.partition_debug_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Removed by 3bff56267ccf3dd14a48ed3ff8e8a3592392d2cc
140 parts.partition_reorg_merge Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
141 innodb.innodb-wl5980-discard Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
142 parts.partition_reorganize_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
143 parts.partition_decimal_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
144 parts.partition_repair Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
145 innodb_fts.stopword Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
146 parts.partition_sub1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
147 parts.partition_engine_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
148 parts.partition_exch_qa_1_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
149 parts.partition_alter1_1_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
150 innodb.auto_increment Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
151 innodb.autoinc_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
152 innodb.partition Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
153 innodb.autoinc_persist Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
154 innodb.autoinc_persist_deadlock Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
155 innodb.create_tablespace_replication Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
156 innodb.innodb_bug14007649 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
157 innodb.innodb_bug14169459 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
158 innodb.innodb_bulk_create_index_replication Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
159 parts.rpl_partition Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
160 innodb.autoinc_persist_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
161 gcol.rpl_gcol Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
162 innodb.innodb_bug21704 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
163 parts.partition_alter1_2_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
164 innodb.cascade_lock_wait Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
165 innodb.table_encrypt_1 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
166 parts.partition_alter2_1_1_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
167 i_main.auto_increment_debug_sync Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
168 innodb.tablespace_per_table Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
169 innodb_gis.rt_precise Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
170 innodb.table_encrypt_4 Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
171 innodb_gis.rtree Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
172 innodb_gis.rtree_multi_pk Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
173 innodb_gis.rtree_old Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
174 parts.partition_analyze Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
175 parts.partition_alter3_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
176 parts.partition_basic_symlink_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
177 parts.partition_auto_increment_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
178 parts.partition_alter2_1_2_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
179 parts.partition_alter2_2_1_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
180 innodb_gis.rtree_split Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
181 parts.partition_alter2_2_2_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
182 innodb_gis.rtree_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
183 parts.partition_basic_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
184 parts.partition_alter4_innodb Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
185 i_innodb.index_redundant Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
186 i_innodb.index_redundant_debug Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
188 innodb.undo_encrypt_basic Result content mismatch Mismatch in the charset value. Result needs to be updated. Result recorded
189 gcol.gcol_view_innodb Result content mismatch Result needs to be updated Result recorded
190 gcol.gcol_view_myisam Result content mismatch Result needs to be updated Result recorded
191 innodb_fts.proximity Result content mismatch Result needs to be updated Result recorded
192 main.rowid_order_innodb Result content mismatch Result needs to be updated Result recorded
193 i_innodb.innodb_bug14712710 Result content mismatch Result needs to be updated Result recorded
194 innodb.innodb_stats_table_flag_sample_pages Result content mismatch Result needs to be updated Result recorded

These tests needs more analysis:

S.No Test name Reason of failure Details Developer Notes
1 innodb.innodb_wl6326_big Query failed in 4k page run ALTER TABLE failed. Needs further investigation. Create table with latin1
2 innodb.innodb-system-table-view_ci Result content mismatch Mismatch in the table stats printed by information schema. Removed by 3bff56267ccf3dd14a48ed3ff8e8a3592392d2cc
3 innodb.innodb-system-table-view_cs Result content mismatch Mismatch in the table stats printed by information schema. Removed by 3bff56267ccf3dd14a48ed3ff8e8a3592392d2cc
4 parts.partition_exch_qa_8_innodb Query failed ALTER TABLE query fails because the two tables mentioned in the query have different definitions. Passes now
5 parts.partition_exch_qa_4_innodb Query failed ALTER TABLE query fails because the two tables mentioned in the query have different definitions. Create table with latin1
6 innodb.innodb_misc1 Query failed CREATE TABLE failed because the column length was too big Create table with latin1
7 innodb.innodb Query failed CREATE TABLE failed because the column length was too big Create table with latin1
8 main.auto_increment Result content mismatch Mismatch in the warnings Result recorded
9 i_innodb_zip.bug13453036 Mysqltest failure CREATE TABLE succeeded. Should have failed Create table with latin1
10 innodb.innodb_mysql Result content mismatch Mismatch in the EXPLAIN output Create table with latin1
11 innodb.innodb-index Query failed ALTER TABLE failed. Index column size too large Create table with latin1
12 i_innodb.innodb_bug13807811 Query failed CREATE TABLE failed because the key was too long Create table with latin1
13 innodb.default_row_format_16k Query failed CREATE TABLE failed because the row size was too large Create table with latin1
14 innodb.default_row_format_compatibility Query failed CREATE TABLE failed because the key was too long Create table with latin1
15 i_innodb_zip.zip Query failed CREATE TABLE failed because the row size was too large Create table with latin1
16 innodb_zip.16k Mysqltest failure CREATE TABLE succeeded. Should have failed Create table with latin1
17 i_innodb.innodb_bug14731482 Query failed CREATE TABLE failed because the key was too long Create table with latin1
18 innodb_zip.cmp_per_index Query failed CREATE TABLE failed because the row size was too large Create table with latin1
19 innodb_zip.index_large_prefix Query failed CREATE TABLE failed because the key was too long Create table with latin1
20 innodb.innodb_wl6326 Query failed ALTER TABLE failed because the key was too long Create table with latin1
21 innodb.end_range_check Server crashed Innodb assertion failure Fixed
22 main.index_merge_innodb Query failed SELECT failed. Out of sort memory Create table with latin1
23 innodb_zip.prefix_index_liftedlimit Query failed CREATE TABLE failed because the key was too long Create table with latin1
24 innodb.virtual_basic Query failed CREATE TABLE failed because the row size was too large Create table with latin1
25 parts.partition_char_innodb Query failed CREATE TABLE failed because the key was too long Create table with latin1
26 parts.part_exch_valid_key_innodb Result content mismatch Mismatch in the result Result recorded
27 innodb.innodb_bulk_create_index Result content mismatch Mismatch in EXPLAIN output Result recorded
28 innodb_fts.fulltext Result content mismatch Mismatch in EXPLAIN output Result recorded
29 gcol.gcol_bugfixes Server crashed Innodb assertion failure Result recorded
30 innodb_fts.fulltext_misc Result content mismatch Mismatch in EXPLAIN output Result recorded
31 gcol.gcol_bugfixes_latin1 Result content mismatch Mismatch in hexadecimal value Result recorded
32 innodb.innodb-alter-autoinc Query failed ALTER TABLE failed. Incorrect prefix key Create table with latin1
33 innodb.innodb-alter-wl6554 Query failed ALTER TABLE not supported. Cannot change column type in place Create table with latin1
34 gcol.gcol_select_innodb Result content mismatch Mismatch in EXPLAIN output Result recorded
35 gcol.gcol_supported_sql_funcs_innodb Mysqltest failure INSERT failed with wrong error number. Incorrect string value. Create table with latin1
36 gcol.gcol_supported_sql_funcs_myisam Mysqltest failure INSERT failed with wrong error number. Incorrect string value. Create table with latin1
37 innodb.innodb_bulk_create_index_small Result content mismatch Mismatch in EXPLAIN output Result recorded
38 i_innodb.ibuf_free_bit Query failed CREATE TABLE failed because the key was too long Create table with latin1
39 innodb.innodb-wl5980-alter Result content mismatch Mismatch in PRTYPE Create table with latin1
40 innodb_zip.wl6915_1 Mysqltest failure Query reap failed. Index column too large Create table with latin1
41 i_main.strict Mysqltest failure CREATE TABLE failed with wrong error number. Key was too long Create table with latin1
42 innodb.innodb_wl8114 Result content mismatch Mismatch in PRTYPE Result recorded
43 innodb.readahead Query failed CREATE TABLE failed because the row size was too large Create table with latin1
44 innodb.crc32_endianness Query failed ALTER TABLE failed. Schema mismatch Create table with latin1
45 innodb.temp_table_savepoint Mysqltest failure Query reap failed. Index column too large Create table with latin1
46 innodb.optimizer_temporary_table Result content mismatch Mismatch in data_read_per_join Result recorded
47 innodb_zip.4k Query failed CREATE TABLE succeeded, should have failed Create table with latin1
48 innodb_zip.bug36169 Query failed CREATE TABLE failed with wrong error number. Specified key was too long in 4k run 16k page run only.
49 innodb_zip.index_large_prefix_4k Query failed CREATE TABLE failed because specified key was too long Create table with latin1
50 innodb_zip.8k Query failed CREATE TABLE succeeded, should have failed Create table with latin1
51 innodb_zip.index_large_prefix_8k Query failed CREATE TABLE failed because specified key was too long Create table with latin1
52 i_innodb.innodb_bug14755452 Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
53 i_innodb.innodb_bug14636528 Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
54 innodb.index_merge_threshold Query failed CREATE INDEX failed because the specified key was too long Create table with latin1
55 innodb.flush-hang Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
56 innodb.import_update_stats Query failed CREATE INDEX failed because the specified key was too long in 4k page run Create table with latin1
57 innodb.innodb-bug12552164 Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
58 innodb.innodb-import-partition Query failed CREATE INDEX failed because the specified key was too long in 4k page run Create table with latin1
59 innodb.innodb-wl5522-1 Query failed CREATE INDEX failed because the specified key was too long in 4k page run Create table with latin1
60 innodb.innodb_bug12661768 Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
61 innodb.innodb_bug14007109 Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
62 innodb_gis.multi_pk Query failed CREATE TABLE failed because the specified key was too long in 4k page run Create table with latin1
63 innodb.innodb_pagesize_max_recordsize Query failed CREATE TABLE failed because row size was too large Create table with latin1
64 innodb.mysqldump_max_recordsize Command failed Command "perl" failed Create table with latin1