Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Message-ID: <8784715.1170668045849.JavaMail.jira@brutus>
Date: Mon, 5 Feb 2007 01:34:05 -0800 (PST)
From: "Marcel Reutegger (JIRA)" <jira@apache.org>
To: dev@jackrabbit.apache.org
Subject: [jira] Resolved: (JCR-732) xpath jcr:contains() and sql contains()
 return differents results
In-Reply-To: <28939819.1170583625709.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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