Distance and Wildcards

[Thomas Henz]

Dear all,

I'm running a full text index on a rather huge database which I'd like to run the following query against:

[...]
MATCH(doc_text) AGAINST ('"+capital* +market* +union*" @5' IN BOOLEAN MODE)
[...]

This query returns results for anything, that contains the words "capital market union" in a max. distance of 5 words.

However, it does not return anything in the distance of 5 words that is "capital markets union" - notice the s in markets, which I'd like to cover with the wildcard. Why?

Of course, if I change it to

[...]
MATCH(doc_text) AGAINST ('+capital* +market* +union*' IN BOOLEAN MODE)
[...]

I get anything that contains capital, market, markets, union, unions separately somewhere in the text.

How can I use distance + wildcard?

Thanks a lot,
Thomas