<!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">Kouhei Sutou <kou****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2016-04-19 23:40:36 +0900 (Tue, 19 Apr 2016)</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8">d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8</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">mysql57 test: set default value for timestamp explicitly
Because MySQL 5.7 enables NO_ZERO_DATE by default. It disables DEFAULT 0.</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90">mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/desc.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3">mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/desc.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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/desc.result (+2 -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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L3">3</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L4">4</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L5">5</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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90L8">8</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R3">3</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-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R4">4</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-567089d8c779014a86b7262c6d365d90R8">8</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">@@ -1,8 +1,8 @@</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> DROP TABLE IF EXISTS ranges;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE ranges (</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id int PRIMARY KEY,</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-start timestamp,</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-end timestamp,</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+start timestamp<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000"> DEFAULT CURRENT_TIMESTAMP</span>,</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+end timestamp<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000"> DEFAULT CURRENT_TIMESTAMP</span>,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> UNIQUE KEY range_key(start, end)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> );</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO ranges VALUES (1, "2012-10-25 16:18:29", "2038-01-18 15:14:07");</span>
</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/desc.test (+3 -3)</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L1">1</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L2">2</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L5">5</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L23">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L24">24</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L26">26</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L27">27</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L28">28</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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3L31">31</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R1">1</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R3">3</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R5">5</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R23">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R24">24</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R26">26</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-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R27">27</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/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8#diff-5e85b09eac134f045e5ab52e17d74dc3R31">31</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">@@ -1,5 +1,5 @@</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # Copyright(C) 2012 Kentoku SHIBA</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-# Copyright(C) 2012 Kouhei Sutou <kou****@clear*****></span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+# Copyright(C) 2012<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">-2016</span> Kouhei Sutou <kou****@clear*****></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> #</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # This library is free software; you can redistribute it and/or</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # modify it under the terms of the GNU Lesser General Public</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -24,8 +24,8 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">DROP TABLE IF EXISTS ranges;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE ranges (</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id int PRIMARY KEY,</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">- start timestamp,</span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">- end timestamp,</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+ start timestamp<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000"> DEFAULT CURRENT_TIMESTAMP</span>,</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+ end timestamp<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000"> DEFAULT CURRENT_TIMESTAMP</span>,</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> UNIQUE KEY range_key(start, end)</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>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>