Index by words seems broken in 2.5.3

[Ruslan Zasukhin]

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'
 
> See http://www.valentina-db.com/bt/view.php?id=2159 with sample db and query
> to reproduce
> 
> This is pretty urgent. We started to distribute our application with 2.5.3.
> Now we need to provide a fix for existing customers and update our master CD
> that will go soon to the replicator.

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