Hello,
I have issued problem with exact search in manticore while sphinx returns correct values.
This is the way I created my real time table:
CREATE TABLE ads_wf (
id BIGINT,
name TEXT indexed,
description TEXT indexed,
categoryname TEXT indexed
.
.
.
.
)
wordforms = ‘/etc/manticoresearch/wordforms.txt’
charset_table = ‘0…9, A…Z->a…z, _, a…z, U+017E->z, U+017D->z, U+0161->s, U+0160->s, U+0107->c, U+0106->c, U+010C->c, U+010D->c, U+0111->d, U+0110->d, U+0430->a, U+0431->b, U+0432->v, U+0433->g, U+0434->d, U+0452->d, U+0435->e, U+0436->z, U+0437->z, U+0438->i, U+0458->j, U+043A->k, U+043B->l, U+043C->m, U+043D->n, U+043E->o, U+043F->p, U+0440->r, U+0441->s, U+0442->t, U+045B->c, U+0443->u, U+0444->f, U+0445->h, U+0446->c, U+0447->c, U+045F->U+01C6, U+0448->s, U+0410->a, U+0411->b, U+0412->v, U+0413->g, U+0414->d, U+0402->d, U+0415->e, U+0416->z, U+0417->z, U+0418->i, U+0419->j, U+041A->k, U+041B->l, U+041C->m, U+041D->n, U+041E->o, U+041F->p, U+0420->r, U+0421->s, U+0422->t, U+040B->c, U+0423->u, U+0424->f, U+0425->h, U+0426->c, U+0427->c, U+040F->U+01C4, U+0428->s’
min_prefix_len = ‘3’
html_strip = ‘1’
blend_chars = ‘+, -, &, U+23’
prefix_fields = ‘name,description’
expand_keywords = ‘1’ - here I also tried ‘exact’
index_exact_words = ‘1’
;
When I do the exact search for “ryzen 9 7900” manticore returns values like ryzen 9 7900 X, ryzen 9 7900X, ryzen 9 7900XT, ryzen 9 7900x and other irrelevant results while sphinx returns exact matches. Behavior is the same on my production server as well as on local environment.
Query that Im running from mysql using SphinxSE is:
SELECT SQL_NO_CACHE id AS ad_id, weight AS relevance, sph.posted FROM mnt_ads_wf_rt AS sph WHERE sph.query = '(@(name,categoryName) \=\"ryzen 9 7900\");mode=extended2;fieldweights=name,8,description,3,categoryName,1,adIdTag,6,topTag,9,priorityTag,5,normalTag,0;sort=extended:WEIGHT() DESC,posted DESC;offset=0;limit=10000;maxmatches=19999;ranker=expr:(sum((4*…… the rest of ranker
Any idea what Im doing wrong and what could fix this issue?
Thanks.