Fuzzy search error

Marek · December 27, 2024, 8:27pm

I’m using new fuzzy functionality New fuzzy search and autocomplete in Manticore Search
but sometimes I getting error:
Undefined array key “Variable_name” [ SELECT product_id, weight() as score FROM mage_catalog_product WHERE MATCH(‘citrin’) LIMIT 0, 1000 OPTION fuzzy = 1, layouts = ‘us,ua,ru’, distance = 2]

Error apears only in query with “fuzzy = 1” option enabled.

Marek · December 30, 2024, 7:19am

Maybe someone had similar error? Thanks!

Sergey · December 30, 2024, 5:24pm

github.com/manticoresoftware/manticoresearch

fuzzy=1 ERROR Undefined array key "Variable_name"

opened 02:34PM - 27 Dec 24 UTC

aiskendi

bug rel::upcoming

### Bug Description: ```bash # I get this error after some time running fuzzy=…1, layouts='' with mysql mysql> SELECT * FROM keyword WHERE MATCH('adu ape') ORDER BY total_found DESC, hit DESC LIMIT 0,20 OPTION fuzzy=1, layouts=''; ERROR 1064 (42000): Undefined array key "Variable_name" mysql> SELECT * FROM keyword WHERE MATCH('test') ORDER BY total_found DESC, hit DESC LIMIT 0,20 OPTION fuzzy=1, layouts=''; ERROR 1064 (42000): Undefined array key "Variable_name" mysql> SELECT * FROM keyword WHERE MATCH('test') ORDER BY total_found DESC, hit DESC LIMIT 0,20 OPTION fuzzy=1, layouts=''; ERROR 1064 (42000): Undefined array key "Variable_name" mysql> SELECT * FROM keyword WHERE MATCH('test') ORDER BY total_found DESC, hit DESC LIMIT 0,20 OPTION fuzzy=1, layouts=''; ERROR 1064 (42000): Undefined array key "Variable_name" ``` I have tried restart manticore and no error at first but after some time it ERROR again. ### Manticore Search Version: Manticore 6.3.9 aa1c56713@24122619 dev (columnar 2.3.1 9d9a466@24122408) (secondary 2.3.1 9d9a466@24122408) (knn 2.3.1 9d9a466@24122408) ### Operating System Version: 22.04.2 LTS (Jammy Jellyfish) ### Have you tried the latest development version? Yes ### Internal Checklist: <sup>To be completed by the assignee. Check off tasks that have been completed or are not applicable.</sup> <details> - [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated </details>