manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
8.93k stars 495 forks source link

bool + must + fuzzy is not working #2568

Open sanikolaev opened 1 week ago

sanikolaev commented 1 week ago

Bug Description:

MRE

snikolaev@dev2:~$ mysql -P9306 -h0 -e "drop table if exists t; create table t(f text) min_infix_len='2'; insert into t values(1, 'something');"
snikolaev@dev2:~$ curl -sX POST http://localhost:9308/search  -d ' { "index": "t", "query": { "bool": { "must": [ { "match": { "*": "ыщьуерштп" } } ] } }, "options": { "fuzzy": true } } '|jq .
{
  "took": 0,
  "timed_out": false,
  "hits": {
    "total": 0,
    "total_relation": "eq",
    "hits": []
  }
}

Expected: doc found

Manticore Search Version:

Manticore 6.3.7 53ae190b8@24091306 dev (columnar 2.3.1 f9ef8b9@24090411) (secondary 2.3.1 f9ef8b9@24090411) (knn 2.3.1 f9ef8b9@24090411)

Operating System Version:

Ubuntu Jammy (dev2)

Have you tried the latest development version?

None

Internal Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

- [x] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated
donhardman commented 3 days ago

Fixed in https://github.com/manticoresoftware/manticoresearch-buddy/pull/355

I think we should cover the HTTP protocol with tests in a similar way to how we do it for SQL, and also add the current MRE (Minimal Reproducible Example) to it.

Let's do the same test cases as we did before in SQL, but also via HTTP endpoints, because they may work slightly differently for fuzzy logic.