maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #06832
Re: Proposal for: MDEV-5244: Make extended_keys=ON by default in 10.0
On 02/21/2014 04:14 PM, Sergey Petrunia wrote:
> Hello,
>
> 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
>
> set opimizer_switch='extended_keys=off'
> <testcase>
> set opimizer_switch='extended_keys=on'
>
> 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?
Sounds reasonable for me.
Regards,
Igor.
>
> BR
> Sergei
References