Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Date: Tue, 19 Jun 2012 17:03:42 +0000 (UTC)
From: "Alexander Klimetschek (JIRA)" <jira@apache.org>
To: dev@jackrabbit.apache.org
Message-ID: <285405945.30536.1340125422667.JavaMail.jiratomcat@issues-vm>
In-Reply-To: <1710699145.25202.1340032842948.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Commented] (JCR-3347) Searches on properties of type Double
 give unexpected results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/JCR-3347?page=3Dcom.atlassian.j=
ira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D133969=
26#comment-13396926 ]=20

Alexander Klimetschek commented on JCR-3347:
--------------------------------------------

I think you mean the DECIMAL type. The above query should work using a doub=
le value for the comparison:

SELECT * FROM [nt:unstructured] WHERE price > 50.0

               =20
> Searches on properties of type Double give unexpected results
> -------------------------------------------------------------
>
>                 Key: JCR-3347
>                 URL: https://issues.apache.org/jira/browse/JCR-3347
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>         Environment: Linux (Ubuntu 12.04), Oracle Java 1.6.0_31
>            Reporter: Felix Oghin=C4=83
>
> Example:
> * have a node with a Double property, e.g. price=3D25
> * The following query returns the node, although it shouldn't:
> SELECT * FROM [nt:unstructured] WHERE price > 50

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira