[jira] Resolved: (JCR-732) xpath jcr:contains() and sql contains() return differents results

["Marcel Reutegger (JIRA)" <ji...@apache.org>]

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

Marcel Reutegger resolved JCR-732.
----------------------------------

    Resolution: Invalid

The first parameter in the SQL contains function is specified as the name of a property. See section 8.5.4.5 of the JSR 170 specification.

XPath in contrast also allows to specify an axis in addition to a name, thus it is possible to reference a property name or a node name.

The above XPath statement refers to a node named okm:content.

> xpath jcr:contains() and sql contains() return differents results
> -----------------------------------------------------------------
>
>                 Key: JCR-732
>                 URL: https://issues.apache.org/jira/browse/JCR-732
>             Project: Jackrabbit
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>         Environment: Ubuntu Linux
>            Reporter: Paco Avila
>
> I think that these queries equivalents:
> XPATH: //element(*, okm:document)[jcr:contains(okm:content, 'naranjas')]
> and
> SQL: SELECT * FROM okm:document WHERE CONTAINS(okm:content, 'naranjas')
> But the XPATH one works and the SQL doesn't return anything.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.