<!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-01-06 15:59:50 +0900 (Fri, 06 Jan 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/4827b03b883086f99e5d3d66b21b8736c899c0e9">4827b03b883086f99e5d3d66b21b8736c899c0e9</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] follow test changes.</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#diff-0">test/sql/suite/mroonga_storage/r/fulltext_order_limit.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#diff-1">test/sql/suite/mroonga_storage/r/order_limit_performance.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/fulltext_order_limit.result (+4 -4)</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L8">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L11">11</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L12">12</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L15">15</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L16">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0L28">28</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R8">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R11">11</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R15">15</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R16">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R19">19</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-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L0R28">28</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">@@ -9,7 +9,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">title VARCHAR(255),</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> content TEXT,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FULLTEXT INDEX(content),</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> KEY(day)</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-) DEFAULT CHARSET UTF8;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+) DEFAULT CHARSET UTF8 COLLATE UTF8_BIN;</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"> Table Create Table</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> diaries CREATE TABLE `diaries` (</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -17,12 +17,12 @@ <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"> `year` int(10) unsigned DEFAULT NULL,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> `month` int(10) unsigned DEFAULT NULL,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> `day` int(10) unsigned DEFAULT NULL,</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- `title` varchar(255) DEFAULT NULL,</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- `content` text,</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ `content` text COLLATE utf8_bin,</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"> KEY `day` (`day`),</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FULLTEXT KEY `content` (`content`)</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-) ENGINE=mroonga DEFAULT CHARSET=utf8</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_bin</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO diaries VALUES(1, 2011, 11, 9, "Hello", "今日からはじめました。");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO diaries VALUES(2, 2011, 11, 10, "天気", "明日の富士山の天気について");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO diaries VALUES(3, 2011, 11, 11, "富士山", "今日も天気がよくてきれいに見える。");</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/order_limit_performance.result (+1 -1)</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L0">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L2">2</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L3">3</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1L6">6</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R0">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R2">2</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/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9#L1R6">6</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">@@ -1,6 +1,6 @@</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table if exists t1;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> flush status;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-create table t1 (c1 int primary key, c2 int, c3 text, _id int, key idx1(c2), fulltext index ft(c3));</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+create table t1 (c1 int primary key, c2 int, c3 text, _id int, key idx1(c2), fulltext index ft(c3)) default charset utf8 collate utf8_bin;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(1,10,"aa ii uu ee oo",null);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(2,20,"ka ki ku ke ko",null);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(3,30,"ii si ii se ii",null);</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>