News

Release 8.06 - 2018-08-29

In this version, MySQL will be automatically restarted if you had already installed Mroonga and not installed Groonga 8.0.4 or later. Because Mroonga 8.06 requires Groonga 8.0.4 or later but it will not reloaded until MySQL is restarted.

Improvements

  • Updated required Groonga version to 8.0.4 or later.
  • Updated required groonga-normalizer-mysql version to 1.1.3 or later.
  • Supported utf8mb4_0900 family collation.
  • Supported tokenizer options.
  • Use the Groonga’s default logger.
  • [Windows] Updated bundled MariaDB to 10.3.9 from 10.1.33.
    • NOTICE: Before upgrading to MariaDB 10.3, you need to dump existing MariaDB 10.1 databases. Then restore it after upgrading.
  • [Debian GNU/Linux] Dropped Debian 8 (jessie) support.
  • [Ubuntu] Dropped Ubuntu 17.10 (Artful Aardvark) support.
  • [WIP] Working on supporting MySQL 8.
    • The storage mode is almost done (JSON type doesn’t work yet).
    • The wrapper mode is in progress.

Fixes

  • [storage] Fixed a bug that wrong result may be returned on multi range read. [GitHub#211][Reported by colt27]

Thanks

  • colt27

Release 8.03 - 2018-05-29

Improvements

  • [Docker] Added quick start guide link to Docker Hub.
  • [CentOS] Supported MariaDB 10.3.7.
  • [CentOS] Supported MariaDB 10.2.15 (backported to 8.02).
  • [CentOS] Supported MariaDB 10.1.33 (backported to 8.02).

Fixes

  • [Ubuntu] Fixed install failure on Ubntu 14.04 LTS (Trusty) (backported to 8.02). [GitHub#202,#205][Reported by Masato Hirai]

Thanks

  • Masato Hirai

Release 8.02 - 2018-04-29

Improvements

  • [Ubuntu] Supported Ubuntu 18.04 LTS (Bionic Beaver).
  • [Debian GNU/Linux] Supported i386 for Jessie.
  • Suppress meaningless “duplicated unique id” error log. [GitHub#197]
  • [developer][test] Supported –record option.
  • [CentOS] Use groonga-release-latest instead of groonga-release-X.X.X.
  • [Installation check] Added version check howto.
  • [CentOS][percona] Supported upgrading from “< 5.6.34” and “< 5.7.21”. [groonga-dev,04599][Reported by Takashi Kinoshita][Looked into by Satoshi Mitani]
  • [CentOS] Supported MySQL 5.6.40 and 5.7.22.
  • [CentOS] Supported Percona Server 5.7.21-21.

Fixes

  • Fixed a crash bug when some complex condition in ORDER BY such as ORDER BY 1 + 1, id, content.
  • Fixed a bug that MATCH AGAINST condition is ignored if SQL containing such as AND (x = 1 OR x = 2) when condition push down is enabled. [Gitter/ja:5ae014842b9dfdbc3ac7ce1f][Reported by colt27]
  • Fixed a memory leak for column caches.

Thanks

  • Takashi Kinoshita
  • Satoshi Mitani
  • colt27

Release 8.01 - 2018-03-29

In this version, MySQL will be automatically restarted if you had already installed Mroonga. This is because Mroonga requires newer version of Groonga (8.0.1) to fix bugs, but it will not reloaded until MySQL is restarted.

Improvements

  • [rpm][centos] Supported Percona Server 5.6.39. [Reported by @iiiiyyyy]
  • [rpm][centos] Supported Percona Server 5.7.21.
  • [rpm][centos] Supported MariaDB 10.2.13. [GitHub#198] [Reported by shota suzuki]
  • [rpm][centos] Supported MariaDB 10.2.14.

Fixes

  • Fixed a bug that wrong cache for other database is used. If you create multiple database and use mroonga_command() against one of them, wrong cache is returned unexpectedly. To fix this issue, Groonga 8.0.1 or later is required.
  • Fixed a bug that “NOT IN” query returns empty result. This bug occurs when “NOT IN” is used with multiple arguments such as “NOT IN (xxx, xxx)”
  • Fixed a bug that specified “NOT IN” can’t exclude correctly when condition push down is enabled.
  • Fixed a bug that “ORDER BY RAND()” query returns wrong result. This bug occurs when “ORDER BY RAND()” and “LIMIT” is specified at the same time.
  • Fixed a bug that “fast order limit” optimization is applied unexpectedly to “ORDER BY function()”.

Thanks

  • @iiiiyyyy
  • shota suzuki

Release 8.00 - 2018-02-09

This is a major version up! But It keeps backward compatibility. You can upgrade to 8.0.0 without rebuilding database.

Improvements

  • When create hash index, used tiny hash for reducing used resource.
  • [percona57] Added gap lock detection support. [GitHub#188][Reported by Iwo]

Thanks

  • Iwo

Release 7.11 - 2018-01-29

Improvements

  • [test] Added a test case for sub query and order limit optimization. [GitHub#184] [Reported by Kazuki Hamasaki]
  • [rpm][centos] Supported MariaDB 10.3.
  • [deb][ubuntu] Supported MariaDB 10.1 for Ubuntu 17.10 (Artful Aadvark)

Fixes

  • [Mroonga_n_pooling_contexts] Fixed a bug that value is reset unexpectedly by FLUSH STATUS.
  • [maradb10.3] Fixed a build error which is caused by renamed constant variable (HA_MUST_USE_TABLE_CONDITION_PUSHDOWN is renamed to HA_CAN_TABLE_CONDITION_PUSHDOWN).
  • [macOS] Removed obsolete install guide and updated link to latest documentation [Reported by Ryuji AMANO]
  • [rpm][centos] Supported MariaDB 10.2.12. [GitHub#186] [Reported by Shota Suzuki]
  • [rpm][centos] Supported Percona Server 5.7.20-19.
  • [Ubuntu] Dropped Ubuntu 17.04 (Zesty Zapus) support. It has reached EOL at Jan 13, 2018.

Thanks

  • Kazuki Hamasaki
  • Ryuji AMANO
  • Shota Suzuki

Release 7.10 - 2017-12-29

Improvements

  • Updated required Groonga version to 7.1.0. You need to restart MySQL after you upgrade to Mroonga 7.10.
  • [mariadb10.3] Supported MariaDB 10.3.
  • [rpm][centos] Supported MariaDB 10.2.11.
  • [rpm][centos] Supported MariaDB 10.1.30.
  • [rpm][centos] Supported Percona Server 5.7.20.
  • [rpm][centos] Supported Percona Server 5.6.38.
  • [Optimizations] Enable count_skip optimization for multi-column index.
  • Supported condition push down and added related new variables.
    • [Mroonga_condition_push_down] Added Mroonga_condition_push_down.
    • [mroonga_condition_push_down_type] Added mroonga_condition_push_down_type. The default value is ONE_FULL_TEXT_SEARCH. It means that condition push down is enabled only when WHERE clause has one MATCH AGAINST condition. If the value ALL is set, condition push down is always used (ALL is experimental for now. We are glad if you use it and tell us if it got faster or not).
  • Supported column cache when to get fixed size column value to improve performance.
  • Renamed a function last_insert_grn_id to mroonga_last_insert_grn_id to add missing mroonga_ prefix. last_insert_grn_id is deprecated. [GitHub#177] [Reported by Ian Gilfillan]
  • [Mroonga_n_pooling_contexts] Added a new status variable to show the number of pooling contexts for mroonga_command().
  • [ FLUSH TABLES ] Added clearing pooling contexts for mroonga_command() support.

Thanks

  • Ian Gilfillan

Release 7.09 - 2017-11-29

Improvements

  • [rpm][centos] Supported MariaDB 10.2.10.
  • [rpm][centos] Supported MariaDB 10.1.29.
  • Fixed not to require sed to run tests. [Patch by Sergei Golubchik]
  • [cmake] Changed to skip Mroonga related configurations on without Mroonga build. [Patch by Vladislav Vaintroub]

Thanks

  • Sergei Golubchik
  • Vladislav Vaintroub

Release 7.08 - 2017-10-29

Improvements

  • Supported table level flags option. You can specify TABLE_HASH_KEY, TABLE_PAT_KEY, TABLE_DAT_KEY, and KEY_LARGE table options. [groonga-dev, 04494] [Reported by Masanori Miyashita]
  • [rpm][centos] Supported MySQL 5.6.38-2 and 5.7.20-1.
  • [Ubuntu] Supported Ubuntu 17.10 (Artful Aardvark).

Thanks

  • Masanori Miyashita

Release 7.07 - 2017-10-12

Improvements

  • [mroonga_query_expand] Added mroonga_query_expand UDF. If you prepare synonyms table in advance, you can get expanded synonym in your query by mroonga_query_expanded. Note that Groonga 7.0.6 or later version is required to use this function.
  • [rpm][centos] Supported Percona Server 5.7.19-17.1. [Reported by tigersun2000]
  • [rpm][centos] Supported MariaDB 5.5.56-2. [Reported by akiko_pusu]
  • [rpm][centos] Supported MariaDB 10.1/10.2 provided by MariaDB.

Fixes

  • Fixed a bug that wrong database may be used on “DROP DATABASE”. This bug may cause a crash because internal “mroonga_operations” table is removed unexpectedly. It may happen when the following two conditions are true:

    1. There are multiple databases that uses Mroonga.
    2. “DROP DATABASE” against no longer Mroonga tables exist.

    As unexpected result, “DROP DATABASE x” may remove “mroonga_operations” table on existing “y” database.

  • Fix a crash bug after CHECK TABLE is used. [GitHub#167] [Reported by GMO Media, Inc.]

  • [deb][mariadb10] Added missing dependency to lsb-release package for preinst and postrm maintainer script. [GitHub#169] [Patch by Tatsuki Sugiura]

Thanks

  • @tigersun2000
  • @akiko_pusu
  • GMO Media, Inc.
  • Tatsuki Sugiura

Release 7.06 - 2017-08-29

Improvements

  • [mroonga_highlight_html()] Added usage about mroonga_highlight_html.
  • Supported generated column. It is useful to full-text search for partially extracted content from JSON column. [GitHub#159,#160,#163] [Patch by Naoya Murakami]
  • Added mroonga_enable_operations_recording. variable. [GitHub#158] [Patch by Naoya Murakami]
  • Supported virtual column for MariaDB 10.2 and MySQL 5.7. It supports VIRTUAL type. [GitHub#161,#162] [Patch by Naoya Murakami]
  • Supported MariaDB 10.1.26.
  • [rpm][centos] Supported Percona Server 5.6.36 rel82.1 and 5.7.18-16. [Gitter/ja:59894500bc46472974622cbd] [Reported by @tigersun2000_twitter]
  • [rpm][centos] Supported MySQL 5.6.37 and 5.7.19 on CentOS 7. [groonga-dev,04441] [Reported by Kagami Hiroshi]

Thanks

  • Naoya Murakami
  • @tigersun2000_twitter
  • Kagami Hiroshi

Release 7.05 - 2017-07-29

Improvements

  • Supported Groonga query log. Use mroonga_query_log_file variable to use this feature. [GitHub#148]
  • Supported MariaDB 10.2.7. [groonga-dev,04397] [Reported by Tomohiro ‘Tomo-p’ KATO]
  • [mroonga_command()] Supported database name that has special name such as db-1 for example. It contains special character -.
  • [mroonga_command()] Supported auto command syntax escape feature. It makes easy to use Groonga functionality from Mroonga.
  • Supported MariaDB 5.5.57.
  • [rpm][centos] Supported MySQL 5.6.37-2 and MySQL 5.7.19-1 on CentOS 6. [groonga-dev,04403] [Reported by Kagami Hiroshi]
  • [Ubuntu] Dropped Ubuntu 16.10 (Yekkety Yak) support. It has reached EOL at July 20, 2017.
  • [mroonga_highlight_html()] Supported a function to highlight target column or text.

Fixes

  • Fixed a crash bug when there is no active index internally. [Gitter:groonga/ja:596714a5c101bc4e3a7db4e5] [Reported by K Torimoto]

Thanks

  • K Torimoto
  • Tomohiro ‘Tomo-p’ KATO
  • Kagami Hiroshi

Release 7.04 - 2017-06-29

Improvements

  • Supported to show error message when failed to create a table for matched records. This kind of error occurs when indexes are broken. This error message helps to identify problem.
  • [Debian GNU/Linux] Supported Debian 9 (stretch).

Fixes

  • Fixed a crash bug that missing NULL check before calling grn_table_setoperation causes. Such a crash bug occurs when indexes are broken.

Release 7.03 - 2017-05-29

Improvements

  • [Limitations] Updated limitations about NULL in column. [Gitter/ja] [Reported by @bignum_twitter]
  • Supported INDEX_MEDIUM and INDEX_SMALL flags. [GitHub#141] [Patch by Naoya Murakami]
  • [CentOS] Supported recent Percona Server 5.6.36 and 5.7.18. [Reported by @pinpikokun]

Thanks

  • @bignum_twitter
  • @pinpikokun
  • Naoya Murakami

Release 7.02 - 2017-04-29

Improvements

  • [CentOS] Dropped Ubuntu 12.04 (Precise Pangolin) support because of EOL.
  • [Ubuntu] Added Zesty Zapus (Ubuntu 17.04) support.

Fixes

  • [CentOS] Fixed build error with MySQL 5.6.36 and MySQL 5.7.18.
  • [cmake] Fixed missing link to libgroonga when mroonga is bundled and libgroonga isn’t bundled. [GitHub#137] [Patch by Naoya Murakami]

Thanks

  • Naoya Murakami

Release 7.01 - 2017-03-29

Improvements

  • [CentOS] Dropped CentOS 5 support because of EOL.
  • [Storage mode] Supported ALTER TABLE ADD/DROP FOREIGN KEY.
  • [Storage mode] Supported fast ORDER LIMIT with ENUM. [groonga-dev,04277] [Reported by murata satoshi]
  • Supported COMPRESS_ZSTD column compression flag. [GitHub#133] [Patch by Naoya Murakami]
  • [Server variables] Added documentation about mroonga_libgroonga_support_zstd variable. [GitHub#133] [Patch by Naoya Murakaimi]
  • [Install] Changed to recommend https://packages.groonga.org for downloading resources.

Fixes

  • [Storage mode] Fixed update error for log-bin and UPDATE with collated PRIMARY KEY. [GitHub#132] [Reported by kitora]
  • Fixed a bug that FOREIGN KEY is dumped unexpectedly even though you didn’t set it. [groonga-dev,04276] [Reported by murata satoshi]

Thanks

  • kitora
  • murata satoshi
  • Naoya Murakami

Release 7.00 - 2017-02-09

Improvements

  • [CentOS] Changed to ensure enabling EPEL to install package.
  • Supported FOREIGN KEY constrain on UPDATE and DELETE parent row. In the previous versions, only FOREIGN KEY constrain on INSERT is supported.
  • [Storage mode] Supported updating row even though its table has primary key with ROW binlog format. In the previous version, it causes update statement error. [GitHub#130] [Reported by kitora]

Thanks

  • kitora

Past releases