[Maria-discuss] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
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-... 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-...
participants (1)
-
AskMonty KB