<commit_before>:orphan:

.. highlightlang:: none

News
====

.. _release-5-09:

Release 5.09 - 2015-10-29
-------------------------

Improvements
^^^^^^^^^^^^

* [rpm][mysql56-community-mroonga] Updated target MySQL to 5.6.27.
  [Reported by @star_orihime]

* [UDF][``mroonga_snippet_html``] Added a new UDF that returns snippet
  for HTML output.

* [Windows] Bundled MeCab.

* [Windows] Updated base MariaDB to 10.1.8.

* [MariaDB 10.1] Supported MariaDB 10.1.8.

* Supported auto repair on crash.
  [groonga-dev,03515][Suggested by Hiroshi Kagami]

* [MySQL 5.7] Supported MySQL 5.7.9.

* [MySQL 5.7] Supported JSON type.

* [:doc:`/install/ubuntu`] Added Ubuntu 15.10 Wily Werewolf support.

* [:doc:`/install/centos`] Added MySQL 5.7 package provided by Oracle support on CentOS 6.

Fixes
^^^^^

* Fixed a bug that ``MRBContains()`` doesn't use index.
  [GitHub#73] [Reported by <NAME>]

Thanks
^^^^^^

* @star_orihime

* <NAME>

* <NAME>

.. _release-5-08:

Release 5.08 - 2015-09-29
-------------------------

Improvements
^^^^^^^^^^^^

* [CMake][MariaDB 10.1] Supported ``PLUGIN_MROONGA=NO``.
* [UDF] Supported ``grn_ctx`` pool. It improves performance for
  calling UDF because Mroonga can reduce ``grn_ctx`` initialize cost.

Fixes
^^^^^

* Fixed a memory leak when ``ORDER BY LIMIT`` is used with multiple
  ``MATCH AGAINST``.
  [groonga-dev,03496] [Reported by Gosuke Yasufuku]
* Fixed a bug that ``ORDER BY LIMIT`` and multiple ``MATCH AGAINST``
  returns wrong result.
  [groonga-dev,03496] [Reported by Gosuke Yasufuku]

Thanks
^^^^^^

* <NAME>

.. _release-5-06:

Release 5.06 - 2015-08-31
-------------------------

Improvements
^^^^^^^^^^^^

* Supported MariaDB 10.1 that is built as embedded server.
  [MDEV-8508][GitHub#66] [Reported by <NAME>ik]
* [rpm][mysql55-mroonga] Updated build target MySQL version.
  [groonga-dev,03421] [Reported by Hiroshi Kagami]

Fixes
^^^^^

* [rpm][percona-server-56-mroonga] Fixed a crash bug.
  [GitHub#70] [Patch by GMO Media, Inc.]
* Fixed a crash bug when any opening table exists on shutdown.
  [GitHub#71] [Reported by GMO Media, Inc.]

Thanks
^^^^^^

* GMO Media, Inc.
* <NAME>
* <NAME>

.. _release-5-05:

Release 5.05 - 2015/07/29
-------------------------

Improvements
^^^^^^^^^^^^

* [:doc:`/install/ubuntu`] Dropped Ubuntu 14.10 (Utopic Unicorn) support. It had been
  End of Life on July 23, 2015.
* [rpm][:doc:`/install/centos`] Updated to the latest MySQL 5.6 (5.6.26-2) on CentOS 6/7.
* [rpm][:doc:`/install/centos`] Updated to the latest Percona Server 5.6 (5.6.25-rel73.1)
  on CentOS 6.

Fixes
^^^^^

* Fixed a bug that search results are reduced for multiple column index with range
  condition (e.g. ``<`` in ``WHERE date < '2015-07-01'``).
  [`groonga-dev,03332 <http://osdn.jp/projects/groonga/lists/archive/dev/2015-July/003334.html>`_]
  [GitHub#65] [Reported by foamcentime]
* [storage] Fixed memory leaks.
  [`MDEV-8520 <https://mariadb.atlassian.net/browse/MDEV-8520>`_]
  [Report by Elena Stepanova]

Thanks
^^^^^^

* foamcentime
* <NAME>
* <NAME>

.. _release-5-04:

Release 5.04 - 2015/06/29
-------------------------

Improvements
^^^^^^^^^^^^

* [rpm][mysql56-community-mroonga][percona-server-56-mroonga]
  Start mysqld when mysqld is not running within rpm-installation.
  (This topic is at 5.03-2) [GitHub#58] [Patch by GMO Media, Inc.]
* [mariadb10.1] Followed recent API changes.
* [mariadb] Supported custom parameters in DDL.
  This feature can be used only with MariaDB.

  * Supported ``TOKENIZER`` parameter for ``FULLTEXT IDNEX`` ::

      CREATE TABLE diaries (
        id int PRIMARY KEY AUTO_INCREMENT,
        body text,
        FULLTEXT INDEX body_index (body) TOKENIZER='TokenBigramSplitSymbolAlphaDigit'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;

  * Supported ``NORMALIZER`` parameter for ``FULLTEXT IDNEX`` and normal ``INDEX`` ::

      CREATE TABLE memos (
        id INT NOT NULL PRIMARY KEY,
        content TEXT NOT NULL,
        FULLTEXT INDEX (content) NORMALIZER='NormalizerAuto'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;

  * Supported ``TOKEN_FILTERS`` parameter for ``FULLTEXT IDNEX`` ::

      CREATE TABLE memos (
        content VARCHAR(64) NOT NULL,
        FULLTEXT INDEX (content) TOKEN_FILTERS='TokenFilterStopWord,TokenFilterStopWord'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;

  * Supported ``FLAGS`` parameter for ``FULLTEXT INDEX`` and normal ``INDEX`` ::

      CREATE TABLE memos (
        content VARCHAR(64) NOT NULL,
        FULLTEXT INDEX (content) FLAGS='WITH_POSITION|WITH_WEIGHT'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;


  * Supported ``GROONGA_TYPE`` parameter for field ::

      CREATE TABLE tags (
        name VARCHAR(64) PRIMARY KEY
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

      CREATE TABLE bugs (
        id INT UNSIGNED PRIMARY KEY,
        tag VARCHAR(64) GROONGA_TYPE='tags'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;

* [storage] Report error for invalid datetime related value on ``STRICT_TRANS_TABLES``.
  [groonga-dev,03299] [Suggested by GMO Media, Inc.]

  * It's backward incompatible change. For example:

    * Prepare (common) ::

        mysql> CREATE TABLE timestamps (
            ->   id INT PRIMARY KEY AUTO_INCREMENT,
            ->   create_dt DATETIME
            -> ) ENGINE = Mroonga DEFAULT CHARSET = utf8;
        Query OK, 0 rows affected (0.09 sec)

        mysql> SET sql_mode='';
        Query OK, 0 rows affected (0.01 sec)

        mysql> INSERT INTO timestamps (create_dt) VALUES ("2001-00-00 00:00:00");
        Query OK, 1 row affected, 1 warning (0.00 sec)<commit_msg>doc: remove wrong COMMENT<commit_after>:orphan:

.. highlightlang:: none

News
====

.. _release-5-09:

Release 5.09 - 2015-10-29
-------------------------

Improvements
^^^^^^^^^^^^

* [rpm][mysql56-community-mroonga] Updated target MySQL to 5.6.27.
  [Reported by @star_orihime]

* [UDF][``mroonga_snippet_html``] Added a new UDF that returns snippet
  for HTML output.

* [Windows] Bundled MeCab.

* [Windows] Updated base MariaDB to 10.1.8.

* [MariaDB 10.1] Supported MariaDB 10.1.8.

* Supported auto repair on crash.
  [groonga-dev,03515][Suggested by Hiroshi Kagami]

* [MySQL 5.7] Supported MySQL 5.7.9.

* [MySQL 5.7] Supported JSON type.

* [:doc:`/install/ubuntu`] Added Ubuntu 15.10 Wily Werewolf support.

* [:doc:`/install/centos`] Added MySQL 5.7 package provided by Oracle support on CentOS 6.

Fixes
^^^^^

* Fixed a bug that ``MRBContains()`` doesn't use index.
  [GitHub#73] [Reported by Petri Rautiainen]

Thanks
^^^^^^

* @star_orihime

* <NAME>

* <NAME>

.. _release-5-08:

Release 5.08 - 2015-09-29
-------------------------

Improvements
^^^^^^^^^^^^

* [CMake][MariaDB 10.1] Supported ``PLUGIN_MROONGA=NO``.
* [UDF] Supported ``grn_ctx`` pool. It improves performance for
  calling UDF because Mroonga can reduce ``grn_ctx`` initialize cost.

Fixes
^^^^^

* Fixed a memory leak when ``ORDER BY LIMIT`` is used with multiple
  ``MATCH AGAINST``.
  [groonga-dev,03496] [Reported by Gosuke Yasufuku]
* Fixed a bug that ``ORDER BY LIMIT`` and multiple ``MATCH AGAINST``
  returns wrong result.
  [groonga-dev,03496] [Reported by Gosuke Yasufuku]

Thanks
^^^^^^

* <NAME>

.. _release-5-06:

Release 5.06 - 2015-08-31
-------------------------

Improvements
^^^^^^^^^^^^

* Supported MariaDB 10.1 that is built as embedded server.
  [MDEV-8508][GitHub#66] [Reported by Sergei Golubchik]
* [rpm][mysql55-mroonga] Updated build target MySQL version.
  [groonga-dev,03421] [Reported by Hiroshi Kagami]

Fixes
^^^^^

* [rpm][percona-server-56-mroonga] Fixed a crash bug.
  [GitHub#70] [Patch by GMO Media, Inc.]
* Fixed a crash bug when any opening table exists on shutdown.
  [GitHub#71] [Reported by GMO Media, Inc.]

Thanks
^^^^^^

* GMO Media, Inc.
* <NAME>
* <NAME>

.. _release-5-05:

Release 5.05 - 2015/07/29
-------------------------

Improvements
^^^^^^^^^^^^

* [:doc:`/install/ubuntu`] Dropped Ubuntu 14.10 (Utopic Unicorn) support. It had been
  End of Life on July 23, 2015.
* [rpm][:doc:`/install/centos`] Updated to the latest MySQL 5.6 (5.6.26-2) on CentOS 6/7.
* [rpm][:doc:`/install/centos`] Updated to the latest Percona Server 5.6 (5.6.25-rel73.1)
  on CentOS 6.

Fixes
^^^^^

* Fixed a bug that search results are reduced for multiple column index with range
  condition (e.g. ``<`` in ``WHERE date < '2015-07-01'``).
  [`groonga-dev,03332 <http://osdn.jp/projects/groonga/lists/archive/dev/2015-July/003334.html>`_]
  [GitHub#65] [Reported by foamcentime]
* [storage] Fixed memory leaks.
  [`MDEV-8520 <https://mariadb.atlassian.net/browse/MDEV-8520>`_]
  [Report by <NAME>ova]

Thanks
^^^^^^

* foamcentime
* <NAME>
* <NAME>

.. _release-5-04:

Release 5.04 - 2015/06/29
-------------------------

Improvements
^^^^^^^^^^^^

* [rpm][mysql56-community-mroonga][percona-server-56-mroonga]
  Start mysqld when mysqld is not running within rpm-installation.
  (This topic is at 5.03-2) [GitHub#58] [Patch by GMO Media, Inc.]
* [mariadb10.1] Followed recent API changes.
* [mariadb] Supported custom parameters in DDL.
  This feature can be used only with MariaDB.

  * Supported ``TOKENIZER`` parameter for ``FULLTEXT IDNEX`` ::

      CREATE TABLE diaries (
        id int PRIMARY KEY AUTO_INCREMENT,
        body text,
        FULLTEXT INDEX body_index (body) TOKENIZER='TokenBigramSplitSymbolAlphaDigit'
      ) ENGINE = Mroonga DEFAULT CHARSET = utf8;

  * Supported ``NORMALIZER`` parameter for ``FULLTEXT IDNEX`` and normal ``INDEX`` ::

      CREATE TABLE memos (
        id INT NOT NULL PRIMARY KEY,
        content TEXT NOT NULL,
        FULLTEXT INDEX (content) NORMALIZER='NormalizerAuto'
      ) ENGINE = Mroonga DEFAULT CHARSET = utf8;

  * Supported ``TOKEN_FILTERS`` parameter for ``FULLTEXT IDNEX`` ::

      CREATE TABLE memos (
        content VARCHAR(64) NOT NULL,
        FULLTEXT INDEX (content) TOKEN_FILTERS='TokenFilterStopWord,TokenFilterStopWord'
      ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET = utf8;

  * Supported ``FLAGS`` parameter for ``FULLTEXT INDEX`` and normal ``INDEX`` ::

      CREATE TABLE memos (
        content VARCHAR(64) NOT NULL,
        FULLTEXT INDEX (content) FLAGS='WITH_POSITION|WITH_WEIGHT'
      ) ENGINE = Mroonga DEFAULT CHARSET = utf8;


  * Supported ``GROONGA_TYPE`` parameter for field ::

      CREATE TABLE tags (
        name VARCHAR(64) PRIMARY KEY
      ) ENGINE = Mroonga DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

      CREATE TABLE bugs (
        id INT UNSIGNED PRIMARY KEY,
        tag VARCHAR(64) GROONGA_TYPE='tags'
      ) ENGINE = Mroonga DEFAULT CHARSET = utf8;

* [storage] Report error for invalid datetime related value on ``STRICT_TRANS_TABLES``.
  [groonga-dev,03299] [Suggested by GMO Media, Inc.]

  * It's backward incompatible change. For example:

    * Prepare (common) ::

        mysql> CREATE TABLE timestamps (
            ->   id INT PRIMARY KEY AUTO_INCREMENT,
            ->   create_dt DATETIME
            -> ) ENGINE = Mroonga DEFAULT CHARSET = utf8;
        Query OK, 0 rows affected (0.09 sec)

        mysql> SET sql_mode='';
        Query OK, 0 rows affected (0.01 sec)

        mysql> INSERT INTO timestamps (create_dt) VALUES ("2001-00-00 00:00:00");
        Query OK, 1 row affected, 1 warning (0.00 sec)
{'fraction_non_alphanumeric': 0.1554585152838428, 'fraction_numerical': 0.04646288209606987, 'mean_word_length': 3.111669658886894, 'pattern_counts': {'":': 0, '<': 28, '<?xml version=': 0, '>': 36, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7277223', 'n_tokens_mistral': 4548, 'n_tokens_neox': 3960, 'n_words': 1170}