WL#9489: Migrate main suite to run with innodb (part 14)
Affects: Server-8.0 — Status: Complete
This is a continuation of migrate main suite to run with innodb storage engine. Several tests were migrated in previous WLs. This one will migrate tests that appear to be relatively easy to fix. Following changes are made: --------------------------- main.group_by.test : 1. Order may vary when NULL is used in order by clause , its ok 2. The group by query is an invalid query , so absurd results are expected when set SQL_MODE='' When SQL_MODE=only_full_group_by both storage engines throws an error this is an expected 3. ANALYZE TABLE added to avoid explain mismatch main.ctype_latin1_de.test : The auto_inc column should be a key column , in order to become index column for innoDB. For Myisam this need not be a case. InnoDB behavior: When the auto_inc column is a secondary column in a multiple-column index, then a key needs (primary/unique) to be added or the other solution is that, without adding key attribute , make the auto_inc column as a primary column in a DDL statement. Look at the reference manual : http://dev.mysql.com/doc/refman/5.7/en/example- auto-increment.html For Myisam the implementation is different Following testcases already migrated to InnoDB, hence not touched ------------------------------------------------------------------ main.handler_myisam.test main.count_distinct.test User Documentation ================== Work was done for test suite. No user documentation needed.
t/ddl_i18n_koi8r.test Record show create table t/func_regexp.test Minor difference in EXPLAIN. Must be ok to record t/func_default.test Minor difference in EXPLAIN. Must be ok to record t/events_time_zone.test Passes without changes. Remove force_myisam.inc t/func_concat.test Difference in SELECT output. t/group_by.test Explain difference. Test is validating result, so should be ok to record t/func_compress.test Minor difference in EXPLAIN. Must be ok to record t/func_like.test Minor explain difference. Should be ok to record t/func_test.test Minor explain difference. Should be ok to record t/type_datetime.test Minor explain difference. Should be ok to record t/row.test Minor result diff t/windows.test Minor explain difference. Should be ok to record t/null_key_none.test Minor difference in EXPLAIN. Must be ok to record t/count_distinct.test Minor result diff t/create-big.test Difference in show create table and binlog content. t/ctype_latin1_de.test Difference in autoinc behavior. Needs to be modified to work with innodb t/error_simulation.test Record show create table t/handler_myisam.test Clearly MyISAM test. Add ENGINE=MyISAM to create table statements t/metadata.test Difference in SELECT output. t/ddl_i18n_utf8.test Record show create table
Copyright (c) 2000, 2021, Oracle Corporation and/or its affiliates. All rights reserved.