Index by words seems broken in 2.5.3

[Ruslan Zasukhin]

On 15/1/07 4:11 PM, "Pierre Rossel" <agora07 at prossel.com> wrote:

>> The best way for this to use
>> 
>>     WHERE fld(left, 5) = 'abcde'
> 
> Yes, it works with:
> 
>   WHERE LEFT(fld, 5) = 'abcde'
> 
> But what happened to the like syntax ?
> 
> With the like syntax, by default I can search words that start with
> something, but I just have to add a % in front of the searched word to be
> able to find it in the middle of words as well.
> 
> With the left syntax, I cannot do this anymore.
> 
> So, it is only a bug in the like operator ? Will you fix it ?

Ivan have return the old behavior.
Wait for 2.5.4


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]