[jira] [Commented] (OAK-3377) Two spaces in SQL2 fulltext search -> error

["Laurie byrum (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14735692#comment-14735692 ] 

Laurie byrum commented on OAK-3377:
-----------------------------------

This is a partial stack trace that led to this bug:

[...]
Caused by: java.io.IOException: could not query JCR resource: SELECT * FROM [social:asiResource] AS c WHERE (CONTAINS(c.[jcr:title], 'and news.  Mr. Bennet was among the earliest of those') OR CONTAINS(c.[jcr:description], 'and news.  Mr. Bennet was among the earliest of those')) AND (ISDESCENDANTNODE(c, '/content/usergenerated/asi/jcr/content/geometrixx-media/en') OR ISDESCENDANTNODE(c, '/content/usergenerated/content/geometrixx-media/en')) ORDER BY added DESC
	... 265 common frames omitted
Caused by: javax.jcr.query.InvalidQueryException: java.lang.IllegalArgumentException: Invalid expression: 'and news.  Mr. Bennet was among the earliest of those'
	at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:142)
	at org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:101)
	at org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:98)
	at org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.perform(SessionDelegate.java:216)
	at org.apache.jackrabbit.oak.jcr.query.QueryImpl.execute(QueryImpl.java:97)
	at com.adobe.cq.social.datastore.jcr.impl.SocialJcrResourceProvider.fetchWithTotal(SocialJcrResourceProvider.java:905)
	at com.adobe.cq.social.datastore.jcr.impl.SocialJcrResourceProvider.find(SocialJcrResourceProvider.java:867)
	... 264 common frames omitted
Caused by: java.lang.IllegalArgumentException: Invalid expression: 'and news.  Mr. Bennet was among the earliest of those'
	at org.apache.jackrabbit.oak.query.ast.FullTextSearchImpl.getFullTextConstraint(FullTextSearchImpl.java:146)
	at org.apache.jackrabbit.oak.query.ast.OrImpl.getFullTextConstraint(OrImpl.java:150)
	at org.apache.jackrabbit.oak.query.ast.AndImpl.getFullTextConstraint(AndImpl.java:99)
	at org.apache.jackrabbit.oak.query.ast.SelectorImpl.createFilter(SelectorImpl.java:389)
	at org.apache.jackrabbit.oak.query.ast.SelectorImpl.prepare(SelectorImpl.java:283)
	at org.apache.jackrabbit.oak.query.QueryImpl.prepare(QueryImpl.java:568)
	at org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:183)
	at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:132)
	... 270 common frames omitted
Caused by: java.text.ParseException: FullText expression: and news.  (*)Mr. Bennet was among the earliest of those; expected: term
	at org.apache.jackrabbit.oak.query.fulltext.FullTextParser.getSyntaxError(FullTextParser.java:198)
	at org.apache.jackrabbit.oak.query.fulltext.FullTextParser.parseTerm(FullTextParser.java:185)
	at org.apache.jackrabbit.oak.query.fulltext.FullTextParser.parseAnd(FullTextParser.java:75)
	at org.apache.jackrabbit.oak.query.fulltext.FullTextParser.parseOr(FullTextParser.java:55)
	at org.apache.jackrabbit.oak.query.fulltext.FullTextParser.parse(FullTextParser.java:49)
	at org.apache.jackrabbit.oak.query.ast.FullTextSearchImpl.getFullTextConstraint(FullTextSearchImpl.java:143)
	... 277 common frames omitted


> Two spaces in SQL2 fulltext search -> error
> -------------------------------------------
>
>                 Key: OAK-3377
>                 URL: https://issues.apache.org/jira/browse/OAK-3377
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.0.19
>            Reporter: Laurie byrum
>
> Execute the following SQL2 query (eg, in crx/de's query tool)
> SELECT * FROM [nt:unstructured] AS c WHERE (CONTAINS(c.[jcr:title], 'a  b') AND ISDESCENDANTNODE(c, '/content'))
> (note there are 2 spaces between "a" and "b")
> Result: java.lang.IllegalArgumentException: Invalid expression: 'a b'
> If there is only 1 space between a and b, there is no error. 
> Per jsr-283, fulltext expressions should be able to have strings of whitespace.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)