WL#11710: Migrate optimizer tests from main suite to run with default engine innodb
Affects: Server-8.0 — Status: Complete
In latest releases , innodb is made as default engine. But tests from main suite are written considering myisam as engine from start. As count of tests from main suite is , so modifications (tests and/or result) for innodb is big task. We currently continue to run main suite test with "myisam" by calling "include/force_myisam_default.inc" . So as to make test run with innodb we have to adjust test(and/or result) and remove "include/force_myisam_default.inc" from each test. This WL targets changing optimizer related test (where tests are failing mainly due to difference in explain output )when run with innodb as default engine. Difference in explain output is for - index used - rows ( which vary for innodb) - Comment field **List of test which have failure/result difference related to optimizer (they might have additional difference too ) Major diff in explain which is recorded for myisam + parent/child delete error main.select_found main.distinct main.func_compress main.func_concat main.func_default main.func_group main.select_safe main.type_date main.type_datetime main.func_str main.func_test main.view_grant main.greedy_search main.group_by
Copyright (c) 2000, 2023, Oracle Corporation and/or its affiliates. All rights reserved.