<!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 22:25:51 +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/d1b204e22e460725f2cde46f93304eaef3a91a1e">d1b204e22e460725f2cde46f93304eaef3a91a1e</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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492">mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/asc.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cd">mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/asc.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/asc.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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L3">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L4">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L5">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492L8">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R3">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R4">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R7">7</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-d9f7e0ff11c8bebf29997c73fcdff492R8">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/asc.test (+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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL23">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL24">24</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL26">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL27">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL28">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdL31">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR23">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR24">24</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR26">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR27">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/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e#diff-e7d39afaedc394a4d3eedd61366ca2cdR31">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">@@ -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>