Hi Yves,
You are right, if I return ((ha_rows)~0 - 1) the index is not selected.
However, is there any guarantee this will be always the case?
Thanks!
-----Original Message-----
From: Yves Trudeau [mailto:y.trudeau@videotron.ca]
Sent: Thursday, June 23, 2011 2:25 PM
To: Olivier Chédru
Cc: internals@stripped
Subject: Re: Temporarily preventing index from being selected
Hi Olivier,
Have you tried returning a very large number. That would hint not to
use the index.
Regards,
Yves
On Thu, 2011-06-23 at 12:03 +0200, Olivier Che for MySQL 5.5. My storage engine is able to perform online index alterations.
>
> I would like to prevent MySQL from choosing an index currently being added by the storage engine.
>
> To do so, my handler::records_in_range() method returns HA_POS_ERROR.
> However this does not work: the index is used by the query anyway.
>
> Any idea about how to achieve that?
>
> Thanks
> Olivier
>
