[jira] [Created] (SOLR-9070) how to range search on the field which contains multiple decimal point (eg: 2.5.0.4)

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

Santhosh created SOLR-9070:
------------------------------

             Summary: how to range search on the field which contains multiple decimal point (eg: 2.5.0.4)
                 Key: SOLR-9070
                 URL: https://issues.apache.org/jira/browse/SOLR-9070
             Project: Solr
          Issue Type: Bug
          Components: search
    Affects Versions: 3.6.1
            Reporter: Santhosh
            Priority: Blocker


Hi,

I have issue in my server. As I stated in the subject I want to do range search query on the field (eg: filed name is “version”) which contains value like (2.5.0.1, 2.5.0.4 and 2.5.0.10 etc).

When I do range search on the “version” field with criteria [* TO 2.5.0.5], it gave me all the value like (2.5.0.1, 2.5.0.10, 2.5.0.4). But this is wrong result. Since I was expecting only 2.5.0.1 and 2.5.0.4. 
But it include 2.5.0.10 with the results. I googled and found that solr does lexical sorting. But I want numerical sorting. I declared the field type as string in schema.xml.

I did the following solution but nothing worked. 
•	Converted the field type to number. But it gave me “NumberFormatException”.  Because java does not allow multiple decimal point.
•	I added left pad 0 with the value while adding document in solr. But no luck

Can you please give me good solution to come out of the issue?




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org