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