[JCR-436] InvalidQueryException thrown for a SQL query using WHERE CONTAINS(., 'someword')

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9, 1.0, 1.0.1
• Fix Version/s: 1.1
• Component/s: query
• Assignee: Unassigned
• Reporter: Raphael Jean
• Created: 18/May/06 16:18
• Updated: 31/May/06 15:41
• Resolved: 31/May/06 15:25

Description

The following SQL query:
SELECT * FROM es:document WHERE CONTAINS(., 'software')
throws an InvalidQueryException exception.

javax.jcr.query.InvalidQueryException: Encountered "." at line 1, column 42.
Was expecting one of:
"BY" ...
"IN" ...
"OR" ...
"IS" ...
"AND" ...
"LIKE" ...
"NULL" ...
"FROM" ...
"ORDER" ...
"WHERE" ...
"SELECT" ...
"BETWEEN" ...
"*" ...
<REGULAR_IDENTIFIER> ...
<DELIMITED_IDENTIFIER> ...

This syntax seems correct according to the latest jcr spec (1.0.1).
Using an asterisk instead of a dot (.) as the first parameter of CONTAINS() works fine.