Problem using Lucene RangeQuery

Question

I'm using Rangequery to get all the documents which have amount between say 0 to 2. When i execute the query, Lucene gives me documents which have amount greater than 2 also...What am i missing here?

Here is my code: Term lowerTerm = new Term("amount", minAmount); Term upperTerm = new Term("amount", maxAmount);

            RangeQuery amountQuery = new RangeQuery(lowerTerm, upperTerm, true);

            finalQuery.Add(amountQuery, BooleanClause.Occur.MUST);

and here is what goes into my index:

doc.Add(new Field("amount", amount.ToString(), Field.Store.YES, Field.Index.UN_TOKENIZED, Field.TermVector.YES));

Answer 1

I created a PHP function that convert numerics to lucene/solr range searchables.

0.5 is converted to 10000000000.5
-0.5 is converted to 09999999999.5

function luceneNumeric($numeric)
{
    $negative = $numeric < 0;
    $numeric = $negative ? 10000000000 + $numeric : $numeric;

    $parts = explode('.', str_replace(',', '.', $numeric));

    $lucene = $negative ? 0 : 1;
    $lucene .= str_pad($parts[0], 10, '0', STR_PAD_LEFT);
    $lucene .= isset($parts[1]) ? '.' . $parts[1] : '';

    return $lucene;
}

It seems to work, hope this helps someone!