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/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
