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