<!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-17 13:11:26 +0900 (Mon, 17 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/69541cf161a036821f2fc8303fa5a82537cdf1d3">69541cf161a036821f2fc8303fa5a82537cdf1d3</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/a19bc18">a19bc18</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/663">#663</a> from kenhys/test-cache-columns-type</li> </ul> </dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">test: add columns[NAME].type test case without cache When the value of --columns[NAME].type parameter is changed, Groonga returns result without using cache.</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8">test/command/suite/sharding/logical_select/cache/columns/type.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0">test/command/suite/sharding/logical_select/cache/columns/type.test</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: test/command/suite/sharding/logical_select/cache/columns/type.expected (+99 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8">...</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/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8">...</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R1">1</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R2">2</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R3">3</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R4">4</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R5">5</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R6">6</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R7">7</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R8">8</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R9">9</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R10">10</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R11">11</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R12">12</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R13">13</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R14">14</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R15">15</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R16">16</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R17">17</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R18">18</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R19">19</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R20">20</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R21">21</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R22">22</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R23">23</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R24">24</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R25">25</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R26">26</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R27">27</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R28">28</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R29">29</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R30">30</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R31">31</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R32">32</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R33">33</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R34">34</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R35">35</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R36">36</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R37">37</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R38">38</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R39">39</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R40">40</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R41">41</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R42">42</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R43">43</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R44">44</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R45">45</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R46">46</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R47">47</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R48">48</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R49">49</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R50">50</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R51">51</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R52">52</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R53">53</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R54">54</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R55">55</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R56">56</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R57">57</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R58">58</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R59">59</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R60">60</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R61">61</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R62">62</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R63">63</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R64">64</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R65">65</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R66">66</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R67">67</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R68">68</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R69">69</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R70">70</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R71">71</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R72">72</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R73">73</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R74">74</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R75">75</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R76">76</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R77">77</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R78">78</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R79">79</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R80">80</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R81">81</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R82">82</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R83">83</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R84">84</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R85">85</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R86">86</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R87">87</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R88">88</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R89">89</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R90">90</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R91">91</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R92">92</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R93">93</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R94">94</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R95">95</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R96">96</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R97">97</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R98">98</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-d13d9387df1c1d20e81dac246b3088c8R99">99</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,99 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20170415 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170415 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170416 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170416 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "price": 1000}, +{"timestamp": "2017/04/15 01:00:00", "price": 900} +] +[[0,0.0,0.0],2] +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "price": 520}, +{"timestamp": "2017/04/16 11:00:00", "price": 510}, +{"timestamp": "2017/04/16 12:00:00", "price": 500} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --columns[price_with_tax].stage initial --columns[price_with_tax].type UInt32 --columns[price_with_tax].flags COLUMN_SCALAR --columns[price_with_tax].value 'price * 1.08' --output_columns price_with_tax +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "price_with_tax", + "UInt32" + ] + ], + [ + 1080 + ], + [ + 972 + ], + [ + 561 + ], + [ + 550 + ], + [ + 540 + ] + ] + ] +] +logical_select Logs --shard_key timestamp --columns[price_with_tax].stage initial --columns[price_with_tax].type ShortText --columns[price_with_tax].flags COLUMN_SCALAR --columns[price_with_tax].value 'price * 1.08' --output_columns price_with_tax +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "price_with_tax", + "ShortText" + ] + ], + [ + "1080.0" + ], + [ + "972.0000000000001" + ], + [ + "561.6" + ], + [ + "550.8000000000001" + ], + [ + "540.0" + ] + ] + ] +] </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: test/command/suite/sharding/logical_select/cache/columns/type.test (+40 -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/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0">...</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/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0">...</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R1">1</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R2">2</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R3">3</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R4">4</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R5">5</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R6">6</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R7">7</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R8">8</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R9">9</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R10">10</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R11">11</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R12">12</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R13">13</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R14">14</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R15">15</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R16">16</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R17">17</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R18">18</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R19">19</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R20">20</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R21">21</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R22">22</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R23">23</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R24">24</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R25">25</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R26">26</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R27">27</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R28">28</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R29">29</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R30">30</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R31">31</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R32">32</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R33">33</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R34">34</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R35">35</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R36">36</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R37">37</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R38">38</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R39">39</a> <a href="https://github.com/groonga/groonga/commit/69541cf161a036821f2fc8303fa5a82537cdf1d3#diff-583fe03b2319c97cc1ee98c31c3f63a0R40">40</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,40 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Logs_20170415 TABLE_NO_KEY +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +column_create Logs_20170415 price COLUMN_SCALAR UInt32 + +table_create Logs_20170416 TABLE_NO_KEY +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +column_create Logs_20170416 price COLUMN_SCALAR UInt32 + +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "price": 1000}, +{"timestamp": "2017/04/15 01:00:00", "price": 900} +] + +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "price": 520}, +{"timestamp": "2017/04/16 11:00:00", "price": 510}, +{"timestamp": "2017/04/16 12:00:00", "price": 500} +] + +logical_select Logs \ + --shard_key timestamp \ + --columns[price_with_tax].stage initial \ + --columns[price_with_tax].type UInt32 \ + --columns[price_with_tax].flags COLUMN_SCALAR \ + --columns[price_with_tax].value 'price * 1.08' \ + --output_columns price_with_tax + +logical_select Logs \ + --shard_key timestamp \ + --columns[price_with_tax].stage initial \ + --columns[price_with_tax].type ShortText \ + --columns[price_with_tax].flags COLUMN_SCALAR \ + --columns[price_with_tax].value 'price * 1.08' \ + --output_columns price_with_tax </pre> </td> </tr> </tbody> </table> </div> </body> </html>