Inconsistent behavior between VString and VText for Indexed by Word search

[Ernesto Giannotta]

Thanks Ivan!

On 14-ago-2011, at 15:34, Ivan Smahin wrote:

> On 8/13/2011 8:26 PM, Ernesto Giannotta wrote:
>> Hi Ruslan,
>> 
>> On 13-ago-2011, at 07:30, Ruslan Zasukhin wrote:
>> 
>>> On 8/12/11 6:11 PM, "Ernesto Giannotta"<erne at apimac.com>  wrote:
>>> 
>>> Hi Erne,
>>> 
>>>> Is this by design?
>>> No.
>>> 
>>> Please copy paste this letter into mantis,.
>>> We will try reproduce asap.
>>> 
>>> Best of all if you attach zip of that db
>>> 
>> done!
>> 
>> May I ask,
>> 
>> Is Vale using indexes for 'something%' or 'something' LIKE searches?
> Actually it is the same as "start_with" function - yes it will be indexed search if possible.
> 
>> 
>> If yes, does Vale ignore indexes in '%something%' LIKE searches?
>> 
> No, if index is available it will be used, except if the field is string-based and lengthily enough (more than 256 symbols).
> In this case index would be ignored because of indexing only first 256 symbols from each row.

A last question, how can an index be used in a "contains" search such as '%something%' LIKE?


Cool Runnings,
Erne.