Inconsistent behavior between VString and VText for Indexed by Word search

[Ernesto Giannotta]

On 16-ago-2011, at 08:19, Ivan Smahin wrote:

> On 8/15/2011 11:48 AM, Ernesto Giannotta wrote:
>> 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?
>> 
>> 
> It's too internal things :) but it is so. Looks similar to index scanning.
> 

Ever amazing Vale keeps her secrets well! :-)


Cool Runnings,
Erne.