<!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-04-17 14:11:39 +0900 (Tue, 17 Apr 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/7de773dbd416be6229f3649968aa70a8fe0ed47a">7de773dbd416be6229f3649968aa70a8fe0ed47a</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">storage test: remove primary key truncated warnings on REPLACE</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#diff-0">test/sql/suite/mroonga_storage/r/replace_select_varchar.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#diff-1">test/sql/suite/mroonga_storage/r/replace_text.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#diff-2">test/sql/suite/mroonga_storage/r/replace_varchar.result</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_storage/r/replace_select_varchar.result (+0 -3)</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L33">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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L34">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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L37">37</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0L38">38</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0R29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0R32">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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L0R35">35</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,9 +30,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">REPLACE INTO videos_groonga</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT v.id, v.video_id, v.description, NULL</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM videos_master AS v</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> WHERE v.video_id = (video_id);</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warnings:</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warning 1265 data truncated for primary key column: <video_id></span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warning 1265 data truncated for primary key column: <video_id></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT *, MATCH(description) AGAINST("my") FROM videos_groonga</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> WHERE MATCH(description) AGAINST("my");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id video_id description tags_unpack MATCH(description) AGAINST("my")</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_storage/r/replace_text.result (+0 -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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L28">28</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L29">29</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1L33">33</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R28">28</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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L1R31">31</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">@@ -26,8 +26,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">id 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"> replace into diaries values(2, "明日の天気は雨みたい。");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warnings:</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warning 1265 data truncated for primary key column: <id></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from diaries where match(content) against("天気");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 明日の天気は雨みたい。</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_storage/r/replace_varchar.result (+0 -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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L28">28</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L29">29</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2L33">33</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/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R28">28</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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/7de773dbd416be6229f3649968aa70a8fe0ed47a#L2R31">31</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">@@ -26,8 +26,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">id 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"> replace into diaries values(2, "明日の天気は雨みたい。");</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warnings:</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-Warning 1265 data truncated for primary key column: <id></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from diaries where match(content) against("天気");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 明日の天気は雨みたい。</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>