<!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">Kouhei Sutou <kou****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2012-11-20 17:03:28 +0900 (Tue, 20 Nov 2012)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5">87ed9896cf80fdd1840f410a0e2b00479e1d10e5</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Log</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">test: add a space before "("</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#diff-0">test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#diff-1">test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result (+6 -6)</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L14">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L15">15</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L17">17</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L18">18</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L19">19</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L20">20</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L21">21</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L22">22</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L24">24</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L25">25</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L28">28</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L32">32</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L33">33</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0L36">36</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R14">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R15">15</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R17">17</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R18">18</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R19">19</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R20">20</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R21">21</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R22">22</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R24">24</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R28">28</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R32">32</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L0R36">36</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -15,14 +15,14 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">diaries CREATE TABLE `diaries` (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> PRIMARY KEY (`id`),</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FULLTEXT KEY `title` (`title`)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"'</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(1, "Hello", "はじめました。");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(3, "富士山", "今日もきれい。");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (1, "Hello", "はじめました。");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (2, "天気", "明日の富士山の天気について");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (3, "富士山", "今日もきれい。");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id title content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 富士山 今日もきれい。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> DROP INDEX title ON diaries;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ERROR HY000: Can't find FULLTEXT index matching the column list</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT * FROM diaries;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id title content</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -30,7 +30,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">id title content</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 天気 明日の富士山の天気について</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 富士山 今日もきれい。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE FULLTEXT INDEX new_title_index ON diaries (title);</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id title content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 富士山 今日もきれい。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT * FROM diaries;</span>
</pre>
</td>
</tr>
</tbody>
</table>
<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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test (+6 -6)</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L32">32</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L33">33</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L34">34</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L35">35</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L36">36</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L37">37</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L41">41</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L42">42</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L45">45</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L46">46</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/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L47">47</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1L49">49</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R32">32</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R33">33</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R34">34</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R36">36</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R37">37</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R41">41</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R45">45</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R46">46</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R47">47</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5#L1R49">49</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -30,20 +30,20 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE diaries (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ) DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"';</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHOW CREATE TABLE diaries;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(1, "Hello", "はじめました。");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-INSERT INTO diaries VALUES(3, "富士山", "今日もきれい。");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (1, "Hello", "はじめました。");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (2, "天気", "明日の富士山の天気について");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+INSERT INTO diaries VALUES (3, "富士山", "今日もきれい。");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> DROP INDEX title ON diaries;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --error ER_FT_MATCHING_KEY_NOT_FOUND</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT * FROM diaries;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE FULLTEXT INDEX new_title_index ON diaries (title);</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT * FROM diaries;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> DROP TABLE diaries;</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>