← Back to team overview

maria-discuss team mailing list archive

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



A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails-succeeds-in-mysql/ as the person asking the question may not be subscribed to the mailing list.

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.


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


To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails-succeeds-in-mysql/