[ 
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)

Reply via email to