FTSearch and wildcards

HCL Domino Domino Forum
1

Hi,

I have a strange problem…

Using this query string, I find 1 document

[ApplicantsForename] CONTAINS ar* AND [ApplicantsSurname] CONTAINS mcdermott

BUT using this string, simply making the wildcard part 1 character less, I find 0 documents.

[ApplicantsForename] CONTAINS a* AND [ApplicantsSurname] CONTAINS mcdermott

Any idea why? Is there something where you have to use more than 1 character if using a wildcard or something stupid that I’m missing?

Thanks

2

Subject: Corrupt index?

Try a similar search in a different db and see what happens. If it works, then perhaps the FTIndex is corrupt so you might delete and rebuild it.

FYI, this kind of one character ‘contains’ search works on a db I picked at random.

3

Subject: FTSearch and wildcards

Following is returned on the server with debugging enabled.

Output below Query: ( FIELD ApplicantsForename CONTAINS a* AND FIELD ApplicantsSurname CONTAINS mcdermott) Engine Query: (“a*”%STEM@F163 * “mcdermott”%STEM@F161) OUT FTGSearch error = F22

Anybody know what error F22 is? I cant find any information about what it is, or how to fix…