<!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">Kentaro Hayashi <hayas****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2017-04-20 16:38:38 +0900 (Thu, 20 Apr 2017)</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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e">ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Merge</dt> <dd style="margin-left: 8.5em"> <ul> <li>Merged <a href="https://github.com/groonga/groonga/commit/1dd9367">1dd9367</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/658">#658</a> from kenhys/test-cache-columns-window-group-keys</li> </ul> </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 columns[NAME].window.group_keys test case without cache When the value of --columns[NAME].window.group_keys parameter is changed, Groonga returns result without using cache.</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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2">test/command/suite/sharding/logical_select/cache/columns/window/group_keys.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739">test/command/suite/sharding/logical_select/cache/columns/window/group_keys.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/sharding/logical_select/cache/columns/window/group_keys.expected (+130 -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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2">...</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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2">...</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R1">1</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R2">2</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R3">3</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R4">4</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R5">5</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R6">6</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R7">7</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R8">8</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R9">9</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R10">10</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R11">11</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R12">12</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R13">13</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R14">14</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R15">15</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R16">16</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R17">17</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R18">18</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R19">19</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R20">20</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R21">21</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R22">22</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R23">23</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R24">24</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R25">25</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R26">26</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R27">27</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R28">28</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R29">29</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R30">30</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R31">31</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R32">32</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R33">33</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R34">34</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R35">35</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R36">36</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R37">37</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R38">38</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R39">39</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R40">40</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R41">41</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R42">42</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R43">43</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R44">44</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R45">45</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R46">46</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R47">47</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R48">48</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R49">49</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R50">50</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R51">51</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R52">52</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R53">53</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R54">54</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R55">55</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R56">56</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R57">57</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R58">58</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R59">59</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R60">60</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R61">61</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R62">62</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R63">63</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R64">64</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R65">65</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R66">66</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R67">67</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R68">68</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R69">69</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R70">70</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R71">71</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R72">72</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R73">73</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R74">74</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R75">75</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R76">76</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R77">77</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R78">78</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R79">79</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R80">80</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R81">81</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R82">82</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R83">83</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R84">84</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R85">85</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R86">86</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R87">87</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R88">88</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R89">89</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R90">90</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R91">91</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R92">92</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R93">93</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R94">94</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R95">95</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R96">96</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R97">97</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R98">98</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R99">99</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R100">100</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R101">101</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R102">102</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R103">103</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R104">104</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R105">105</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R106">106</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R107">107</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R108">108</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R109">109</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R110">110</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R111">111</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R112">112</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R113">113</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R114">114</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R115">115</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R116">116</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R117">117</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R118">118</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R119">119</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R120">120</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R121">121</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R122">122</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R123">123</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R124">124</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R125">125</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R126">126</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R127">127</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R128">128</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R129">129</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-01cc63cf50c26ac785f415224f6e39d2R130">130</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,130 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20170415 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170415 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +column_create Logs_20170415 n_likes COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170416 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170416 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +column_create Logs_20170416 n_likes COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "n_likes": 2, "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "n_likes": 1, "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "n_likes": 2, "price": 200} +] +[[0,0.0,0.0],3] +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "n_likes": 1, "price": 200}, +{"timestamp": "2017/04/16 11:00:00", "n_likes": 2, "price": 300}, +{"timestamp": "2017/04/16 11:00:00", "n_likes": 1, "price": 300} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --columns[sum].stage initial --columns[sum].type UInt32 --columns[sum].flags COLUMN_SCALAR --columns[sum].value 'window_sum(price)' --columns[sum].window.group_keys n_likes --output_columns price,sum +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "price", + "UInt32" + ], + [ + "sum", + "UInt32" + ] + ], + [ + 100, + 300 + ], + [ + 100, + 100 + ], + [ + 200, + 300 + ], + [ + 200, + 500 + ], + [ + 300, + 300 + ], + [ + 300, + 500 + ] + ] + ] +] +logical_select Logs --shard_key timestamp --columns[sum].stage initial --columns[sum].type UInt32 --columns[sum].flags COLUMN_SCALAR --columns[sum].value 'window_sum(price)' --columns[sum].window.group_keys price --output_columns price,sum +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "price", + "UInt32" + ], + [ + "sum", + "UInt32" + ] + ], + [ + 100, + 200 + ], + [ + 100, + 200 + ], + [ + 200, + 200 + ], + [ + 200, + 200 + ], + [ + 300, + 600 + ], + [ + 300, + 600 + ] + ] + ] +] </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/sharding/logical_select/cache/columns/window/group_keys.test (+45 -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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739">...</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/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739">...</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R1">1</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R2">2</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R3">3</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R4">4</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R5">5</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R6">6</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R7">7</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R8">8</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R9">9</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R10">10</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R11">11</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R12">12</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R13">13</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R14">14</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R15">15</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R16">16</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R17">17</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R18">18</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R19">19</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R20">20</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R21">21</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R22">22</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R23">23</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R24">24</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R25">25</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R26">26</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R27">27</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R28">28</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R29">29</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R30">30</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R31">31</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R32">32</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R33">33</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R34">34</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R35">35</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R36">36</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R37">37</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R38">38</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R39">39</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R40">40</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R41">41</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R42">42</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R43">43</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R44">44</a> <a href="https://github.com/groonga/groonga/commit/ff8a3217640e8ba09dfbc6401bade8cfdfb9dd0e#diff-7b3efffe727a12d924bf8fd44b5d5739R45">45</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,45 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Logs_20170415 TABLE_NO_KEY +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +column_create Logs_20170415 price COLUMN_SCALAR UInt32 +column_create Logs_20170415 n_likes COLUMN_SCALAR UInt32 + +table_create Logs_20170416 TABLE_NO_KEY +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +column_create Logs_20170416 price COLUMN_SCALAR UInt32 +column_create Logs_20170416 n_likes COLUMN_SCALAR UInt32 + +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "n_likes": 2, "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "n_likes": 1, "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "n_likes": 2, "price": 200} +] + +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "n_likes": 1, "price": 200}, +{"timestamp": "2017/04/16 11:00:00", "n_likes": 2, "price": 300}, +{"timestamp": "2017/04/16 11:00:00", "n_likes": 1, "price": 300} +] + +logical_select Logs \ + --shard_key timestamp \ + --columns[sum].stage initial \ + --columns[sum].type UInt32 \ + --columns[sum].flags COLUMN_SCALAR \ + --columns[sum].value 'window_sum(price)' \ + --columns[sum].window.group_keys n_likes \ + --output_columns price,sum + +logical_select Logs \ + --shard_key timestamp \ + --columns[sum].stage initial \ + --columns[sum].type UInt32 \ + --columns[sum].flags COLUMN_SCALAR \ + --columns[sum].value 'window_sum(price)' \ + --columns[sum].window.group_keys price \ + --output_columns price,sum </pre> </td> </tr> </tbody> </table> </div> </body> </html>