Problem with quick selection in link fields (maybe a bug)

[dimyy]

Ver: 8.3.5 DB: MariaDB 10.6 (may be match work different in the mysql)

Problem: If full-text search is enabled in the linked entity, quick selection does not work

Roots of the problem: Full-text search in "Natural language mode" does not work by substring.

ORM must use the construction

select first_name, last_name, MATCH (last_name, first_name) AGAINST ('substr*' in boolean mode ) as m
from contact
order by m desc;​

against

select first_name, last_name, MATCH (last_name, first_name) AGAINST ('substr' in natural language mode ) as m
from contact
order by m desc;​

Test data:
first_name;last_name
"Contact","1"
"Contact","2"

MariaDB results:

AGAINST ('con' in natural language mode ) : 0
AGAINST ('con*' in natural language mode ): 0
AGAINST ('con' in boolean mode ): 0
AGAINST ('con*' in boolean mode ): 2

yuri ?

[yuri]

I'm very busy. can't participate in the forum any soon (for weeks).

Maybe this is related: https://forum.espocrm.com/forum/gene...-matches-8-3-0

[dimyy]

Unfortunately, no. I have analyzed this case up to the SQL queries. I will put the test on higher versions of mariadb - I will write