This is the content of a table column "Caption":

Zugang T-Online Test

Three statements:

1. select * from folders where caption contains 'T-Online'
2. select * from folders where caption contains 'T-Online*'
3. select * from folders where caption contains '*T-Online*'

1. and 2. work, 3. fails and doesn't find a record.

Is that a bug or by design?

Thanks Uli

Uli

>1. select * from folders where caption contains 'T-Online'
>2. select * from folders where caption contains 'T-Online*'
>3. select * from folders where caption contains '*T-Online*'
>
>1. and 2. work, 3. fails and doesn't find a record.
>
>Is that a bug or by design?

It should work. The only thing I can think of is that T-Online is at the start and is failing because its trying to find something.

Roy

Roy,

> It should work. The only thing I can think of is that T-Online is at the start and is failing because its trying to find something.

I should have put that in parenthesis:

This is the content of a table column "Caption":

"Zugang T-Online Test"

So it's not at the start.

Uli

Addition:

I use Version 2.13 Build 3

Uli


My machine is back in a state where I can start testing things. V2.14b3 also shows the same behaviour. However, reading the manusl

CONTAINS
Returns True if the left column reference contains all of the word values specified in the right string expression (not necessarily next to each other). The asterisk (*) can be used to specify a trailing wildcard.

I thought it had been enhanced but maybe not.

Roy Lambert [Team Elevate]

Uli,

<< 1. and 2. work, 3. fails and doesn't find a record.

Is that a bug or by design? >>

It's a bug.  I'll have a fix in the next release.

Tim Young
Elevate Software
www.elevatesoft.com

Uli,

Sorry about the delay in getting back to you on this, but I looked into this
and it's not exactly a bug (but it is weird, so I may need to figure out a
fix for it anyways).

The issue is with the fact that the dash ('-') character is a space
character, by default, in the word generation.

What is happening is this:

1) select * from folders where caption contains 'T-Online'

The T is dropped because it is less than 3 characters (default min word
size), and so the caption column is searched for 'Online'.

2) select * from folders where caption contains 'T-Online*'

Same thing as 1), but just with the additional wildcard specification at the
end of 'Online'.

3) select * from folders where caption contains '*T-Online*'

This is where things get dicey.  The main issue is the splitting of the
search terms on the dash, but the wildcard makes things more weird by
forcing the word to be kept.  So, EDB ends up searching for:

*T

and

Online*

Since it doesn't find the first, the search fails.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Uli,

A workaround could be:

3. select * from folders where caption contains  '*Online*' and pos('T_Online', Caption) > 0;

The index on Caption gets executed first then the Pos() is executed on the rows that were found.

Barry

Barry,

> select * from folders where caption contains  '*Online*' and pos('T_Online', Caption) > 0

Thanks, but that won't work, because I don't know what the user will
enter in the search field.

Uli

Tim,

that's interesting and it's a weird problem indeed.

As long as the dash character is defined as a space character, it will
be difficult to find a solution.
Maybe is't different in English, but in German there would be no need to
regard it as a space character.

Uli