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

This message was sent by Atlassian JIRA

View raw message