Kentaro Hayashi 2019-03-28 17:10:45 +0900 (Thu, 28 Mar 2019) Revision: 6ba8e17774ba378042978b2f1aa460f27312af48 https://github.com/mroonga/mroonga.github.com/commit/6ba8e17774ba378042978b2f1aa460f27312af48 Message: blog en: add one more entry Modified files: en/_posts/2019-03-29-mroonga-9.01.md Modified: en/_posts/2019-03-29-mroonga-9.01.md (+34 -0) =================================================================== --- en/_posts/2019-03-29-mroonga-9.01.md 2019-03-28 16:34:54 +0900 (dc4ac58) +++ en/_posts/2019-03-29-mroonga-9.01.md 2019-03-28 17:10:45 +0900 (6281d35) @@ -20,9 +20,43 @@ and fulltext search engine. The main changes are as follows. + * Improved support for more table and comment parameter about tokenizer/nomalizer/indexes. * Added support for latest MariaDB/Percona Server. * Added support for building bundled MariaDB package on AppVeyor. +### Improved support for table and comment parameter about tokenizer/nomalizer/indexes + +In this release, tokenizer/nomalizer/indexes support is improved. + +In storage mode, you can specify tokenizer options in `COMMENT` section. + +```sql +CREATE TABLE foo (...) COMMENT='tokenizer "TokenNgram('n', 4)"' +``` + +Note that `default_tokenizer` is deprecated. use `tokenizer` instead. + +You can also specify `LEXICON` index parameter. + +```sql +FULLTEXT INDEX foo (bar) LEXICON='terms' +``` + +or + +``` +FULLTEXT INDEX foo (bar) COMMENT 'lexicon "terms"' +``` + +for MariaDB, `TOKENIZER`, `NORMALIER` and `TOKEN_FILTERS` table parameter has been supported. + +```sql +CREATE TABLE foo (...) TOKENIZER='TokenNgram("n", 4)' +CREATE TABLE foo (...) NORMALIZER='NormalizerNFKC100("unify_kana", true)' +CREATE TABLE foo (...) TOKEN_FILTERS='TokenFilterNFKC100("unify_katakana_v_sounds", true)' +``` + + ### Added support for latest MariaDB/Percona Server In this release, the following latest MariaDB/Percona Server has been supported. -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20190328/5b675a30/attachment-0001.html>
