Hi, Mroonga 7.07 has been released!
Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org/docs/install.html How to upgrade: Upgrade Guide http://mroonga.org/docs/upgrade.html Blog: http://mroonga.org/en/blog/2017/10/12/mroonga-7.07.html Changes: http://mroonga.org/docs/news.html#release-7.07 Here is the topic in this release. * MariaDB 10.1/10.2 package has been supported on CentOS 6/7 * mroonga_query_expand UDF has been supported ### MariaDB 10.1/10.2 package has been supported on CentOS 6/7 In this release, official MariaDB 10.1/10.2 packages has been supported on CentOS 6/7. To install on each supported environment, see install documents. * MariaDB 10.1 on CentOS 6 http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-1-package * MariaDB 10.2 on CentOS 6 http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-2-package * MariaDB 10.1 on CentOS 7 http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-1-package * MariaDB 10.2 on CentOS 7 http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-2-package ### mroonga_query_expand UDF has been supported In this release, mroonga_query_expand UDF has been supported. Here is the sample schema to use this UDF. CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, content VARCHAR(255), FULLTEXT INDEX (content) ) ENGINE = Mroonga DEFAULT CHARSET utf8; CREATE TABLE synonyms ( term varchar(255), synonym varchar(255), INDEX (term) ) ENGINE= Mroonga DEFAULT CHARSET utf8; diaries is table for full text search. synonym table is used to define synonyms. Then insert sample data: INSERT INTO synonyms VALUES ('Groonga', 'Groonga Mroonga Rroonga'); INSERT INTO diaries (content) VALUES ("Groonga is fast."); INSERT INTO diaries (content) VALUES ("Mroonga is fast."); INSERT INTO diaries (content) VALUES ("PGroonga is fast."); Let's use mroonga_query_expand UDF. If you want to search with synonym term, just use mroonga_query_expand("synonyms", "term", "synonym", "Groonga"). This enable you to do full text search by 'Groonga', 'Mroonga', 'Roonga' at once even though specified term is only 'Groonga'. mysql> SELECT * FROM diaries WHERE MATCH(content) AGAINST(mroonga_query_expand("synonyms", "term", "synonym", "Groonga") IN BOOLEAN MODE); +----+------------------+ | id | content | +----+------------------+ | 1 | Groonga is fast. | | 2 | Mroonga is fast. | +----+------------------+ 2 rows in set (0.01 sec) Regards, -- Kentaro Hayashi <haya...@clear-code.com>
pgpwGRghM20cV.pgp
Description: PGP signature
