<!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">Yasuhiro Horimoto <horim****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2018-02-19 16:14:30 +0900 (Mon, 19 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/3c272cd5ad538191b0550a0b51dec3ac752e0432">3c272cd5ad538191b0550a0b51dec3ac752e0432</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/36174b1">36174b1</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/824">#824</a> from komainu8/add_post_filter_in_logical_select</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">logical_select test: add test for post_filter</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3">test/command/suite/sharding/logical_select/post_filter/filtered_column.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bb">test/command/suite/sharding/logical_select/post_filter/filtered_column.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfe">test/command/suite/sharding/logical_select/post_filter/no_filter.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670c">test/command/suite/sharding/logical_select/post_filter/no_filter.test</a></li> <li><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4">test/command/suite/sharding/logical_select/post_filter/no_filtered_column.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7">test/command/suite/sharding/logical_select/post_filter/no_filtered_column.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/post_filter/filtered_column.expected (+97 -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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R52">52</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R53">53</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R54">54</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R55">55</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R56">56</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R57">57</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R58">58</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R59">59</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R60">60</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R61">61</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R62">62</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R63">63</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R64">64</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R65">65</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R66">66</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R67">67</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R68">68</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R69">69</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R70">70</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R71">71</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R72">72</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R73">73</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R74">74</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R75">75</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R76">76</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R77">77</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R78">78</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R79">79</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R80">80</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R81">81</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R82">82</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R83">83</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R84">84</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R85">85</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R86">86</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R87">87</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R88">88</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R89">89</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R90">90</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R91">91</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R92">92</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R93">93</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R94">94</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R95">95</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R96">96</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-b3ce41aedfb81fea3278884e081438c3R97">97</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,97 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20170315 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170315 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170316 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170316 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170317 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170317 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] +[[0,0.0,0.0],3] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] +[[0,0.0,0.0],3] +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] +[[0,0.0,0.0],3] +table_create Times TABLE_PAT_KEY Time +[[0,0.0,0.0],true] +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp +[[0,0.0,0.0],true] +log_level --level debug +[[0,0.0,0.0],true] +logical_select Logs --shard_key timestamp --columns[filtered_id].stage filtered --columns[filtered_id].type UInt32 --columns[filtered_id].flags COLUMN_SCALAR --columns[filtered_id].value '_id' --filter 'price <= 900' --post_filter 'filtered_id > 1' --offset 1 --limit 3 --output_columns _id,filtered_id,price +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "filtered_id", + "UInt32" + ], + [ + "price", + "UInt32" + ] + ], + [ + 3, + 3, + 300 + ], + [ + 2, + 2, + 520 + ], + [ + 3, + 3, + 110 + ] + ] + ] +] +log_level --level notice +[[0,0.0,0.0],true] </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/post_filter/filtered_column.test (+57 -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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bb">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bb">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR52">52</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR53">53</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR54">54</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR55">55</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR56">56</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-692f6afe0a3f8079d1848f256bc0e7bbR57">57</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,57 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Logs_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 price COLUMN_SCALAR UInt32 + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 price COLUMN_SCALAR UInt32 + +table_create Logs_20170317 TABLE_NO_KEY +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +column_create Logs_20170317 price COLUMN_SCALAR UInt32 + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] + +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] + +table_create Times TABLE_PAT_KEY Time +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp + +#@add-important-log-levels debug +log_level --level debug +logical_select Logs \ + --shard_key timestamp \ + --columns[filtered_id].stage filtered \ + --columns[filtered_id].type UInt32 \ + --columns[filtered_id].flags COLUMN_SCALAR \ + --columns[filtered_id].value '_id' \ + --filter 'price <= 900' \ + --post_filter 'filtered_id > 1' \ + --offset 1 \ + --limit 3 \ + --output_columns _id,filtered_id,price +log_level --level notice +#@remove-important-log-levels debug </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/post_filter/no_filter.expected (+55 -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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfe">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfe">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR52">52</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR53">53</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR54">54</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-747819f7cc21638d5de423faee100dfeR55">55</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,55 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20170315 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170315 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170316 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170316 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170317 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170317 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] +[[0,0.0,0.0],3] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] +[[0,0.0,0.0],3] +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] +[[0,0.0,0.0],3] +table_create Times TABLE_PAT_KEY Time +[[0,0.0,0.0],true] +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp +[[0,0.0,0.0],true] +log_level --level debug +[[0,0.0,0.0],true] +logical_select Logs --shard_key timestamp --post_filter '_id < 3' --offset 4 --limit 1 --output_columns _id,price +[[0,0.0,0.0],[[[6],[["_id","UInt32"],["price","UInt32"]],[1,800]]]] +log_level --level notice +[[0,0.0,0.0],true] </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/post_filter/no_filter.test (+52 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670c">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670c">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ede0466e3d6579eabfa98f1eeb4d670cR52">52</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,52 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Logs_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 price COLUMN_SCALAR UInt32 + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 price COLUMN_SCALAR UInt32 + +table_create Logs_20170317 TABLE_NO_KEY +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +column_create Logs_20170317 price COLUMN_SCALAR UInt32 + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] + +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] + +table_create Times TABLE_PAT_KEY Time +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp + +#@add-important-log-levels debug +log_level --level debug +logical_select Logs \ + --shard_key timestamp \ + --post_filter '_id < 3' \ + --offset 4 \ + --limit 1 \ + --output_columns _id,price +log_level --level notice +#@remove-important-log-levels debug </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/post_filter/no_filtered_column.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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R52">52</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R53">53</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R54">54</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R55">55</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R56">56</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R57">57</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R58">58</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R59">59</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R60">60</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R61">61</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R62">62</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R63">63</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R64">64</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R65">65</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R66">66</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R67">67</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R68">68</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R69">69</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R70">70</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R71">71</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R72">72</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R73">73</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R74">74</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R75">75</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R76">76</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R77">77</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R78">78</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R79">79</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R80">80</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R81">81</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R82">82</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R83">83</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R84">84</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R85">85</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R86">86</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R87">87</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R88">88</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R89">89</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-ad7434707f8cec81000e5751bdb877a4R90">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 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20170315 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170315 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170316 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170316 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170317 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170317 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] +[[0,0.0,0.0],3] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] +[[0,0.0,0.0],3] +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] +[[0,0.0,0.0],3] +table_create Times TABLE_PAT_KEY Time +[[0,0.0,0.0],true] +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +[[0,0.0,0.0],true] +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp +[[0,0.0,0.0],true] +log_level --level debug +[[0,0.0,0.0],true] +logical_select Logs --shard_key timestamp --filter 'price <= 900' --post_filter '_id > 1' --offset 1 --limit 3 --output_columns _id,price +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "price", + "UInt32" + ] + ], + [ + 3, + 300 + ], + [ + 2, + 520 + ], + [ + 3, + 110 + ] + ] + ] +] +log_level --level notice +[[0,0.0,0.0],true] </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/post_filter/no_filtered_column.test (+53 -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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7">...</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/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7">...</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R1">1</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R2">2</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R3">3</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R4">4</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R5">5</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R6">6</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R7">7</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R8">8</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R9">9</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R10">10</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R11">11</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R12">12</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R13">13</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R14">14</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R15">15</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R16">16</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R17">17</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R18">18</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R19">19</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R20">20</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R21">21</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R22">22</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R23">23</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R24">24</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R25">25</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R26">26</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R27">27</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R28">28</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R29">29</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R30">30</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R31">31</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R32">32</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R33">33</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R34">34</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R35">35</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R36">36</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R37">37</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R38">38</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R39">39</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R40">40</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R41">41</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R42">42</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R43">43</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R44">44</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R45">45</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R46">46</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R47">47</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R48">48</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R49">49</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R50">50</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R51">51</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R52">52</a> <a href="https://github.com/groonga/groonga/commit/3c272cd5ad538191b0550a0b51dec3ac752e0432#diff-9c854df4a75bfd7eff69daf279e82ca7R53">53</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,53 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Logs_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 price COLUMN_SCALAR UInt32 + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 price COLUMN_SCALAR UInt32 + +table_create Logs_20170317 TABLE_NO_KEY +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +column_create Logs_20170317 price COLUMN_SCALAR UInt32 + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 1000}, +{"timestamp": "2017/03/15 01:00:00", "price": 900}, +{"timestamp": "2017/03/15 02:00:00", "price": 300} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 530}, +{"timestamp": "2017/03/16 11:00:00", "price": 520}, +{"timestamp": "2017/03/16 12:00:00", "price": 110} +] + +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "price": 800}, +{"timestamp": "2017/03/17 21:00:00", "price": 400}, +{"timestamp": "2017/03/17 22:00:00", "price": 300} +] + +table_create Times TABLE_PAT_KEY Time +column_create Times logs_20170315 COLUMN_INDEX Logs_20170315 timestamp +column_create Times logs_20170316 COLUMN_INDEX Logs_20170316 timestamp +column_create Times logs_20170317 COLUMN_INDEX Logs_20170317 timestamp + +#@add-important-log-levels debug +log_level --level debug +logical_select Logs \ + --shard_key timestamp \ + --filter 'price <= 900' \ + --post_filter '_id > 1' \ + --offset 1 \ + --limit 3 \ + --output_columns _id,price +log_level --level notice +#@remove-important-log-levels debug </pre> </td> </tr> </tbody> </table> </div> </body> </html>