<!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-03-28 11:41:37 +0900 (Wed, 28 Mar 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/2f961f93e42fc31b223cd9340e7bd41397762f6d">2f961f93e42fc31b223cd9340e7bd41397762f6d</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: split a SQLs block to logical blocks</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#diff-0">test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.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/t/optimization_skip_count_multithread.test (+5 -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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L28">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L31">31</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L36">36</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L37">37</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L39">39</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L41">41</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L44">44</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L46">46</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L47">47</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0L50">50</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R28">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R31">31</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R37">37</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R41">41</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R46">46</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R47">47</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R51">51</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/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R54">54</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d#L0R55">55</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">@@ -29,22 +29,27 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE TABLE t1 (</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> KEY idx1(c2),</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> FULLTEXT INDEX ft(c3)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> );</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(1,10,"aa ii uu ee oo");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(2,20,"ka ki ku ke ko");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(3,30,"sa si su se so");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(4,40,"ta ti tu te to");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(5,50,"aa ii uu ee oo");</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHOW STATUS LIKE 'mroonga_count_skip';</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHOW STATUS LIKE 'mroonga_count_skip';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CONNECT (thread2, localhost, root,,);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CONNECTION thread2;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO t1 VALUES(6,60,"");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> DISCONNECT thread2;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CONNECTION default;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHOW STATUS LIKE 'mroonga_count_skip';</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SHOW STATUS LIKE 'mroonga_count_skip';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</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-not-changed" style="display: block; white-space: pre"> --source include/have_mroonga_deinit.inc</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>