<!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-14 18:31:35 +0900 (Wed, 14 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/c8cff3f4bdd1586eb320d7b8f96384a9e9076759">c8cff3f4bdd1586eb320d7b8f96384a9e9076759</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">Support LIKE by pgroonga.text_regexp_ops</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93">expected/regexp/text/like/begin-of-text/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5">expected/regexp/text/like/begin-of-text/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4">expected/regexp/text/like/begin-of-text/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828">expected/regexp/text/like/end-of-text/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4">expected/regexp/text/like/end-of-text/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0">expected/regexp/text/like/end-of-text/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356">expected/regexp/text/like/exact/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878ee">expected/regexp/text/like/exact/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161">expected/regexp/text/like/exact/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73a">expected/regexp/text/like/partial/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928ada">expected/regexp/text/like/partial/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872">expected/regexp/text/like/partial/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3">sql/regexp/text/like/begin-of-text/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3">sql/regexp/text/like/begin-of-text/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416">sql/regexp/text/like/begin-of-text/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84c">sql/regexp/text/like/end-of-text/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2d">sql/regexp/text/like/end-of-text/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0">sql/regexp/text/like/end-of-text/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1">sql/regexp/text/like/exact/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553">sql/regexp/text/like/exact/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012e">sql/regexp/text/like/exact/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4ae">sql/regexp/text/like/partial/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631f">sql/regexp/text/like/partial/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9">sql/regexp/text/like/partial/seqscan.sql</a></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/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21">pgroonga--0.9.0--1.0.0.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49">pgroonga.c</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773">pgroonga.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"> Added: expected/regexp/text/like/begin-of-text/bitmapscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-bf6d671c755f41493c588bbf6d9ecc93R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/begin-of-text/indexscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-945b6236211901f2e5b74105f1e791b5R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/begin-of-text/seqscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-cb5b043cc5295f29117d0e3319ae65e4R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/end-of-text/bitmapscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b13cd4715f39476586396bbaa165c828R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/end-of-text/indexscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-1e5917cbe42ebf91db622d5ae2d702e4R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/end-of-text/seqscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0c7c1ceb15de8bf83b290d35be4fcc0R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/exact/bitmapscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-46fb3967fc2b81908235911ff1689356R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/exact/indexscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878ee">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878ee">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a358a1775d66587b53513d4e34e878eeR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/exact/seqscan.out (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ccb7c637e1751b3dfc123dbb1e9f4161R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/partial/bitmapscan.out (+21 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73a">...</a>                                           </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73a">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-74849d630d6ed2feb4bbb0e00c5fb73aR21">21</a> </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">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/partial/indexscan.out (+21 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928ada">...</a>                                           </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928ada">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c7d8133ffb150a410e2b434a7b928adaR21">21</a> </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">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </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"> Added: expected/regexp/text/like/partial/seqscan.out (+21 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872">...</a>                                           </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-22545d719cd36cbe60b62d3f3f143872R21">21</a> </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">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </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"> Modified: pgroonga--0.9.0--1.0.0.sql (+1 -0) =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L39">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L40">40</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L41">41</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L42">42</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L43">43</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L44">44</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21L45">45</a> </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R39">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R40">40</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R41">41</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R42">42</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R43">43</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R44">44</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R45">45</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-c360e0538b5244106e4378d0bd562c21R46">46</a> </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">@@ -40,6 +40,7 @@ CREATE OPERATOR @~ ( CREATE OPERATOR CLASS pgroonga.text_regexp_ops FOR TYPE text USING pgroonga AS + OPERATOR 6 pg_catalog.~~, OPERATOR 10 @~; CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops FOR TYPE varchar </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"> Modified: pgroonga.c (+128 -4) =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L195">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L196">196</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L197">197</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L198">198</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L199">199</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L200">200</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L201">201</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L426">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L427">427</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L428">428</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L429">429</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L430">430</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L431">431</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L432">432</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L575">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L576">576</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L577">577</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L578">578</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L579">579</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L580">580</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L581">581</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2993">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2994">2994</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2995">2995</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2996">2996</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2997">2997</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2998">2998</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2999">2999</a>       <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3000">3000</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3001">3001</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3002">3002</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3024">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3025">3025</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3026">3026</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3027">3027</a>                                                                                                                                                                                                                                             <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3028">3028</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3029">3029</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3030">3030</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3347">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3348">3348</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3349">3349</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3350">3350</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3351">3351</a>         <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3352">3352</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3353">3353</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3354">3354</a> </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R195">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R196">196</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R197">197</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R198">198</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R199">199</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R200">200</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R201">201</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R202">202</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R427">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R428">428</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R429">429</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R430">430</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R431">431</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R432">432</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R433">433</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R434">434</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R577">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R578">578</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R579">579</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R580">580</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R581">581</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R582">582</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R583">583</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R584">584</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2996">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2997">2997</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2998">2998</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2999">2999</a>       <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3000">3000</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3001">3001</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3002">3002</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3003">3003</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3004">3004</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3005">3005</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3027">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3028">3028</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3029">3029</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3030">3030</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3031">3031</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3032">3032</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3033">3033</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3034">3034</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3035">3035</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3036">3036</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3037">3037</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3038">3038</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3039">3039</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3040">3040</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3041">3041</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3042">3042</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3043">3043</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3044">3044</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3045">3045</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3046">3046</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3047">3047</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3048">3048</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3049">3049</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3050">3050</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3051">3051</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3052">3052</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3053">3053</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3054">3054</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3055">3055</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3056">3056</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3057">3057</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3058">3058</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3059">3059</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3060">3060</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3061">3061</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3062">3062</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3063">3063</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3064">3064</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3065">3065</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3066">3066</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3067">3067</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3068">3068</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3069">3069</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3070">3070</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3071">3071</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3072">3072</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3073">3073</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3074">3074</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3075">3075</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3076">3076</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3077">3077</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3078">3078</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3079">3079</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3080">3080</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3081">3081</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3082">3082</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3083">3083</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3084">3084</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3085">3085</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3086">3086</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3087">3087</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3088">3088</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3089">3089</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3090">3090</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3091">3091</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3092">3092</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3093">3093</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3094">3094</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3095">3095</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3096">3096</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3097">3097</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3098">3098</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3099">3099</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3100">3100</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3101">3101</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3102">3102</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3103">3103</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3104">3104</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3105">3105</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3106">3106</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3107">3107</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3108">3108</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3109">3109</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3110">3110</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3111">3111</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3112">3112</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3113">3113</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3114">3114</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3115">3115</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3116">3116</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3117">3117</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3118">3118</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3119">3119</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3120">3120</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3121">3121</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3122">3122</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3123">3123</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3124">3124</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3125">3125</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3126">3126</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3127">3127</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3128">3128</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3129">3129</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3130">3130</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3131">3131</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3132">3132</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3133">3133</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3134">3134</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3135">3135</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3136">3136</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3137">3137</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3138">3138</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3139">3139</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3140">3140</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3141">3141</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3142">3142</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3143">3143</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3144">3144</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3145">3145</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3146">3146</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3147">3147</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3148">3148</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3149">3149</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3150">3150</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3151">3151</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3468">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3469">3469</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3470">3470</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3471">3471</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3472">3472</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3473">3473</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3474">3474</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3475">3475</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3476">3476</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3477">3477</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3478">3478</a> </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">@@ -196,6 +196,7 @@ static grn_ctx grnContext; static grn_ctx *ctx = NULL; static grn_obj buffer; static grn_obj pathBuffer; +static grn_obj patternBuffer; static grn_obj ctidBuffer; static grn_obj scoreBuffer; static grn_obj headBuffer; @@ -427,6 +428,7 @@ PGrnOnProcExit(int code, Datum arg) GRN_OBJ_FIN(ctx, &headBuffer); GRN_OBJ_FIN(ctx, &ctidBuffer); GRN_OBJ_FIN(ctx, &scoreBuffer); + GRN_OBJ_FIN(ctx, &patternBuffer); GRN_OBJ_FIN(ctx, &pathBuffer); GRN_OBJ_FIN(ctx, &buffer); @@ -576,6 +578,7 @@ _PG_init(void) GRN_VOID_INIT(&buffer); GRN_TEXT_INIT(&pathBuffer, 0); + GRN_TEXT_INIT(&patternBuffer, 0); GRN_FLOAT_INIT(&scoreBuffer, 0); GRN_UINT64_INIT(&ctidBuffer, 0); GRN_TEXT_INIT(&headBuffer, 0); @@ -2994,9 +2997,9 @@ pgroonga_beginscan(PG_FUNCTION_ARGS) } static void -PGrnSearchBuildConditionLike(PGrnSearchData *data, - grn_obj *matchTarget, - grn_obj *query) +PGrnSearchBuildConditionLikeMatch(PGrnSearchData *data, + grn_obj *matchTarget, + grn_obj *query) { grn_obj *expression; const char *queryRaw; @@ -3025,6 +3028,124 @@ PGrnSearchBuildConditionLike(PGrnSearchData *data, grn_expr_append_op(ctx, expression, GRN_OP_MATCH, 2); } +static void +PGrnSearchBuildConditionLikeRegexp(PGrnSearchData *data, + grn_obj *matchTarget, + grn_obj *query) +{ + grn_obj *expression; + const char *queryRaw; + const char *queryRawEnd; + const char *queryRawCurrent; + size_t querySize; + int characterSize; + bool escaping = false; + bool lastIsPercent = false; + + expression = data->expression; + queryRaw = GRN_TEXT_VALUE(query); + querySize = GRN_TEXT_LEN(query); + queryRawEnd = queryRaw + querySize; + + GRN_BULK_REWIND(&patternBuffer); + if (queryRaw[0] != '%') + GRN_TEXT_PUTS(ctx, &patternBuffer, "\\A"); + + queryRawCurrent = queryRaw; + while ((characterSize = grn_charlen(ctx, queryRawCurrent, queryRawEnd)) > 0) + { + const char *current = queryRawCurrent; + bool needToAddCharacter = true; + + queryRawCurrent += characterSize; + + if (!escaping && characterSize == 1) + { + switch (current[0]) + { + case '%': + if (queryRaw == current) + { + /* do nothing */ + } + else if (queryRawCurrent == queryRawEnd) + { + lastIsPercent = true; + } + else + { + GRN_TEXT_PUTS(ctx, &patternBuffer, ".*"); + } + needToAddCharacter = false; + break; + case '_': + GRN_TEXT_PUTC(ctx, &patternBuffer, '.'); + needToAddCharacter = false; + break; + case '\\': + escaping = true; + needToAddCharacter = false; + break; + default: + break; + } + + if (!needToAddCharacter) + continue; + } + + if (characterSize == 1) + { + switch (current[0]) + { + case '\\': + case '|': + case '(': + case ')': + case '[': + case ']': + case '.': + case '*': + case '+': + case '?': + case '{': + case '}': + case '^': + case '$': + GRN_TEXT_PUTC(ctx, &patternBuffer, '\\'); + GRN_TEXT_PUTC(ctx, &patternBuffer, current[0]); + break; + default: + GRN_TEXT_PUTC(ctx, &patternBuffer, current[0]); + break; + } + } + else + { + GRN_TEXT_PUT(ctx, &patternBuffer, current, characterSize); + } + escaping = false; + } + + if (queryRawCurrent != queryRawEnd) + { + ereport(ERROR, + (errcode(ERRCODE_INVALID_PARAMETER_VALUE), + errmsg("invalid encoding character exist: <%.*s>", + (int) querySize, queryRaw))); + } + + if (!lastIsPercent) + GRN_TEXT_PUTS(ctx, &patternBuffer, "\\z"); + + grn_expr_append_obj(ctx, expression, matchTarget, GRN_OP_PUSH, 1); + grn_expr_append_const_str(ctx, expression, + GRN_TEXT_VALUE(&patternBuffer), + GRN_TEXT_LEN(&patternBuffer), + GRN_OP_PUSH, 1); + grn_expr_append_op(ctx, expression, GRN_OP_REGEXP, 2); +} + #ifdef JSONBOID static void PGrnSearchBuildConditionJSONQuery(PGrnSearchData *data, @@ -3348,7 +3469,10 @@ PGrnSearchBuildCondition(IndexScanDesc scan, switch (key->sk_strategy) { case PGrnLikeStrategyNumber: - PGrnSearchBuildConditionLike(data, matchTarget, &buffer); + if (PGrnIsForRegexpSearchIndex(index, key->sk_attno - 1)) + PGrnSearchBuildConditionLikeRegexp(data, matchTarget, &buffer); + else + PGrnSearchBuildConditionLikeMatch(data, matchTarget, &buffer); break; case PGrnQueryStrategyNumber: { </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"> Modified: pgroonga.sql (+1 -0) =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L363">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L364">364</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L365">365</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L366">366</a>   <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L367">367</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L368">368</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773L369">369</a> </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R363">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R364">364</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R365">365</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R366">366</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R367">367</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R368">368</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R369">369</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-880e4f74ffc33862c9dcd6c9b4197773R370">370</a> </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">@@ -364,6 +364,7 @@ $$; CREATE OPERATOR CLASS pgroonga.text_regexp_ops FOR TYPE text USING pgroonga AS + OPERATOR 6 pg_catalog.~~, OPERATOR 10 @~; CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops FOR TYPE varchar </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"> Added: sql/regexp/text/like/begin-of-text/bitmapscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-d772d0cea41800f2efe184f2818571b3R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/begin-of-text/indexscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-f81255cc9abd45fedffec8daf50cbec3R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/begin-of-text/seqscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b6d13efadceefd3968de5139e5fa8416R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga%'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/end-of-text/bitmapscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84c">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84c">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-43b00abd079aaf7388ac7a090d1fc84cR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/end-of-text/indexscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2d">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2d">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-3a125c30180fc4197cc65ee733eb4f2dR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/end-of-text/seqscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0da9db74a765f55603c0c26f1db718a0R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/exact/bitmapscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-ed99793193d6618b00c9669dc0f20dd1R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/exact/indexscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-b7257f7769c8fa38140b2a227a81e553R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/exact/seqscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012e">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012e">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-56fdfa2a5591fee61e88902da7ed012eR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE 'Groonga'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/partial/bitmapscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4ae">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4ae">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-0ccc60c51f47ce6fb89209f94f62e4aeR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/partial/indexscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631f">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631f">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-47286ce1761a98a27eaf24415b19631fR20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + +DROP TABLE memos; </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"> Added: sql/regexp/text/like/partial/seqscan.sql (+20 -0) 100644 =================================================================== </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9">...</a>                                         </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"><a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/c8cff3f4bdd1586eb320d7b8f96384a9e9076759#diff-511b2e458f5306968f8f55a42c6492d9R20">20</a> </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">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content LIKE '%Groonga%'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> </div> </body> </html>