[SOLR-9568] case-insensitive sorting not working as intended.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 4.10.3
• Labels: dynamic sorting
• Assignee: Unassigned
• Reporter: satish chennupati
• Created: 26/Sep/16 14:45
• Updated: 08/Jun/19 15:28
• Resolved: 25/May/18 18:36

Description

Hi,

Right now when I perform a sort I am getting result as following:

"[\"18 hotfix3\"]"
"[\"Godzilla\"]"
"[\"Godzilla, King of the Monsters!\"]"
"[\"Harry Potter and the Sorcerers Stone\"]"
"[\"How to Train Your Dragon\"]"
"[\"Jurassic Park\"]"
"[\"My Big Fat Greek Wedding\"]"
"[\"National Treasure\"]"
"[\"Palmer\"]"
"[\"Patch Adams\"]"
"[\"Rajan\"]"
"[\"Sanity\"]"
"[\"Stardust\"]"
"[\"Superman\"]"
"[\"The Amazing Spider-Man 2\"]"
"[\"The Godfather\"]"
"[\"The Lord of the Rings: The Fellowship of the Ring\"]"
"[\"The Matrix\"]"
"[\"V for Vendetta\"]"
"[\"abcdefgh\"]"
"[\"autoui1466571231695\"]"
"[\"autoui1466605339320\"]"
"[\"name\"]"
"[\"test\"]"
"[\"test2\"]"

The field type has been defined as follows :

<fieldType class="org.apache.solr.schema.TextField" name="TextField" sortMissingLast="true">
<analyzer>
<tokenizer class="solr.KeywordTokenizerFactory"/>
<!-- lower case everything -->
<filter class="solr.LowerCaseFilterFactory"/>
<!-- remove lead/trail whitespace -->
<filter class="solr.TrimFilterFactory"/>
<!-- pad and trim numbers to an even 6 digits with leading 0's -->
<filter class="solr.PatternReplaceFilterFactory"
pattern="(\d+)" replacement="00000$1" replace="all"/>
<filter class="solr.PatternReplaceFilterFactory"
pattern="0*([0-9]

{6,}

)" replacement="$1" replace="all" />

</analyzer>
</fieldType>

And for sorting purpose we have a dynamic field in place that used the above field type
<!-- fields for sorting -->
<dynamicField indexed="true" multiValued="false" name="sort_str*" stored="false" type="SortTextField"/>