Hi,
The problem is, that the index table engine is used, which does not support mid-word matches. Mid-word random matching triggers the non-indexed queries in MySQL as well as MariaDB (it’s a limitation of the database engines, not the plugin), thus the only way to make this work is to use the regular engine instead.