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
>
