Inconsistent behavior between VString and VText for Indexed by Word search

[Ivan Smahin]

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.

> Thanks for listening.
>
>
>
> Cool Runnings,
> Erne.
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>


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