maria-discuss team mailing list archive

Thread
Date

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

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Tue, 18 Aug 2015 13:30:03 -0000

Hello,

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.

Thanks.

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/