Inconsistent behavior between VString and VText for Indexed by Word search

[Ivan Smahin]

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.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com