I have two nodes with names name1 and name2. I execute full text search on them using JCR-SQL2.

When I look for text name1 or name2 works ok.
When I look for

name*

it finds them both - ok.
But for

*name*

it finds nothing.

If I name these nodes 1name and 2name.

*name

also finds nothing.

Query string:

SELECT a.* FROM [my:type] AS a WHERE CONTAINS(a.*, '*name*')