[jira] [Created] (JCR-3749) Compare values as doubles in a JCR-SQL2 query

["Bharat Kasodariya (JIRA)" <ji...@apache.org>]

Bharat Kasodariya created JCR-3749:
--------------------------------------

             Summary: Compare values as doubles in a JCR-SQL2 query
                 Key: JCR-3749
                 URL: https://issues.apache.org/jira/browse/JCR-3749
             Project: Jackrabbit Content Repository
          Issue Type: Bug
            Reporter: Bharat Kasodariya


I am trying to compare JCR node's string properties with a double value in JCR-SQL2. But it is comparing the values as strings.
For example:
SELECT * FROM [nodex] as x where x.propertyY <= 20.50
Here propertyY is the string in the definition.
I tried this with CASE but it still does not work. Can I compare it as double without changing the property definition?
I posted question here
http://stackoverflow.com/questions/22300610/compare-values-as-doubles-in-a-jcr-sql2-query



--
This message was sent by Atlassian JIRA
(v6.2#6252)