<!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-01 11:04:34 +0900 (Thu, 01 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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6">e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6</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">select: add drilldowns[LABEL].adjuster</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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967a">test/command/suite/select/drilldowns/adjuster/filter.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86b">test/command/suite/select/drilldowns/adjuster/filter.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1">test/command/suite/select/drilldowns/adjuster/no_filter.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3">test/command/suite/select/drilldowns/adjuster/no_filter.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/drilldowns/adjuster/filter.expected (+90 -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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967a">...</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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967a">...</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR1">1</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR2">2</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR3">3</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR4">4</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR5">5</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR6">6</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR7">7</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR8">8</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR9">9</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR10">10</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR11">11</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR12">12</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR13">13</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR14">14</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR15">15</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR16">16</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR17">17</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR18">18</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR19">19</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR20">20</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR21">21</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR22">22</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR23">23</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR24">24</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR25">25</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR26">26</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR27">27</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR28">28</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR29">29</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR30">30</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR31">31</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR32">32</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR33">33</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR34">34</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR35">35</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR36">36</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR37">37</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR38">38</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR39">39</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR40">40</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR41">41</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR42">42</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR43">43</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR44">44</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR45">45</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR46">46</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR47">47</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR48">48</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR49">49</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR50">50</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR51">51</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR52">52</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR53">53</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR54">54</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR55">55</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR56">56</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR57">57</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR58">58</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR59">59</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR60">60</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR61">61</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR62">62</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR63">63</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR64">64</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR65">65</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR66">66</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR67">67</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR68">68</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR69">69</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR70">70</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR71">71</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR72">72</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR73">73</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR74">74</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR75">75</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR76">76</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR77">77</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR78">78</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR79">79</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR80">80</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR81">81</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR82">82</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR83">83</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR84">84</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR85">85</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR86">86</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR87">87</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR88">88</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR89">89</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-39a24c09ae85d6488e8d699514eb967aR90">90</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,90 @@ +table_create Categories TABLE_PAT_KEY ShortText +[[0,0.0,0.0],true] +table_create Tags TABLE_PAT_KEY ShortText +[[0,0.0,0.0],true] +column_create Tags categories COLUMN_VECTOR|WITH_WEIGHT Categories +[[0,0.0,0.0],true] +table_create Memos TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Memos tags COLUMN_VECTOR Tags +[[0,0.0,0.0],true] +column_create Categories tags_categories COLUMN_INDEX|WITH_WEIGHT Tags categories +[[0,0.0,0.0],true] +load --table Tags +[ +{"_key": "groonga", "categories": {"full-text-search": 100}}, +{"_key": "mroonga", "categories": {"mysql": 100, "full-text-search": 80}}, +{"_key": "ruby", "categories": {"language": 100}} +] +[[0,0.0,0.0],3] +load --table Memos +[ +{ + "_key": "Groonga is fast", + "tags": ["groonga"] +}, +{ + "_key": "Mroonga is also fast", + "tags": ["mroonga", "groonga"] +}, +{ + "_key": "Ruby is an object oriented script language", + "tags": ["ruby"] +} +] +[[0,0.0,0.0],3] +select Memos --limit 0 --output_columns _id --drilldowns[groonga_tag].keys tags --drilldowns[groonga_tag].filter '_key == "groonga"' --drilldowns[groonga_tag].adjuster 'categories @ "full-text-search" * 2 + categories @ "mysql"' --drilldowns[groonga_tag].output_columns _key,_nsubrecs,_score +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "groonga_tag": [ + [ + 1 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "_score", + "Int32" + ] + ], + [ + "groonga", + 2, + 204 + ] + ] + } + ] +] +#>select --drilldowns[groonga_tag].adjuster "categories @ \"full-text-search\" * 2 + categories @ \"mysql\"" --drilldowns[groonga_tag].filter "_key == \"groonga\"" --drilldowns[groonga_tag].keys "tags" --drilldowns[groonga_tag].output_columns "_key,_nsubrecs,_score" --limit "0" --output_columns "_id" --table "Memos" +#:000000000000000 select(3) +#:000000000000000 filter(1) +#:000000000000000 drilldowns[groonga_tag].adjust(1) +#:000000000000000 drilldowns[groonga_tag](1) +#:000000000000000 output(0) +#:000000000000000 output.drilldowns[groonga_tag](1) +#<000000000000000 rc=0 </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/drilldowns/adjuster/filter.test (+43 -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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86b">...</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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86b">...</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR1">1</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR2">2</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR3">3</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR4">4</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR5">5</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR6">6</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR7">7</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR8">8</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR9">9</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR10">10</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR11">11</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR12">12</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR13">13</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR14">14</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR15">15</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR16">16</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR17">17</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR18">18</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR19">19</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR20">20</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR21">21</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR22">22</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR23">23</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR24">24</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR25">25</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR26">26</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR27">27</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR28">28</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR29">29</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR30">30</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR31">31</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR32">32</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR33">33</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR34">34</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR35">35</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR36">36</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR37">37</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR38">38</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR39">39</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR40">40</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR41">41</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR42">42</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-d3d0796d27a75cac5df105185e41c86bR43">43</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,43 @@ +table_create Categories TABLE_PAT_KEY ShortText + +table_create Tags TABLE_PAT_KEY ShortText +column_create Tags categories COLUMN_VECTOR|WITH_WEIGHT Categories + +table_create Memos TABLE_HASH_KEY ShortText +column_create Memos tags COLUMN_VECTOR Tags + +column_create Categories tags_categories COLUMN_INDEX|WITH_WEIGHT \ + Tags categories + +load --table Tags +[ +{"_key": "groonga", "categories": {"full-text-search": 100}}, +{"_key": "mroonga", "categories": {"mysql": 100, "full-text-search": 80}}, +{"_key": "ruby", "categories": {"language": 100}} +] + +load --table Memos +[ +{ + "_key": "Groonga is fast", + "tags": ["groonga"] +}, +{ + "_key": "Mroonga is also fast", + "tags": ["mroonga", "groonga"] +}, +{ + "_key": "Ruby is an object oriented script language", + "tags": ["ruby"] +} +] + +#@collect-query-log true +select Memos \ + --limit 0 \ + --output_columns _id \ + --drilldowns[groonga_tag].keys tags \ + --drilldowns[groonga_tag].filter '_key == "groonga"' \ + --drilldowns[groonga_tag].adjuster 'categories @ "full-text-search" * 2 + categories @ "mysql"' \ + --drilldowns[groonga_tag].output_columns _key,_nsubrecs,_score +#@collect-query-log false </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/drilldowns/adjuster/no_filter.expected (+99 -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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1">...</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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1">...</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R1">1</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R2">2</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R3">3</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R4">4</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R5">5</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R6">6</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R7">7</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R8">8</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R9">9</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R10">10</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R11">11</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R12">12</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R13">13</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R14">14</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R15">15</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R16">16</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R17">17</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R18">18</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R19">19</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R20">20</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R21">21</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R22">22</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R23">23</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R24">24</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R25">25</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R26">26</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R27">27</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R28">28</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R29">29</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R30">30</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R31">31</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R32">32</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R33">33</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R34">34</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R35">35</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R36">36</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R37">37</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R38">38</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R39">39</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R40">40</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R41">41</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R42">42</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R43">43</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R44">44</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R45">45</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R46">46</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R47">47</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R48">48</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R49">49</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R50">50</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R51">51</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R52">52</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R53">53</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R54">54</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R55">55</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R56">56</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R57">57</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R58">58</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R59">59</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R60">60</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R61">61</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R62">62</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R63">63</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R64">64</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R65">65</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R66">66</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R67">67</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R68">68</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R69">69</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R70">70</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R71">71</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R72">72</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R73">73</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R74">74</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R75">75</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R76">76</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R77">77</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R78">78</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R79">79</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R80">80</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R81">81</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R82">82</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R83">83</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R84">84</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R85">85</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R86">86</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R87">87</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R88">88</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R89">89</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R90">90</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R91">91</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R92">92</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R93">93</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R94">94</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R95">95</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R96">96</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R97">97</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R98">98</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-32d5de06573633c0978a2b832c0170e1R99">99</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,99 @@ +table_create Categories TABLE_PAT_KEY ShortText +[[0,0.0,0.0],true] +table_create Tags TABLE_PAT_KEY ShortText +[[0,0.0,0.0],true] +column_create Tags categories COLUMN_VECTOR|WITH_WEIGHT Categories +[[0,0.0,0.0],true] +table_create Memos TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Memos tags COLUMN_VECTOR Tags +[[0,0.0,0.0],true] +column_create Categories tags_categories COLUMN_INDEX|WITH_WEIGHT Tags categories +[[0,0.0,0.0],true] +load --table Tags +[ +{"_key": "groonga", "categories": {"full-text-search": 100}}, +{"_key": "mroonga", "categories": {"mysql": 100, "full-text-search": 80}}, +{"_key": "ruby", "categories": {"language": 100}} +] +[[0,0.0,0.0],3] +load --table Memos +[ +{ + "_key": "Groonga is fast", + "tags": ["groonga"] +}, +{ + "_key": "Mroonga is also fast", + "tags": ["mroonga", "groonga"] +}, +{ + "_key": "Ruby is an object oriented script language", + "tags": ["ruby"] +} +] +[[0,0.0,0.0],3] +select Memos --limit 0 --output_columns _id --drilldowns[tags].keys tags --drilldowns[tags].adjuster 'categories @ "full-text-search" * 2 + categories @ "mysql"' --drilldowns[tags].output_columns _key,_nsubrecs,_score +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "tags": [ + [ + 3 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "_score", + "Int32" + ] + ], + [ + "groonga", + 2, + 203 + ], + [ + "mroonga", + 1, + 265 + ], + [ + "ruby", + 1, + 0 + ] + ] + } + ] +] +#>select --drilldowns[tags].adjuster "categories @ \"full-text-search\" * 2 + categories @ \"mysql\"" --drilldowns[tags].keys "tags" --drilldowns[tags].output_columns "_key,_nsubrecs,_score" --limit "0" --output_columns "_id" --table "Memos" +#:000000000000000 select(3) +#:000000000000000 drilldowns[tags].adjust(3) +#:000000000000000 drilldowns[tags](3) +#:000000000000000 output(0) +#:000000000000000 output.drilldowns[tags](3) +#<000000000000000 rc=0 </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/drilldowns/adjuster/no_filter.test (+42 -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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3">...</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/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3">...</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R1">1</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R2">2</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R3">3</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R4">4</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R5">5</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R6">6</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R7">7</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R8">8</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R9">9</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R10">10</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R11">11</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R12">12</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R13">13</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R14">14</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R15">15</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R16">16</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R17">17</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R18">18</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R19">19</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R20">20</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R21">21</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R22">22</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R23">23</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R24">24</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R25">25</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R26">26</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R27">27</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R28">28</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R29">29</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R30">30</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R31">31</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R32">32</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R33">33</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R34">34</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R35">35</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R36">36</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R37">37</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R38">38</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R39">39</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R40">40</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R41">41</a> <a href="https://github.com/groonga/groonga/commit/e21d1e2ecf319933c0f762b30af8cc4d9f8a62e6#diff-156a3354e9567122b14a52b836006ce3R42">42</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,42 @@ +table_create Categories TABLE_PAT_KEY ShortText + +table_create Tags TABLE_PAT_KEY ShortText +column_create Tags categories COLUMN_VECTOR|WITH_WEIGHT Categories + +table_create Memos TABLE_HASH_KEY ShortText +column_create Memos tags COLUMN_VECTOR Tags + +column_create Categories tags_categories COLUMN_INDEX|WITH_WEIGHT \ + Tags categories + +load --table Tags +[ +{"_key": "groonga", "categories": {"full-text-search": 100}}, +{"_key": "mroonga", "categories": {"mysql": 100, "full-text-search": 80}}, +{"_key": "ruby", "categories": {"language": 100}} +] + +load --table Memos +[ +{ + "_key": "Groonga is fast", + "tags": ["groonga"] +}, +{ + "_key": "Mroonga is also fast", + "tags": ["mroonga", "groonga"] +}, +{ + "_key": "Ruby is an object oriented script language", + "tags": ["ruby"] +} +] + +#@collect-query-log true +select Memos \ + --limit 0 \ + --output_columns _id \ + --drilldowns[tags].keys tags \ + --drilldowns[tags].adjuster 'categories @ "full-text-search" * 2 + categories @ "mysql"' \ + --drilldowns[tags].output_columns _key,_nsubrecs,_score +#@collect-query-log false </pre> </td> </tr> </tbody> </table> </div> </body> </html>