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

Affects: Server-8.0 — Status: Complete

Description
High Level Architecture
Low Level Design

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