<!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-01-18 22:56:54 +0900 (Sun, 18 Jan 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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96">96eb9efdc65b7d37bb160170c6cd287f6aacbe96</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">Add a test for indexscan match</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Copied files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li>
<a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#diff-1">expected/text/indexscan.out</a><br>
(from expected/text/seqscan.out)
</li>
<li>
<a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#diff-3">sql/text/indexscan.sql</a><br>
(from sql/text/seqscan.sql)
</li>
</ul>
</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#diff-0">Makefile</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#diff-2">expected/text/seqscan.out</a></li>
<li><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#diff-4">sql/text/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: Makefile (+1 -0)</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L6">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L9">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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0L12">12</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R6">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R9">9</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L0R13">13</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">@@ -7,6 +7,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">PG_CPPFLAGS = $(shell pkg-config --cflags groonga)</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHLIB_LINK = $(shell pkg-config --libs groonga)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # REGRESS = pgroonga update bench</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> REGRESS = $(shell find sql -name '*.sql' | sed -e 's,\(^sql/\|\.sql$$\),,g')</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+REGRESS_OPTS = --load-extension=pgroonga</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ifdef DEBUG</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> COPT += -O0 -g3 -DPGROONGA_DEBUG=1</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"> Copied: expected/text/indexscan.out (+3 -3) 89%</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L0">...</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L4">4</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L6">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L9">9</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L10">10</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L11">11</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L14">14</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L18">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1L21">21</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R0">...</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R3">3</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R5">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R8">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-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R9">9</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R13">13</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R17">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R20">20</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L1R21">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">@@ -1,4 +1,3 @@</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-CREATE EXTENSION pgroonga;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</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-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -7,8 +6,8 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');</span></span>
<span class="diff-not-changed" style="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-not-changed" style="display: block; white-space: pre"> CREATE INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SET enable_seqscan = on;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SET enable_indexscan = off;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SET enable_seqscan = off;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; 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-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -19,3 +18,4 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT id, content</span></span>
<span class="diff-not-changed" style="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"> (2 rows)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; 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/text/seqscan.out (+1 -1)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L0">...</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L4">4</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L18">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2L21">21</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R0">...</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R3">3</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R17">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R20">20</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L2R21">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">@@ -1,4 +1,3 @@</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-CREATE EXTENSION pgroonga;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</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-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -19,3 +18,4 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT id, content</span></span>
<span class="diff-not-changed" style="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"> (2 rows)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; 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"> Copied: sql/text/indexscan.sql (+4 -4) 84%</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L0">...</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L1">1</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L5">5</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L10">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L11">11</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L13">13</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L14">14</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L15">15</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3L20">20</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>
</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R0">...</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R3">3</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R8">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R11">11</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R12">12</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R13">13</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R15">15</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R18">18</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R19">19</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L3R20">20</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">@@ -1,5 +1,3 @@</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-CREATE EXTENSION pgroonga;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</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-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -11,10 +9,12 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groon</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"> CREATE INDEX grnindex ON memos USING pgroonga (content);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SET enable_seqscan = on;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-SET enable_indexscan = off;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SET enable_seqscan = off;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; 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"> </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-not-changed" style="display: block; white-space: pre"> WHERE content %% 'Groonga';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; 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/text/seqscan.sql (+2 -2)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L0">...</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L1">1</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L5">5</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L17">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4L20">20</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>
</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R0">...</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/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R3">3</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R15">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R18">18</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R19">19</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga/commit/96eb9efdc65b7d37bb160170c6cd287f6aacbe96#L4R20">20</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">@@ -1,5 +1,3 @@</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-CREATE EXTENSION pgroonga;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</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-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -18,3 +16,5 @@ <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"> SELECT id, content</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FROM memos</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> WHERE content %% 'Groonga';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+DROP TABLE memos;</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>