<!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 17:33:41 +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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6">4bbbc2aa83c7293012196d4bed823f3237ab4ef6</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/1d76bfd">1d76bfd</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/662">#662</a> from kenhys/test-cache-drilldowns-columns-window-sort-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 drilldowns[LABEL].columns[NAME].window.sort_keys test case without cache When the value of --drilldowns[LABEL].columns[NAME].window.sort_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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1d">test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/sort_keys.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61ab">test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/sort_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/drilldowns/columns/window/sort_keys.expected (+153 -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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1d">...</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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1d">...</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR1">1</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR2">2</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR3">3</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR4">4</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR5">5</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR6">6</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR7">7</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR8">8</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR9">9</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR10">10</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR11">11</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR12">12</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR13">13</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR14">14</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR15">15</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR16">16</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR17">17</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR18">18</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR19">19</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR20">20</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR21">21</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR22">22</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR23">23</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR24">24</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR25">25</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR26">26</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR27">27</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR28">28</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR29">29</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR30">30</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR31">31</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR32">32</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR33">33</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR34">34</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR35">35</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR36">36</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR37">37</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR38">38</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR39">39</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR40">40</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR41">41</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR42">42</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR43">43</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR44">44</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR45">45</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR46">46</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR47">47</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR48">48</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR49">49</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR50">50</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR51">51</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR52">52</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR53">53</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR54">54</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR55">55</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR56">56</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR57">57</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR58">58</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR59">59</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR60">60</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR61">61</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR62">62</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR63">63</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR64">64</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR65">65</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR66">66</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR67">67</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR68">68</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR69">69</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR70">70</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR71">71</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR72">72</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR73">73</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR74">74</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR75">75</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR76">76</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR77">77</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR78">78</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR79">79</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR80">80</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR81">81</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR82">82</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR83">83</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR84">84</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR85">85</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR86">86</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR87">87</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR88">88</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR89">89</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR90">90</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR91">91</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR92">92</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR93">93</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR94">94</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR95">95</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR96">96</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR97">97</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR98">98</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR99">99</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR100">100</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR101">101</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR102">102</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR103">103</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR104">104</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR105">105</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR106">106</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR107">107</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR108">108</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR109">109</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR110">110</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR111">111</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR112">112</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR113">113</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR114">114</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR115">115</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR116">116</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR117">117</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR118">118</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR119">119</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR120">120</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR121">121</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR122">122</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR123">123</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR124">124</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR125">125</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR126">126</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR127">127</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR128">128</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR129">129</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR130">130</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR131">131</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR132">132</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR133">133</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR134">134</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR135">135</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR136">136</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR137">137</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR138">138</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR139">139</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR140">140</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR141">141</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR142">142</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR143">143</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR144">144</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR145">145</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR146">146</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR147">147</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR148">148</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR149">149</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR150">150</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR151">151</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR152">152</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-f917c3a28b3a239b5e822a64e39fbd1dR153">153</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,153 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Items TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Items price COLUMN_SCALAR UInt32 +[[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 item COLUMN_SCALAR Items +[[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 item COLUMN_SCALAR Items +[[0,0.0,0.0],true] +load --table Items +[ +{"_key": "item1", "price": 100}, +{"_key": "item2", "price": 200} +] +[[0,0.0,0.0],2] +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "item": "item1"}, +{"timestamp": "2017/04/15 01:00:00", "item": "item2"} +] +[[0,0.0,0.0],2] +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "item": "item2"}, +{"timestamp": "2017/04/16 11:00:00", "item": "item1"}, +{"timestamp": "2017/04/16 12:00:00", "item": "item1"} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --limit 0 --output_columns _id --drilldowns[group].keys item --drilldowns[group].columns[number].stage initial --drilldowns[group].columns[number].type UInt32 --drilldowns[group].columns[number].flags COLUMN_SCALAR --drilldowns[group].columns[number].value 'window_sum(price)' --drilldowns[group].columns[number].window.sort_keys _key --drilldowns[group].output_columns _key,_nsubrecs,price,number +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "group": [ + [ + 2 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "price", + "UInt32" + ], + [ + "number", + "UInt32" + ] + ], + [ + "item1", + 3, + 100, + 100 + ], + [ + "item2", + 2, + 200, + 300 + ] + ] + } + ] +] +logical_select Logs --shard_key timestamp --limit 0 --output_columns _id --drilldowns[group].keys item --drilldowns[group].columns[number].stage initial --drilldowns[group].columns[number].type UInt32 --drilldowns[group].columns[number].flags COLUMN_SCALAR --drilldowns[group].columns[number].value 'window_sum(price)' --drilldowns[group].columns[number].window.sort_keys _nsubrecs --drilldowns[group].output_columns _key,_nsubrecs,price,number +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "group": [ + [ + 2 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "price", + "UInt32" + ], + [ + "number", + "UInt32" + ] + ], + [ + "item1", + 3, + 100, + 300 + ], + [ + "item2", + 2, + 200, + 200 + ] + ] + } + ] +] </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/drilldowns/columns/window/sort_keys.test (+58 -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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61ab">...</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/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61ab">...</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR1">1</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR2">2</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR3">3</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR4">4</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR5">5</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR6">6</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR7">7</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR8">8</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR9">9</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR10">10</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR11">11</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR12">12</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR13">13</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR14">14</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR15">15</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR16">16</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR17">17</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR18">18</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR19">19</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR20">20</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR21">21</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR22">22</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR23">23</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR24">24</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR25">25</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR26">26</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR27">27</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR28">28</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR29">29</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR30">30</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR31">31</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR32">32</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR33">33</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR34">34</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR35">35</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR36">36</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR37">37</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR38">38</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR39">39</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR40">40</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR41">41</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR42">42</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR43">43</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR44">44</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR45">45</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR46">46</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR47">47</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR48">48</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR49">49</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR50">50</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR51">51</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR52">52</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR53">53</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR54">54</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR55">55</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR56">56</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR57">57</a> <a href="https://github.com/groonga/groonga/commit/4bbbc2aa83c7293012196d4bed823f3237ab4ef6#diff-e04e5d8556fa6f69c6c73a96d9df61abR58">58</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,58 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Items TABLE_HASH_KEY ShortText +column_create Items price COLUMN_SCALAR UInt32 + +table_create Logs_20170415 TABLE_NO_KEY +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +column_create Logs_20170415 item COLUMN_SCALAR Items + +table_create Logs_20170416 TABLE_NO_KEY +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +column_create Logs_20170416 item COLUMN_SCALAR Items + +load --table Items +[ +{"_key": "item1", "price": 100}, +{"_key": "item2", "price": 200} +] + +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "item": "item1"}, +{"timestamp": "2017/04/15 01:00:00", "item": "item2"} +] + +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "item": "item2"}, +{"timestamp": "2017/04/16 11:00:00", "item": "item1"}, +{"timestamp": "2017/04/16 12:00:00", "item": "item1"} +] + + +logical_select Logs \ + --shard_key timestamp \ + --limit 0 \ + --output_columns _id \ + --drilldowns[group].keys item \ + --drilldowns[group].columns[number].stage initial \ + --drilldowns[group].columns[number].type UInt32 \ + --drilldowns[group].columns[number].flags COLUMN_SCALAR \ + --drilldowns[group].columns[number].value 'window_sum(price)' \ + --drilldowns[group].columns[number].window.sort_keys _key \ + --drilldowns[group].output_columns _key,_nsubrecs,price,number + +logical_select Logs \ + --shard_key timestamp \ + --limit 0 \ + --output_columns _id \ + --drilldowns[group].keys item \ + --drilldowns[group].columns[number].stage initial \ + --drilldowns[group].columns[number].type UInt32 \ + --drilldowns[group].columns[number].flags COLUMN_SCALAR \ + --drilldowns[group].columns[number].value 'window_sum(price)' \ + --drilldowns[group].columns[number].window.sort_keys _nsubrecs \ + --drilldowns[group].output_columns _key,_nsubrecs,price,number </pre> </td> </tr> </tbody> </table> </div> </body> </html>