Full-text searching on multi-valued properties

[zcc39r]

Having repository with no index providers explicitly configured I'm trying to search for nt:unstructured nodes with different properties using full-text searching facilities. Using full-text search language of ModeShape gives me too broad results when I need to search on specific property only.

So, considering that FT language statement

"foo"

have a JCR-SQL2 equivalent of

"SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.*, 'foo')"

, I'm trying to use more specific query, including property name into it:

"SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.[ns:bar], 'foo')".

The problem is that it gives expected results for single-valued properties only, not for multi-valued ones.

At same time mode broad query "SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.*, 'foo')"

gives expected results for all properties, including multi-valued.

Did I miss something?

[hchiorean]

"SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.[ns:bar], 'foo')".

the property name does not seem correct. A node selector can be an actual Name, but a property name should be a simple String. So the correct selector would look like "r.bar" (you can't have [ns:bar] as the selector of a property)

[zcc39r]

I followed an example at JCR-SQL2- Full-text search constraint. Is it incorrect too?

I didn't get the point why I can't have [ns:bar] as the selector. If I have bar, ns:bar, ns2:bar, ..., nsN:bar properties, how could I select specific one?

Also, as I noted in original question, r.[ns:bar] gives expected result for single-valued properties. So if incorrect query produces correct results then we have another kind of problem.

[hchiorean]

See [MODE-2579] Full text search does not work with multi valued properties when using the default query engine - JBoss Issu…