<!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-20 22:46:37 +0900 (Wed, 20 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/9a932a00edf904992fe997b8aae25b74625bd4fb">9a932a00edf904992fe997b8aae25b74625bd4fb</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: disable warnings for SQL_MODE</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820">mysql-test/mroonga/storage/update/r/virtual_column.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1e">mysql-test/mroonga/storage/update/t/virtual_column.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/update/r/virtual_column.result (+1 -0)</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820L25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820L26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820L27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820L28">28</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820R25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820R28">28</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-4b682e0aedad8ffb7107bcd383974820R29">29</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">@@ -26,3 +26,4 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">c1 _id</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 2 2</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 3</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table t1;</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+set sql_mode=DEFAULT;</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/update/t/virtual_column.test (+6 -0)</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL26">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL29">29</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL30">30</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL33">33</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL34">34</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL37">37</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL39">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL41">41</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL42">42</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eL43">43</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR26">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR29">29</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR31">31</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR35">35</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR37">37</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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR41">41</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR43">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR46">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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR47">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/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb#diff-676364ed39636ef367c0a287bb5dfb1eR49">49</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">@@ -27,11 +27,15 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">insert into t1 values(1,null);</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(2,null);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(3,null);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from t1;</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+--disable_warnings</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> set sql_mode="";</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+--enable_warnings</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # warning WARN_DATA_TRUNCATED</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> update t1 set _id = 10 where c1 = 1;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from t1;</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+--disable_warnings</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> set sql_mode="strict_all_tables";</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+--enable_warnings</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # We can't use WARN_DATA_TRUNCATED here because "WXXX" isn't supported</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # MySQL 5.5, 5.6 and MariaDB 5.6. MariaDB 10.0 only supports it.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # We share this test with all MySQL servers. So we use number here.</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -40,4 +44,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">update t1 set _id = 11 where c1 = 1;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select * from t1;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table t1;</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">+set sql_mode=DEFAULT;</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"> --source ../../../include/mroonga/have_mroonga_deinit.inc</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>