You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Alexander Klimetschek (JIRA)" <ji...@apache.org> on 2012/06/19 19:03:42 UTC

[jira] [Commented] (JCR-3347) Searches on properties of type Double give unexpected results

    [ https://issues.apache.org/jira/browse/JCR-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13396926#comment-13396926 ] 

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

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

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

                
> 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ă
>
> Example:
> * have a node with a Double property, e.g. price=25
> * 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 administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira