<!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">2015-10-28 22:21:53 +0900 (Wed, 28 Oct 2015)</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193">b0e68794de2ab453247dd7c9766e74e0a9847193</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">test: improve test data</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75">expected/full-text-search/text/single/like/end/bitmapscan.out</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455">expected/full-text-search/text/single/like/end/indexscan.out</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5">expected/full-text-search/text/single/like/end/seqscan.out</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7ee">sql/full-text-search/text/single/like/end/bitmapscan.sql</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfdd">sql/full-text-search/text/single/like/end/indexscan.sql</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76">sql/full-text-search/text/single/like/end/seqscan.sql</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: expected/full-text-search/text/single/like/end/bitmapscan.out (+8 -8)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L4">4</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L8">8</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L14">14</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L16">16</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L17">17</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L18">18</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75L21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R4">4</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R5">5</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R14">14</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R15">15</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R16">16</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R17">17</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-459134bc3bbda81681c8452048643d75R21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -2,20 +2,20 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id integer,</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"> );</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_indexscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_bitmapscan = on;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- id | content <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> </span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-----+------------------------------------------------------<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">-</span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- 3 | PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+----+------------------------------------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ 3 | PGroonga is a PostgreSQL extension that uses Groonga</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> (1 row)</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 memos;</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; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: expected/full-text-search/text/single/like/end/indexscan.out (+8 -8)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L4">4</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L8">8</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L14">14</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L16">16</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L17">17</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L18">18</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455L21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R4">4</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R5">5</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R14">14</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R15">15</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R16">16</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R17">17</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-d041a04374bea6b68c030439dd867455R21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -2,20 +2,20 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id integer,</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"> );</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_indexscan = on;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_bitmapscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- id | content <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> </span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-----+------------------------------------------------------<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">-</span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- 3 | PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+----+------------------------------------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ 3 | PGroonga is a PostgreSQL extension that uses Groonga</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> (1 row)</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 memos;</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; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: expected/full-text-search/text/single/like/end/seqscan.out (+8 -8)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L4">4</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L8">8</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L14">14</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L16">16</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L17">17</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L18">18</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5L21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R1">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R4">4</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R5">5</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R14">14</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R15">15</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R16">16</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R17">17</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6de0bccbdd7bc643dc1cee5e21b485f5R21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -2,20 +2,20 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id integer,</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"> );</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = on;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_indexscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_bitmapscan = off;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- id | content <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> </span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-----+------------------------------------------------------<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">-</span></span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- 3 | PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+----+------------------------------------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ 3 | PGroonga is a PostgreSQL extension that uses Groonga</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> (1 row)</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 memos;</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; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: sql/full-text-search/text/single/like/end/bitmapscan.sql (+5 -5)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL8">8</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL9">9</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL18">18</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL19">19</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeL21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR5">5</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR8">8</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR18">18</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-089f71380829f4cd6fa03b65f884b7eeR21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -3,10 +3,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</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"> );</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</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 INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -16,6 +16,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SET enable_bitmapscan = on;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</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 memos;</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; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: sql/full-text-search/text/single/like/end/indexscan.sql (+5 -5)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL8">8</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL9">9</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL18">18</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL19">19</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddL21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR5">5</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR8">8</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR18">18</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-6cc2e2d1bf7e55a3a5711cb94e49bfddR21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -3,10 +3,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</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"> );</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</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 INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -16,6 +16,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SET enable_bitmapscan = off;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</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 memos;</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; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: sql/full-text-search/text/single/like/end/seqscan.sql (+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; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L5">5</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L6">6</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L7">7</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L8">8</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L9">9</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L18">18</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L19">19</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/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76L21">21</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R2">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R5">5</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: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R8">8</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R12">12</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R18">18</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193#diff-0cc7b0be5ef1bd023cb3c691db0c7b76R21">21</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -3,10 +3,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE memos (</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"> );</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-INSERT INTO memos VALUES (4, 'groonga command is provided<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+INSERT INTO memos VALUES (4, 'groonga command is provided');</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 INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -16,6 +16,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SET enable_bitmapscan = off;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">- WHERE content LIKE '%Groonga<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span>';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WHERE content LIKE '%Groonga';</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 memos;</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>