Kentaro Hayashi
null+****@clear*****
Tue Aug 29 17:07:01 JST 2017
Kentaro Hayashi 2017-08-29 17:07:01 +0900 (Tue, 29 Aug 2017) New Revision: cdb76327125a9d375e0b5b1f4a3bf3e2e7c5f845 https://github.com/mroonga/mroonga.github.com/commit/cdb76327125a9d375e0b5b1f4a3bf3e2e7c5f845 Message: blog en: add 7.06 entry Added files: en/_posts/2017-08-29-mroonga-7.06.md Added: en/_posts/2017-08-29-mroonga-7.06.md (+64 -0) 100644 =================================================================== --- /dev/null +++ en/_posts/2017-08-29-mroonga-7.06.md 2017-08-29 17:07:01 +0900 (b4e2df7) @@ -0,0 +1,64 @@ +--- +layout: post.en +title: Mroonga 7.06 has been released! +description: Mroonga 7.06 has been released! +--- + +## Mroonga 7.06 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. + +[Mroonga 7.06](/docs/news.html#release-7-06) has been released! + + * How to install: [Install](/docs/install.html) + * How to upgrade: [Upgrade guide](/docs/upgrade.html) + +### Changes + +Here are changes in this release. + + * Generated Column has been supported + +### Generated Column has been supported + +In this release, Generated Column has been supported! + +Here is the sample schema to use generated column. + + CREATE TABLE logs ( + id INT, + record JSON, + message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`, '$.message')) STORED, + FULLTEXT INDEX(message) comment 'tokenizer "TokenBigramSplitSymbolAlphaDigit"' + ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4; + +As you can see, the partial value of `record` column is used as `message` column. + +Then, you can do full text search against `message` column by the following query. + + > SELECT * FROM logs WHERE MATCH(message) AGAINST("ar" IN BOOLEAN MODE); + +------+-----------------------------------------+-----------+ + | id | record | message | + +------+-----------------------------------------+-----------+ + | 1 | {"level": "info", "message": "start"} | "start" | + | 2 | {"level": "info", "message": "restart"} | "restart" | + +------+-----------------------------------------+-----------+ + 2 rows in set (0.02 sec) + +You can also define `VIRTUAL` without actual data column. + + CREATE TABLE logs ( + id INT, + record JSON, + message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`, '$.message')) VIRTUAL + ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4; + +But note that `FULLTEXT INDEX(message)` is not supported yet. + +### Conclusion + +See [Release 7.06 - 2017-08-29](/docs/news.html#release-7-06) about detailed changes since 7.05. + +Let's search by Mroonga! -------------- next part -------------- HTML����������������������������...下载
