<!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 18:10:38 +0900 (Thu, 20 Apr 2017)</dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt> <dd style="margin-left: 8.5em"><a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5">0ac9c62998ecbe62603f6ac9373245e33b9540a5</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/77f58a6">77f58a6</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/673">#673</a> from kenhys/test-no-hit-dynamic-columns-with-drilldowns-label-filter</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 no hit dynamic columns with drilldowns[LABEL].filter without error This test case checks whether drilldowns[LABEL].filter with empty records of dynamic columns (price_with_tax) in initial stage doesn't cause an error.</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/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01">test/command/suite/sharding/logical_select/drilldowns/columns/stage/initial/no_hit/drilldowns/filter.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39">test/command/suite/sharding/logical_select/drilldowns/columns/stage/initial/no_hit/drilldowns/filter.test</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: test/command/suite/sharding/logical_select/drilldowns/columns/stage/initial/no_hit/drilldowns/filter.expected (+98 -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/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01">...</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/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01">...</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R1">1</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R2">2</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R3">3</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R4">4</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R5">5</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R6">6</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R7">7</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R8">8</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R9">9</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R10">10</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R11">11</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R12">12</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R13">13</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R14">14</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R15">15</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R16">16</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R17">17</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R18">18</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R19">19</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R20">20</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R21">21</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R22">22</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R23">23</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R24">24</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R25">25</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R26">26</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R27">27</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R28">28</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R29">29</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R30">30</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R31">31</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R32">32</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R33">33</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R34">34</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R35">35</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R36">36</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R37">37</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R38">38</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R39">39</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R40">40</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R41">41</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R42">42</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R43">43</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R44">44</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R45">45</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R46">46</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R47">47</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R48">48</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R49">49</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R50">50</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R51">51</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R52">52</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R53">53</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R54">54</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R55">55</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R56">56</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R57">57</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R58">58</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R59">59</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R60">60</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R61">61</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R62">62</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R63">63</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R64">64</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R65">65</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R66">66</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R67">67</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R68">68</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R69">69</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R70">70</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R71">71</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R72">72</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R73">73</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R74">74</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R75">75</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R76">76</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R77">77</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R78">78</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R79">79</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R80">80</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R81">81</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R82">82</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R83">83</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R84">84</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R85">85</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R86">86</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R87">87</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R88">88</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R89">89</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R90">90</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R91">91</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R92">92</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R93">93</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R94">94</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R95">95</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R96">96</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R97">97</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-f1ec34dcac8a25bcff827389554cec01R98">98</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,98 @@ +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_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 items COLUMN_VECTOR Items +[[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 items COLUMN_VECTOR Items +[[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 items COLUMN_VECTOR Items +[[0,0.0,0.0],true] +load --table Items +[ +{"_key": "Book", "price": 1000}, +{"_key": "Note", "price": 1000}, +{"_key": "Box", "price": 500}, +{"_key": "Pen", "price": 500}, +{"_key": "Food", "price": 500}, +{"_key": "Drink", "price": 300} +] +[[0,0.0,0.0],6] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "items": ["Book", "Note", "Box", "Pen"]}, +{"timestamp": "2017/03/15 01:00:00", "items": ["Food", "Drink", "Pen"]} +] +[[0,0.0,0.0],2] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "items": ["Pen", "Note", "Food", "Drink"]}, +{"timestamp": "2017/03/16 11:00:00", "items": ["Note", "Box"]} +] +[[0,0.0,0.0],2] +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "items": ["Food", "Book"]}, +{"timestamp": "2017/03/17 20:00:00", "items": ["Drink", "Note"]} +] +[[0,0.0,0.0],2] +logical_select Logs --shard_key timestamp --output_columns _id --limit 0 --min "2017/04/01 00:00:00" --drilldowns[item].keys items --drilldowns[item].sort_keys price --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax --drilldowns[item].columns[price_with_tax].stage initial --drilldowns[item].columns[price_with_tax].type UInt32 --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR --drilldowns[item].columns[price_with_tax].value 'price * 1.08' --drilldowns[item].filter "price_with_tax > 0" +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 0 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "item": [ + [ + 0 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "price", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ] + ] + ] + } + ] +] </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/drilldowns/columns/stage/initial/no_hit/drilldowns/filter.test (+60 -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/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39">...</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/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39">...</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R1">1</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R2">2</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R3">3</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R4">4</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R5">5</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R6">6</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R7">7</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R8">8</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R9">9</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R10">10</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R11">11</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R12">12</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R13">13</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R14">14</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R15">15</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R16">16</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R17">17</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R18">18</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R19">19</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R20">20</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R21">21</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R22">22</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R23">23</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R24">24</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R25">25</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R26">26</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R27">27</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R28">28</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R29">29</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R30">30</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R31">31</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R32">32</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R33">33</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R34">34</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R35">35</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R36">36</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R37">37</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R38">38</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R39">39</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R40">40</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R41">41</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R42">42</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R43">43</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R44">44</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R45">45</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R46">46</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R47">47</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R48">48</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R49">49</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R50">50</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R51">51</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R52">52</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R53">53</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R54">54</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R55">55</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R56">56</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R57">57</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R58">58</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R59">59</a> <a href="https://github.com/groonga/groonga/commit/0ac9c62998ecbe62603f6ac9373245e33b9540a5#diff-8986dc193e7301300ae214ed3d0bca39R60">60</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,60 @@ +#@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_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 items COLUMN_VECTOR Items + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 items COLUMN_VECTOR Items + +table_create Logs_20170317 TABLE_NO_KEY +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +column_create Logs_20170317 items COLUMN_VECTOR Items + +load --table Items +[ +{"_key": "Book", "price": 1000}, +{"_key": "Note", "price": 1000}, +{"_key": "Box", "price": 500}, +{"_key": "Pen", "price": 500}, +{"_key": "Food", "price": 500}, +{"_key": "Drink", "price": 300} +] + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "items": ["Book", "Note", "Box", "Pen"]}, +{"timestamp": "2017/03/15 01:00:00", "items": ["Food", "Drink", "Pen"]} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "items": ["Pen", "Note", "Food", "Drink"]}, +{"timestamp": "2017/03/16 11:00:00", "items": ["Note", "Box"]} +] + +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "items": ["Food", "Book"]}, +{"timestamp": "2017/03/17 20:00:00", "items": ["Drink", "Note"]} +] + +logical_select Logs \ + --shard_key timestamp \ + --output_columns _id \ + --limit 0 \ + --min "2017/04/01 00:00:00" \ + --drilldowns[item].keys items \ + --drilldowns[item].sort_keys price \ + --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax \ + --drilldowns[item].columns[price_with_tax].stage initial \ + --drilldowns[item].columns[price_with_tax].type UInt32 \ + --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR \ + --drilldowns[item].columns[price_with_tax].value 'price * 1.08' \ + --drilldowns[item].filter "price_with_tax > 0" </pre> </td> </tr> </tbody> </table> </div> </body> </html>