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

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

> FYI, if you plan on using Decimal values, use SQL2, as Xpath and SQL don't 
> really have full support for that data type.

If the effort isn't too high, I would opt for implementing it using the double 
representation (50.0) for xpath & sql. Seems intuitive to me. WDYT?
                
> Searches on properties of type Decimal give unexpected results
> --------------------------------------------------------------
>
>                 Key: JCR-3347
>                 URL: https://issues.apache.org/jira/browse/JCR-3347
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>            Reporter: Felix Oghină
>            Assignee: Jukka Zitting
>
> Example:
> * have a node with a Decimal property, e.g. price=25
> * The following XPath query returns the node, although it shouldn't:
> /jcr:root/content//*[@d_price > 50.0]

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


Reply via email to