[
https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15013600#comment-15013600
]
Davide Giannella commented on OAK-2539:
---------------------------------------
if it returns the right resultset it is :)
By looking at the logs I can see the query engine detected a condition in the
original query that is better suited with a Union even if the cost of the first
is lower (see cost overhead)
{noformat}
QueryEngineImpl actualCost: 2100.0 - costOverhead: 1.7976931348623157E308 -
overallCost: 1.7976931348623157E308
{noformat}
so on paper I'd say it's resolved.
> SQL2 query not working with filter (s.[stringa] = 'a' OR
> CONTAINS(s.[stringb], 'b'))
> ------------------------------------------------------------------------------------
>
> Key: OAK-2539
> URL: https://issues.apache.org/jira/browse/OAK-2539
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: core, query
> Reporter: Calvin Wong
> Assignee: Davide Giannella
> Fix For: 1.4
>
>
> Create node /content/usergenerated/qtest with jcr:primaryType nt:unstrucuted.
> Add 2 String properties: stringa = "a", stringb = "b".
> Use query tool in CRX/DE to do SQL2 search:
> This search will find qtest:
> SELECT * FROM [nt:base] AS s WHERE
> ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'a' OR
> CONTAINS(s.[stringb], 'b'))
> This search will find qtest:
> SELECT * FROM [nt:base] AS s WHERE
> ISDESCENDANTNODE([/content/usergenerated/]) AND (CONTAINS(s.[stringb], 'b'))
> This search will not find qtest:
> SELECT * FROM [nt:base] AS s WHERE
> ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'x' OR
> CONTAINS(s.[stringb], 'b'))
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
