<!DOCTYPE html>
<html>
<head>
</head>
<body>
<dl style="line-height: 1.5; margin-left: 2em">
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
<dd style="margin-left: 8.5em">Kentaro Hayashi <hayas****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2019-07-31 18:14:51 +0900 (Wed, 31 Jul 2019)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f">f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">blog en: use appropriate word</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefb">en/_posts/2019-07-30-mroonga-9.05.md</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: en/_posts/2019-07-30-mroonga-9.05.md (+2 -2)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL28">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL31">31</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL32">32</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL35">35</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL67">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL70">70</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL71">71</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbL74">74</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR28">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR31">31</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR35">35</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR67">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR70">70</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR71">71</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/f943ebd2cc5b5dd9d86a0c11790eb76a9ef8139f#diff-4c8a998dd28afa8a18bf23e42013cefbR74">74</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -29,7 +29,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">Note that if you already created an unique index, you must recreate target table</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> In this release, added support for MySQL 5.6.45, 5.7.27 and 8.0.17.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> For MySQL 8.0, TIMESTAMP data type is supported.</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-MySQL 8.0 support is still in experimental stage, so if you found a bug or <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">d</span>ou<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">bt</span> behavior, please report to us!</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+MySQL 8.0 support is still in experimental stage, so if you found a bug or <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">suspici</span>ou<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">s</span> behavior, please report to us!</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Here is the documentation about "How to report a bug".</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -68,7 +68,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">MySQL [test]> INSERT INTO fts_targets (source_id, source_type_id) VALUES (10, 10</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ERROR 1062 (23000): Duplicate entry '10-100' for key 'source_id'</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-In above example, old index entry was not deleted correctly, therefore duplicated key error was occurred.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+In above example, <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">the </span>old index entry was not deleted correctly, therefore duplicated key error was occurred.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> In this case, you must recreate an target table because unique index may have garbage entries.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> We recommend to recreate an target table with dump and restore, or execute the following queries.</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>