maria-developers team mailing list archive
Mailing list archive
Proposal for: MDEV-5244: Make extended_keys=ON by default in 10.0
I was looking at how to make extended_keys=ON by default in 10.0.
There haven't been any bugs in the feature for quite some time, but we still
have a question of how to be with the testsuite (do we run it with
extended_keys=OFF, the old way, or with extended_keys=ON, the new way? both
approaches have their advantages)
So, I've just changed the default, and ran the default set of test suites.
A total 12 tests fail, of those only 3 tests fail in the way that indicates
that extended keys feature had an impact on the testcase (e.g. it got a
different execution plan and probably no longer tests what it used to test).
For these, I intend to place
around the affected testcases. The cases are:
range_vs_index_merge_innodb - switch @@optimizer_switch (~3 testcases)
index_merge_innodb - switch @@optimizer_switch (1 testcase)
innodb.innodb_mysql -switch @@optimizer_switch (1 testcase)
Any comments/input on this?
Sergei Petrunia, Software Developer
MariaDB | Skype: sergefp | Blog: http://s.petrunia.net/blog