The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Mariadb match against a view (fulltext search) fails; succeeds in MySql

The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin).

If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views.

Is there a solution to this? It's messing up my migration. Using 10.0.21.

Thanks.

SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something'))

Answer

Please report bugs on http://mariadb.org/jira

and provide more information — storage engine, mysql version. ideally — a complete repeatable test case.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.