<!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-05-01 17:26:06 +0900 (Mon, 01 May 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/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25">3c55c6eeb2940bf4a15c4ba709a2acc548526d25</a></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">doc: update limitations about column
ref. https://gitter.im/groonga/ja?at=<a href="https://github.com/mroonga/mroonga/commit/58c0aa797ceae5376a8ed71e">58c0aa797ceae5376a8ed71e</a>
Reported by <a href="https://github.com/bignum">@bignum</a>_twitter. Thanks!!!</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4">doc/source/reference/limitations.rst</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: doc/source/reference/limitations.rst (+13 -2)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L38">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L41">41</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L42">42</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L43">43</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L44">44</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L46">46</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L47">47</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L50">50</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4L53">53</a></span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R38">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R41">41</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R43">43</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R44">44</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R45">45</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R46">46</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R47">47</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R54">54</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R55">55</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R56">56</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R57">57</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R58">58</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R59">59</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R60">60</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R63">63</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/3c55c6eeb2940bf4a15c4ba709a2acc548526d25#diff-91f9bc05684c007153cabb14004047d4R64">64</a></span>
</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -39,15 +39,26 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">Confirm by ``SHOW TABLE STATUS`` or ``SHOW INDEX FROM ...`` whether your table d</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Limitations about the value of columns</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --------------------------------------</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-There is a limitation about <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">DATE,</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">DATETIME</span> column in storage mode.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+There is a limitation about <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">the</span> <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">value of</span> column in storage mode.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-mroonga storage engine automatically convert 0 into 1 as the value of month or date.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+Mroonga storage engine executes automatic conversion against the value NULL.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+For example, if the value NULL is used in ``DATE`` or ``DATETIME``</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+columns, Mroonga storage engine automatically converts 0 into 1 as the</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+value of month or date.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Thus, the value 0 is treated as the 1st month (January) of the year or</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> the 1st date of the month.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> And more, the value NULL is treated as the value of UNIX time 0 (1970-01-01 00:00:00).</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+This kind of automatic conversion is not restricted to only ``DATE``</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+or ``DATETIME`` types.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+The value NULL is converted into the default value of columns. In most</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+cases, it will be converted into empty string for column which belongs</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+to type of string, 0 for column which belongs to type of numeric.</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Here is an example to show behavior described above.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. code-block:: sql</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>