<!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">2012-10-23 22:09:11 +0900 (Tue, 23 Oct 2012)</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/77846f650873c12b128cbb11dffb003c862c6bc7">77846f650873c12b128cbb11dffb003c862c6bc7</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Log</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">test: add ORDER BY to make resultset stable</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/77846f650873c12b128cbb11dffb003c862c6bc7#diff-0">test/sql/suite/mroonga/storage/geometry/r/contains.result</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#diff-1">test/sql/suite/mroonga/storage/geometry/t/contains.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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: test/sql/suite/mroonga/storage/geometry/r/contains.result (+2 -1)</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L160">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L161">161</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L162">162</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L163">163</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L164">164</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/77846f650873c12b128cbb11dffb003c862c6bc7#L0L165">165</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L166">166</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0L167">167</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R160">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R161">161</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R162">162</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R163">163</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R164">164</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R165">165</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R166">166</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R167">167</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L0R168">168</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -161,7 +161,8 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">id        name        location_text</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 35        nishimi-ya        POINT(139.77462805555555 35.671825)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 36        hiiragi        POINT(139.71151694444444 35.64770111111111)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select id, name, AsText(location) as location_text from shops</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-where MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+where MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+order by id;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> id        name        location_text</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 14        tetsuji        POINT(139.76857 35.680911944444446)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 19        daruma        POINT(139.7705988888889 35.68146111111111)</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: test/sql/suite/mroonga/storage/geometry/t/contains.test (+2 -1)</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L137">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L138">138</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L139">139</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L140">140</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L141">141</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/77846f650873c12b128cbb11dffb003c862c6bc7#L1L142">142</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L143">143</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1L144">144</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R137">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R138">138</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R139">139</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R140">140</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R141">141</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R142">142</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R143">143</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R144">144</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7#L1R145">145</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -138,7 +138,8 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">insert into shops (name, location)</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> GeomFromText('POINT(139.711517 35.647701)'));</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select id, name, AsText(location) as location_text from shops;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select id, name, AsText(location) as location_text from shops</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- where MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ where MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ order by id;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table shops;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --source include/have_mroonga_deinit.inc</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>