<!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-02-26 23:51:10 +0900 (Sun, 26 Feb 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/5bd50ed119e112d323da8204bd423f46460464af">5bd50ed119e112d323da8204bd423f46460464af</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Merge</dt>
<dd style="margin-left: 8.5em">
<ul>
<li>Merged b1c398d: Merge branch 'master' of github.com:mroonga/mroonga</li>
</ul>
</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">multiple-column-index: Use target type as the first column.</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/5bd50ed119e112d323da8204bd423f46460464af#diff-0">test/sql/suite/mroonga_storage/r/multiple_column_index_int.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#diff-1">test/sql/suite/mroonga_storage/t/multiple_column_index_int.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_storage/r/multiple_column_index_int.result (+5 -7)</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/5bd50ed119e112d323da8204bd423f46460464af#L0L3">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L6">6</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/5bd50ed119e112d323da8204bd423f46460464af#L0L7">7</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/5bd50ed119e112d323da8204bd423f46460464af#L0L8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L10">10</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L12">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L15">15</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/5bd50ed119e112d323da8204bd423f46460464af#L0L16">16</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L19">19</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L24">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L27">27</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/5bd50ed119e112d323da8204bd423f46460464af#L0L28">28</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/5bd50ed119e112d323da8204bd423f46460464af#L0L29">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/5bd50ed119e112d323da8204bd423f46460464af#L0L30">30</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L35">35</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/5bd50ed119e112d323da8204bd423f46460464af#L0L36">36</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0L38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0L39">39</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/5bd50ed119e112d323da8204bd423f46460464af#L0R3">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R6">6</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/5bd50ed119e112d323da8204bd423f46460464af#L0R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R10">10</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R12">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R15">15</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R19">19</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R24">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R27">27</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/5bd50ed119e112d323da8204bd423f46460464af#L0R28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R29">29</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/5bd50ed119e112d323da8204bd423f46460464af#L0R30">30</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R33">33</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L0R36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L0R37">37</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">@@ -4,7 +4,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">create table scores (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id int primary key auto_increment not null,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> name char(30) not null,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> score int not null,</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-index property (name, score)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+index property (score, name)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ) default charset utf8;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> show create table scores;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Table Create Table</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -13,7 +13,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">scores CREATE TABLE `scores` (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> `name` char(30) NOT NULL,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> `score` int(11) NOT NULL,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> PRIMARY KEY (`id`),</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- KEY `property` (`name`,`score`)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ KEY `property` (`score`,`name`)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ) ENGINE=mroonga DEFAULT CHARSET=utf8</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into scores (name, score) values("Taro Yamada", 29);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into scores (name, score) values("Taro Yamada", -12);</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -25,15 +25,13 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">id name score</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 Taro Yamada -12</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 Jiro Yamada 27</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 4 Taro Yamada 10</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada";</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where score = 29;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id name score</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-2 Taro Yamada -12</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-4 Taro Yamada 10</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 1 Taro Yamada 29</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada" and score = 29;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where score = 29 and name = "Taro Yamada";</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id name score</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 1 Taro Yamada 29</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada" and (score >= -12 and score < 29);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where (score >= -12 and score < 29) and name = "Taro Yamada";</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id name score</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 Taro Yamada -12</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 4 Taro Yamada 10</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/t/multiple_column_index_int.test (+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/5bd50ed119e112d323da8204bd423f46460464af#L1L24">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1L25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1L27">27</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/5bd50ed119e112d323da8204bd423f46460464af#L1L28">28</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/5bd50ed119e112d323da8204bd423f46460464af#L1L29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1L31">31</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1L32">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1L33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1L34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1L35">35</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1L37">37</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/5bd50ed119e112d323da8204bd423f46460464af#L1L38">38</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1L41">41</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/5bd50ed119e112d323da8204bd423f46460464af#L1R24">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1R27">27</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/5bd50ed119e112d323da8204bd423f46460464af#L1R28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1R31">31</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R32">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R35">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-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/5bd50ed119e112d323da8204bd423f46460464af#L1R36">36</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/5bd50ed119e112d323da8204bd423f46460464af#L1R37">37</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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#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/5bd50ed119e112d323da8204bd423f46460464af#L1R41">41</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">@@ -25,7 +25,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">create table scores (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id int primary key auto_increment not null,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> name char(30) not null,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> score int not null,</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- index property (name, score)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ index property (score, name)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ) default charset utf8;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> show create table scores;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into scores (name, score) values("Taro Yamada", 29);</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -33,9 +33,9 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">insert into scores (name, score) values("Taro Yamada", -12);</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into scores (name, score) values("Jiro Yamada", 27);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into scores (name, score) values("Taro Yamada", 10);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from scores;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada";</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada" and score = 29;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-select * from scores where name = "Taro Yamada" and (score >= -12 and score < 29);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where score = 29;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where score = 29 and name = "Taro Yamada";</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+select * from scores where (score >= -12 and score < 29) and name = "Taro Yamada";</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table scores;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --source include/have_mroonga_deinit.inc</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>