[jira] [Resolved] (OAK-859) Query engine skips fulltext search conditions in the filter

["Alex Parvulescu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OAK-859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alex Parvulescu resolved OAK-859.
---------------------------------

    Resolution: Duplicate

it looks like this issue will be tracked in OAK-890
                
> Query engine skips fulltext search conditions in the filter
> -----------------------------------------------------------
>
>                 Key: OAK-859
>                 URL: https://issues.apache.org/jira/browse/OAK-859
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: core
>            Reporter: Alex Parvulescu
>
> I have a fulltext search that contains a bunch of 'or' conditions
> {code}
> /jcr:root/content/geometrixx-media/en//element(*, nt:hierarchyNode)[(jcr:contains(jcr:content, 'blockbuster') or jcr:contains(jcr:content/@jcr:title, 'blockbuster') or jcr:contains(jcr:content/@jcr:description, 'blockbuster'))]/rep:excerpt(.) order by @jcr:score descending
> {code}
> this gets transformed into the following sql2
> {code}
> select [jcr:path], [jcr:score], [rep:excerpt] from [nt:hierarchyNode] as a where (contains([jcr:content/*], 'blockbuster') or contains([jcr:content/jcr:title], 'blockbuster') or contains([jcr:content/jcr:description], 'blockbuster')) and isdescendantnode(a, '/content/geometrixx-media/en') order by [jcr:score] desc 
> {code}
> The problem here is that the query engine will skip the full text conditions when generating the 'filter' object used in the _#getCost_ and _#query_ so that the fulltext index cannot factor the info in.
> The aforementioned query currently generates a lot of traversals.
> Unit tests on this parts are a bit tricky, so I cannot attach a real test yet, I can only point out that FilterImpl#fulltextConditions is emtpy

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira