<!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">2011-06-18 18:29:52 +0900 (Sat, 18 Jun 2011)</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d">bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d</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">[wrapper][fulltext] support fulltext score. refs #1003
But order by doesn't work yet.</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#diff-0">ha_mroonga.cc</a></li>
<li><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#diff-1">test/sql/r/fulltext_wrapper.result</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: ha_mroonga.cc (+12 -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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L835">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L836">836</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L837">837</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L838">838</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L839">839</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-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-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-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-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-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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L840">840</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L841">841</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0L842">842</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R835">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R836">836</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R837">837</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R838">838</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R839">839</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R840">840</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R841">841</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R842">842</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R843">843</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R844">844</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R845">845</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R846">846</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R847">847</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R848">848</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R849">849</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R850">850</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R851">851</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R852">852</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L0R853">853</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">@@ -836,7 +836,18 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">static float mrn_wrapper_ft_find_relevance(FT_INFO *handler, uchar *record,</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"> MRN_DBUG_ENTER_FUNCTION();</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> st_mrn_ft_info *info = (st_mrn_ft_info *)handler;</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- DBUG_RETURN((float)-1.0);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ grn_obj *score_column;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ score_column = grn_obj_column(info->ctx, info->result,</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ MRN_SCORE_COL_NAME, strlen(MRN_SCORE_COL_NAME));</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ grn_obj score_value;</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ GRN_INT32_INIT(&score_value, 0);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ grn_obj_get_value(info->ctx, score_column, info->record_id, &score_value);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ float score = (float)GRN_INT32_VALUE(&score_value);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ grn_obj_unlink(info->ctx, &score_value);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ grn_obj_unlink(info->ctx, score_column);</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ DBUG_RETURN(score);</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>
<span class="diff-not-changed" style="display: block; white-space: pre"> static void mrn_wrapper_ft_close_search(FT_INFO *handler)</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/r/fulltext_wrapper.result (+6 -6)</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L123">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L124">124</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L125">125</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L126">126</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L127">127</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L128">128</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L129">129</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-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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L130">130</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L131">131</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L132">132</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L133">133</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L134">134</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-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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L135">135</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L136">136</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1L137">137</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R123">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R124">124</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R125">125</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R126">126</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-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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R127">127</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R128">128</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R129">129</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R130">130</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R131">131</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-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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R132">132</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R133">133</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/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R134">134</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R135">135</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R136">136</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga/commit/bde46c1bbe73c9833b32f4bcf9aa0b3ff2e15e9d#L1R137">137</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">@@ -124,14 +124,14 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">c1 c2 match(c2) against("ii")</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3 aa ii ii ii oo 3</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> c1 c2 match(c2) against("ii")</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-1 aa ii uu ee oo -1</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-3 aa ii ii ii oo -1</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-5 ta ti ii ii to -1</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+1 aa ii uu ee oo 1</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+3 aa ii ii ii oo 3</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+5 ta ti ii ii to 2</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> c1 c2 match(c2) against("ii")</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-1 aa ii uu ee oo -1</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-3 aa ii ii ii oo -1</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-5 ta ti ii ii to -1</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+1 aa ii uu ee oo 1</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+3 aa ii ii ii oo 3</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+5 ta ti ii ii to 2</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> drop table t1,t2;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3)) COMMENT = 'engine "innodb"';</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> insert into t1 values(1,10,"aa ii uu ee oo");</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>