Many thanks for your reply. I have changed my query to
staffName_txt:["GROSS BOB" TO "LINDMAR DEBORAH"]
staffName_txt:["gross bob" TO "lindmar deborah"]
staffName_txt:["Gross Bob" TO "lindmar Deborah"]
Their "numFound" are identical (177). Apart from "Mr Kenyon John", my
search result contains " Saab Jerry", which is very confusing.
Therefore, I think the problem is probably not because of "character case"
On Fri, 7 Jan 2022 at 17:12, Srijan <shree...@gmail.com> wrote:
> My guess is inconsistent "character case" (uppercase/lowercase) in your
> indexed data vs your search query. For example, I would expect something
> like staffName_txt:[ "Gross Bob" TO "lindmar Deborah"] to return "Mr
> Kenyon John" as M indeed does lie between G and l.
>
> On Fri, Jan 7, 2022 at 11:10 AM WU, Zhiqing <z...@ennov.com> wrote:
>
> > Hello,
> > I am learning Solr.
> > In "The Standard Query Parser", I find:
> > Range queries are not limited to date fields or even numerical fields,
> but
> > also use with non-date fields (e.g. title:{Aida TO Carmen})
> >
> > I tried a range query in a Solr database (8.3)
> > staffName_txt:[ "Gross Bob" TO "Lindmar Deborah"]
> > staffName_txt is defined as a TextField.
> > Most searched results are correct but "Mr Kenyon John" is also in the
> > result list.
> > I think 'M' is after 'L' and should not be included in the result.
> > May I ask what is wrong in my query? Is there a way to avoid the problem?
> > Many thanks in advance.
> > Kind regards,
> > Zhiqing
> >
>
