jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bharat Kasodariya (JIRA)" <j...@apache.org>
Subject [jira] [Created] (JCR-3749) Compare values as doubles in a JCR-SQL2 query
Date Tue, 18 Mar 2014 04:45:44 GMT
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)

Mime
View raw message