[SOLR-11367] no search results for specific search

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 6.6
• Component/s: search

Environment

Solr 6.6.0 on Windows 10 (latest updates)

• Assignee: Unassigned
• Reporter: Sascha Tuschinski
• Created: 19/Sep/17 08:49
• Updated: 08/Jun/19 15:20
• Resolved: 19/Sep/17 15:25

Description

We are using a Solr Core with field names defined like "f_1179014266_txt". The number in the middle of the name differs for each field we use. For language specific fields we are adding an language specific extension e.g. "f_1179014267_txt_fr", "f_1179014268_txt_de", "f_1179014269_txt_en" and so on.

We are having the following odd issue within the french "_fr" field only:

• The saved value which had been added with no problem to the Solr index is "FRaoo".
• When searching within the Solr query tool for "f_1197829839_txt_fr:*FRao*" it returns the items matching the term - OK

{
  "responseHeader":{
    "status":0,
    "QTime":1,
    "params":{
      "q":"f_1197829839_txt_fr:*FRao*",
      "indent":"on",
      "wt":"json",
      "_":"1505808887827"}},
  "response":{"numFound":1,"start":0,"docs":[
      {
        "id":"129",
        "f_1197829834_txt_en":"EnAir",
        "f_1197829822_txt_de":"Lufti",
        "f_1197829835_txt_fr":"FRaoi",
        "f_1197829836_txt_it":"ITAir",
        "f_1197829799_txt":["Lufti"],
        "f_1197829838_txt_en":"EnAir",
        "f_1197829839_txt_fr":"FRaoo",
        "f_1197829840_txt_it":"ITAir",
        "_version_":1578520424165146624}]
  }}

• When searching for "f_1197829839_txt_fr:*FRaoo*" NO item is found - Wrong

{
  "responseHeader":{
    "status":0,
    "QTime":1,
    "params":{
      "q":"f_1197829839_txt_fr:*FRaoo*",
      "indent":"on",
      "wt":"json",
      "_":"1505808887827"}},
  "response":{"numFound":0,"start":0,"docs":[]
  }}

• When searching for "f_1197829839_txt_fr:FRaoo" (no wildcards) the matching items are found - OK

  {
    "responseHeader":{
      "status":0,
      "QTime":1,
      "params":{
        "q":"f_1197829839_txt_fr:FRaoo",
        "indent":"on",
        "wt":"json",
        "_":"1505808887827"}},
    "response":{"numFound":1,"start":0,"docs":[
        {
          "id":"129",
          "f_1197829834_txt_en":"EnAir",
          "f_1197829822_txt_de":"Lufti",
          "f_1197829835_txt_fr":"FRaoi",
          "f_1197829836_txt_it":"ITAir",
          "f_1197829799_txt":["Lufti"],
          "f_1197829838_txt_en":"EnAir",
          "f_1197829839_txt_fr":"FRaoo",
          "f_1197829840_txt_it":"ITAir",
          "_version_":1578520424165146624}]
    }}
  

  If we save exact the same value into a different language field e.g. ending on "_en", means "f_1197829834_txt_en", then the search "f_1197829834_txt_en:*FRaoo*" find all items correctly!
  We have no idea what's wrong here and we even recreated the index and can reproduce this problem all the time. I can only see that the value starts with "FR" and the field extension ends with "fr" but this is not problem for "en", "de" etc. All fields are used in the same way and have the same field properties.
  Any help or ideas are highly appreciated.