<!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">2018-02-13 18:10:26 +0900 (Tue, 13 Feb 2018)</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b">08e7520bfc6be9dc81404311961a5b1007af7c8b</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">test: add missing tests for '<', '>' and '~'</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524b">test/command/suite/select/query/adjust/decrement.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4c">test/command/suite/select/query/adjust/decrement.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340e">test/command/suite/select/query/adjust/increment.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7">test/command/suite/select/query/adjust/increment.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620">test/command/suite/select/query/adjust/mix.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44">test/command/suite/select/query/adjust/mix.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234">test/command/suite/select/query/adjust/negative.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8">test/command/suite/select/query/adjust/negative.test</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: test/command/suite/select/query/adjust/decrement.expected (+44 -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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524b">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524b">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR21">21</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR22">22</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR23">23</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR24">24</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR25">25</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR26">26</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR27">27</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR28">28</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR29">29</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR30">30</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR31">31</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR32">32</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR33">33</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR34">34</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR35">35</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR36">36</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR37">37</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR38">38</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR39">39</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR40">40</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR41">41</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR42">42</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR43">43</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-13ddb10af2ebb594ab7ef9b2cc64524bR44">44</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,44 @@ +table_create Memos TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Memos content COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto +[[0,0.0,0.0],true] +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content +[[0,0.0,0.0],true] +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] +[[0,0.0,0.0],3] +select Memos --match_columns content --query 'Groonga <Ruby' --output_columns 'content, _score' --sort_keys -_score,_id +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 1 + ], + [ + [ + "content", + "ShortText" + ], + [ + "_score", + "Int32" + ] + ], + [ + "Rroonga is the Ruby bindings of Groonga.", + 6 + ] + ] + ] +] </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: test/command/suite/select/query/adjust/decrement.test (+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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4c">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4c">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-c9dd0c5d5b7dc74fa2ee53ae1abb9f4cR21">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 @@ +table_create Memos TABLE_NO_KEY +column_create Memos content COLUMN_SCALAR ShortText + +table_create Terms TABLE_PAT_KEY ShortText \ + --default_tokenizer TokenBigram \ + --normalizer NormalizerAuto +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content + +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] + +select Memos \ + --match_columns content \ + --query 'Groonga <Ruby' \ + --output_columns 'content, _score' \ + --sort_keys -_score,_id + </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: test/command/suite/select/query/adjust/increment.expected (+44 -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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340e">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340e">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR21">21</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR22">22</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR23">23</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR24">24</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR25">25</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR26">26</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR27">27</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR28">28</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR29">29</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR30">30</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR31">31</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR32">32</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR33">33</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR34">34</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR35">35</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR36">36</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR37">37</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR38">38</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR39">39</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR40">40</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR41">41</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR42">42</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR43">43</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-2d7f5df23b6703ae24a13988edd7340eR44">44</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,44 @@ +table_create Memos TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Memos content COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto +[[0,0.0,0.0],true] +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content +[[0,0.0,0.0],true] +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] +[[0,0.0,0.0],3] +select Memos --match_columns content --query 'Groonga >Ruby' --output_columns 'content, _score' --sort_keys -_score,_id +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 1 + ], + [ + [ + "content", + "ShortText" + ], + [ + "_score", + "Int32" + ] + ], + [ + "Rroonga is the Ruby bindings of Groonga.", + 8 + ] + ] + ] +] </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: test/command/suite/select/query/adjust/increment.test (+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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-53a949153c542c09c52e5697c5f6c0d7R21">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 @@ +table_create Memos TABLE_NO_KEY +column_create Memos content COLUMN_SCALAR ShortText + +table_create Terms TABLE_PAT_KEY ShortText \ + --default_tokenizer TokenBigram \ + --normalizer NormalizerAuto +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content + +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] + +select Memos \ + --match_columns content \ + --query 'Groonga >Ruby' \ + --output_columns 'content, _score' \ + --sort_keys -_score,_id + </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: test/command/suite/select/query/adjust/mix.expected (+48 -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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R21">21</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R22">22</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R23">23</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R24">24</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R25">25</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R26">26</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R27">27</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R28">28</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R29">29</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R30">30</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R31">31</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R32">32</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R33">33</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R34">34</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R35">35</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R36">36</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R37">37</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R38">38</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R39">39</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R40">40</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R41">41</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R42">42</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R43">43</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R44">44</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R45">45</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R46">46</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R47">47</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-b23b532d1a2ae67642dff85f5f9dd620R48">48</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,48 @@ +table_create Memos TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Memos content COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto +[[0,0.0,0.0],true] +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content +[[0,0.0,0.0],true] +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] +[[0,0.0,0.0],3] +select Memos --match_columns content --query 'Groonga (>Ruby OR <Mroonga) ~MySQL' --output_columns 'content, _score' --sort_keys -_score,_id +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 2 + ], + [ + [ + "content", + "ShortText" + ], + [ + "_score", + "Int32" + ] + ], + [ + "Rroonga is the Ruby bindings of Groonga.", + 8 + ], + [ + "Mroonga is a MySQL storage engine based of Groonga.", + 3 + ] + ] + ] +] </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: test/command/suite/select/query/adjust/mix.test (+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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-0918b0f649ae79749493f3fa5fae2e44R20">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 @@ +table_create Memos TABLE_NO_KEY +column_create Memos content COLUMN_SCALAR ShortText + +table_create Terms TABLE_PAT_KEY ShortText \ + --default_tokenizer TokenBigram \ + --normalizer NormalizerAuto +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content + +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] + +select Memos \ + --match_columns content \ + --query 'Groonga (>Ruby OR <Mroonga) ~MySQL' \ + --output_columns 'content, _score' \ + --sort_keys -_score,_id </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: test/command/suite/select/query/adjust/negative.expected (+52 -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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R20">20</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R21">21</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R22">22</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R23">23</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R24">24</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R25">25</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R26">26</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R27">27</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R28">28</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R29">29</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R30">30</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R31">31</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R32">32</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R33">33</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R34">34</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R35">35</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R36">36</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R37">37</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R38">38</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R39">39</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R40">40</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R41">41</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R42">42</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R43">43</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R44">44</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R45">45</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R46">46</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R47">47</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R48">48</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R49">49</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R50">50</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R51">51</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-6732a95e5ccb7dcabbe536abdd9ae234R52">52</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,52 @@ +table_create Memos TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Memos content COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto +[[0,0.0,0.0],true] +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content +[[0,0.0,0.0],true] +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] +[[0,0.0,0.0],3] +select Memos --match_columns content --query 'Groonga ~Ruby' --output_columns 'content, _score' --sort_keys -_score,_id +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "content", + "ShortText" + ], + [ + "_score", + "Int32" + ] + ], + [ + "Groonga is a full text search engine.", + 1 + ], + [ + "Mroonga is a MySQL storage engine based of Groonga.", + 1 + ], + [ + "Rroonga is the Ruby bindings of Groonga.", + -3 + ] + ] + ] +] </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: test/command/suite/select/query/adjust/negative.test (+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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8">...</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/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8">...</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R1">1</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R2">2</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R3">3</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R4">4</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R5">5</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R6">6</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R7">7</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R8">8</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R9">9</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R10">10</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R11">11</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R12">12</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R13">13</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R14">14</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R15">15</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R16">16</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R17">17</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R18">18</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R19">19</a> <a href="https://github.com/groonga/groonga/commit/08e7520bfc6be9dc81404311961a5b1007af7c8b#diff-1f8f50e01733b7a200b66a447beb5cc8R20">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 @@ +table_create Memos TABLE_NO_KEY +column_create Memos content COLUMN_SCALAR ShortText + +table_create Terms TABLE_PAT_KEY ShortText \ + --default_tokenizer TokenBigram \ + --normalizer NormalizerAuto +column_create Terms index COLUMN_INDEX|WITH_POSITION Memos content + +load --table Memos +[ +{"content": "Groonga is a full text search engine."}, +{"content": "Rroonga is the Ruby bindings of Groonga."}, +{"content": "Mroonga is a MySQL storage engine based of Groonga."} +] + +select Memos \ + --match_columns content \ + --query 'Groonga ~Ruby' \ + --output_columns 'content, _score' \ + --sort_keys -_score,_id </pre> </td> </tr> </tbody> </table> </div> </body> </html>