exact form modified vs expanded keywords

[sanikolaev]

Currently exact form modified = doesn't prevent expanding keywords, e.g.:

mysql> drop table if exists t;create table t(f text) min_infix_len='1' expand_keywords='1'; insert into t values(1,'abc'),(2,'bc');  
mysql> select * from t where match('=bc');  
 ------ ------   
| id   | f    |  
 ------ ------   
|    2 | bc   |  
|    1 | abc  |  
 ------ ------   
2 rows in set (0.00 sec)  
mysql> show meta;  
 --------------- -------   
| Variable_name | Value |  
 --------------- -------   
| total         | 2     |  
| total_found   | 2     |  
| time          | 0.002 |  
| keyword[0]    | *bc*  |  
| docs[0]       | 2     |  
| hits[0]       | 2     |  
| keyword[1]    | bc    |  
| docs[1]       | 1     |  
| hits[1]       | 1     |  
 --------------- -------   
9 rows in set (0.00 sec)  

It would be good to fix it.

[githubmanticore]

➤ Stan commented:

also need to check wildcard modifiers, ie term? not get replaced by *term*

[glukkkk]

@sanikolaev @githubmanticore

Hello! Any news?

[sanikolaev]

No news. This task is not in our nearest plans, but we'll be happy to review and accept a pull request.

[glukkkk]

@sanikolaev Maybe there is some workaround for this?

[sanikolaev]

expand_keywords=0 ?

[sanikolaev]

Or expand_keywords=exact

[glukkkk]

@sanikolaev In fact we need to keep expand_keywords = 1, but have the ability to search by exact phrase.

[sanikolaev]

Can't think of another workaround.

[glukkkk]

@sanikolaev Hello! Half a year has passed :) Maybe you have any good news for me?

[sanikolaev]

Hello @glukkkk

Sure, the good news are that:

• Manticore Columnar Library now supports RT indexes
• You can do ALTER to add/remove full-text field
• Secondary indexes are in progress
• Auto OPTIMIZE is almost done
• Manticore Helm chart and Prometheus exporter are ready
• Ukrainian lemmatizer has been implemented

All these tasks were of a higher priority for us since we believe it's more important for the community at the moment or someone wanted to sponsor development of some of these features, which allowed us to sustain the development in general. Unfortunately, this issue is of a lower priority and will be so until we are done with more important things or until someone makes a merge request. Thank you for your understanding.