problems finding negative values
Hi, I have an index consisting on the following fields: field name=id type=long indexed=true stored=true/ field name=length type=integer indexed=true stored=true/ field name=key type=integer indexed=true stored=true multiValued=true / Each doc has a few key values, some of which are negative. Ok, I know there's a document that has both 826606443 and -1861807411 If I search with http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=-1861807411fl=id,length,key I get no results, but if I do http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=826606443fl=id,length,key I get the document as expected. Obviously the key field is configured as a search field, indexed, etc. but somehow solr doesn't like negatives. I'm assuming this might have something to do with analysers but can't tell how to fix it.. any ideas?? Thanks galo
Re: problems finding negative values
On 4/4/07, galo [EMAIL PROTECTED] wrote: Hi, I have an index consisting on the following fields: field name=id type=long indexed=true stored=true/ field name=length type=integer indexed=true stored=true/ field name=key type=integer indexed=true stored=true multiValued=true / Each doc has a few key values, some of which are negative. Ok, I know there's a document that has both 826606443 and -1861807411 If I search with http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=-1861807411fl=id,length,key I get no results, but if I do http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=826606443fl=id,length,key I get the document as expected. Obviously the key field is configured as a search field, indexed, etc. but somehow solr doesn't like negatives. I'm assuming this might have something to do with analysers but can't tell how to fix it.. any ideas?? It doesn't have anything to do with analyzers, it has to do with the Lucene query parser that Solr uses. A minus sign means must not appear, so q=-1861807411 means 1861807411 must not appear in the default search field. Try escaping the - by enclosing the search term in quotes, or backslash escaping it. q=-1861807411 -Yonik
Re: problems finding negative values
This one caught us as well. Refer to http://lucene.apache.org/java/docs/queryparsersyntax.html#Escaping%20Special%20Charactersfor understanding what characters need to be escaped for your queries. On 4/4/07, galo [EMAIL PROTECTED] wrote: Hi, I have an index consisting on the following fields: field name=id type=long indexed=true stored=true/ field name=length type=integer indexed=true stored=true/ field name=key type=integer indexed=true stored=true multiValued=true / Each doc has a few key values, some of which are negative. Ok, I know there's a document that has both 826606443 and -1861807411 If I search with http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=-1861807411fl=id,length,key I get no results, but if I do http://localhost:8080/solr/select/?stylesheet=version=2.1start=0rows=50indent=onq=826606443fl=id,length,key I get the document as expected. Obviously the key field is configured as a search field, indexed, etc. but somehow solr doesn't like negatives. I'm assuming this might have something to do with analysers but can't tell how to fix it.. any ideas?? Thanks galo