Potential bug with array searchable attributes about meilisearch

[NarHakobyan]

hi @irevoire,

Deleted all the settings (reseted to defaults) and Saved settings again, but it did not work

tested with latest version

{
    "commitSha": "0259ad6082cde748ac0478c03c49d8d9a1859e87",
    "commitDate": "2024-03-27T16:49:40.000000000Z",
    "pkgVersion": "1.7.4"
}

[irevoire]

I reproduced the bug on the latest main.
It's really strange because no results are returned with "Ability" when this document exists:

{
      "id": "d81983f7-f7dc-4ddd-8fec-4e6cc39a7bd0",
      "translations": [
        {
          "id": "064ee085-cab1-44f4-8908-3ff52c1f677b",
          "languageCode": "EN",
          "title": "Ability to keep deadlines"
        },
        {
          "id": "ec40ab8f-ec31-4248-af78-aa9490f0f6e7",
          "languageCode": "HY",
          "title": "Ժամկետները պահպանելու ունակություն"
        }
      ],
      "type": "SOFT",
      "title": "Ability to keep deadlines"
    }

But I do get results when I look for any other word even when they're at the start of the document like "Constructive":

{
      "id": "eaa4e19d-adf4-49bf-adc3-1d98d6ed7e13",
      "translations": [
        {
          "id": "dff49658-5449-4c26-899a-8c0f3891560c",
          "languageCode": "EN",
          "title": "Constructive feedback giving"
        },
        {
          "id": "95cbebfb-0b4b-4c3e-9cb4-4c94867c125e",
          "languageCode": "HY",
          "title": "Կառուցողական հետադարձ կապի տրամադրում"
        }
      ],
      "type": "SOFT",
      "title": "Constructive feedback giving"
    }

The only difference I can see between Ability and any other word is that there are 8 documents starting with Ability without only one or two for every other word.

[Fronix]

I reproduced the bug on the latest main. It's really strange because no results are returned with "Ability" when this document exists:

{
      "id": "d81983f7-f7dc-4ddd-8fec-4e6cc39a7bd0",
      "translations": [
        {
          "id": "064ee085-cab1-44f4-8908-3ff52c1f677b",
          "languageCode": "EN",
          "title": "Ability to keep deadlines"
        },
        {
          "id": "ec40ab8f-ec31-4248-af78-aa9490f0f6e7",
          "languageCode": "HY",
          "title": "Ժամկետները պահպանելու ունակություն"
        }
      ],
      "type": "SOFT",
      "title": "Ability to keep deadlines"
    }

But I do get results when I look for any other word even when they're at the start of the document like "Constructive":

{
      "id": "eaa4e19d-adf4-49bf-adc3-1d98d6ed7e13",
      "translations": [
        {
          "id": "dff49658-5449-4c26-899a-8c0f3891560c",
          "languageCode": "EN",
          "title": "Constructive feedback giving"
        },
        {
          "id": "95cbebfb-0b4b-4c3e-9cb4-4c94867c125e",
          "languageCode": "HY",
          "title": "Կառուցողական հետադարձ կապի տրամադրում"
        }
      ],
      "type": "SOFT",
      "title": "Constructive feedback giving"
    }

The only difference I can see between Ability and any other word is that there are 8 documents starting with Ability without only one or two for every other word.

Yeah I can't make heads or tails of this, I also tried other words at the beginning and they worked fine but Ability doesn't.

[jzabroski]

If you point me to the area of code that likely does this, happy to spend time and debug it.

[NarHakobyan]

Sorting also works incorrectly

Screen.Recording.2024-02-21.at.00.01.58.mov

[irevoire]

Hey @jzabroski,

Sorting also works incorrectly

Which version are you using?
We fixed a bug in the latest version of meilisearch (v1.6.2)

[NarHakobyan]

Hey @jzabroski,

Sorting also works incorrectly

Which version are you using? We fixed a bug in the latest version of meilisearch (v1.6.2)

I'm using v1.6.0 version doesn't work in v1.6.2

[irevoire]

Hey @NarHakobyan,

After updating to the latest version, have you re-indexed your documents?
Since the bug corrupts the database, you need to re-index everything to see the fix.

The easiest way to do that if you can’t clear your index and send back all your documents is to:

• Remove all your filterable attributes
• Wait until the task is fully processed; this is very important; otherwise, there is a risk meilisearch understand what you’re doing and optimize it out
• Send back all your filterable attributes

If you updated your version through a dump, none of this applies.