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:

> 
> 
>> -----Original Message-----
>> From: Ruslan Zasukhin
>> Sent: Monday, January 15, 2007 12:34 PM
>> 
>> 
>> On 15/1/07 1:07 PM, "Pierre Rossel" <agora07 at prossel.com> wrote:
>> 
>>> 
>>> select ** from MediaItem where mediaData like 'b%'
>> 
>> It looks you want search START WITH.
>> 
>> 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.

For CONTAINS search you need use SUBSTR()

> With the left syntax, I cannot do this anymore.
> 
> So, it is only a bug in the like operator ? Will you fix it ?

We have CHANGE this with LIKE specially.

Because up to know LIKE was not able search phrases...

Although its possible to control this by using Methods to have
    a) normal index
    b) index by words

We will discuss this here once more.

-- 
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]