File: script_syntax.html

package info (click to toggle)
groonga 11.0.0-2
links: PTS, VCS
area: main
in suites: bullseye
size: 121,576 kB
sloc: ansic: 801,209; javascript: 62,121; ruby: 46,206; cpp: 33,790; xml: 24,951; yacc: 13,333; sh: 7,776; python: 3,266; makefile: 2,315; perl: 133
file content (2819 lines) | stat: -rw-r--r-- 135,408 bytes


<!DOCTYPE html>

<html lang="en">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>7.13.2. Script syntax &#8212; Groonga v10.1.1-31-g1e46ba6 documentation</title>
    <link rel="stylesheet" href="../../_static/groonga.css" type="text/css" />
    <link rel="stylesheet" href="../../_static/pygments.css" type="text/css" />
    
    <script id="documentation_options" data-url_root="../../" src="../../_static/documentation_options.js"></script>
    <script src="../../_static/jquery.js"></script>
    <script src="../../_static/underscore.js"></script>
    <script src="../../_static/doctools.js"></script>
    <script src="../../_static/language_data.js"></script>
    
    <link rel="shortcut icon" href="../../_static/favicon.ico"/>
    <link rel="index" title="Index" href="../../genindex.html" />
    <link rel="search" title="Search" href="../../search.html" />
    <link rel="next" title="7.14. Regular expression" href="../regular_expression.html" />
    <link rel="prev" title="7.13.1. Query syntax" href="query_syntax.html" /> 
  </head><body>
<div class="header">
  <h1 class="title">
    <a id="top-link" href="../../index.html">
      <span class="project">groonga</span>
      <span class="separator">-</span>
      <span class="description">An open-source fulltext search engine and column store.</span>
    </a>
  </h1>

  <div class="other-language-links">
    <ul>
      <li><a href="../../../../ja/html/reference/grn_expr/script_syntax.html">日本語</a></li>
    </ul>
  </div>
</div>
  

    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../../genindex.html" title="General Index"
             accesskey="I">index</a></li>
        <li class="right" >
          <a href="../regular_expression.html" title="7.14. Regular expression"
             accesskey="N">next</a> |</li>
        <li class="right" >
          <a href="query_syntax.html" title="7.13.1. Query syntax"
             accesskey="P">previous</a> |</li>
        <li class="nav-item nav-item-0"><a href="../../index.html">Groonga v10.1.1-31-g1e46ba6 documentation</a> &#187;</li>
          <li class="nav-item nav-item-1"><a href="../../reference.html" ><span class="section-number">7. </span>Reference manual</a> &#187;</li>
          <li class="nav-item nav-item-2"><a href="../grn_expr.html" accesskey="U"><span class="section-number">7.13. </span>grn_expr</a> &#187;</li>
        <li class="nav-item nav-item-this"><a href=""><span class="section-number">7.13.2. </span>Script syntax</a></li> 
      </ul>
    </div>  

    <div class="document">
      <div class="documentwrapper">
        <div class="bodywrapper">
          <div class="body" role="main">
            
  <div class="section" id="script-syntax">
<h1><span class="section-number">7.13.2. </span>Script syntax<a class="headerlink" href="#script-syntax" title="Permalink to this headline">¶</a></h1>
<p>Script syntax is a syntax to specify complex search condition. It is
similar to ECMAScript. For example, <code class="docutils literal notranslate"><span class="pre">_key</span> <span class="pre">==</span> <span class="pre">&quot;book&quot;</span></code> means that
groonga searches records that <code class="docutils literal notranslate"><span class="pre">_key</span></code> value is <code class="docutils literal notranslate"><span class="pre">&quot;book&quot;</span></code>. All values
are string in <a class="reference internal" href="query_syntax.html"><span class="doc">Query syntax</span></a> but its own type in script
syntax. For example, <code class="docutils literal notranslate"><span class="pre">&quot;book&quot;</span></code> is string, <code class="docutils literal notranslate"><span class="pre">1</span></code> is integer,
<code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> is the object whose name is <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> and so on.</p>
<p>Script syntax doesn’t support full ECMAScript syntax. For example,
script syntax doesn’t support statement such as <code class="docutils literal notranslate"><span class="pre">if</span></code> control
statement, <code class="docutils literal notranslate"><span class="pre">for</span></code> iteration statement and variable definition
statement. Function definion is not supported too. But script syntax
addes the original additional operators.  They are described after
ECMAScript syntax is described.</p>
<div class="section" id="security">
<span id="script-syntax-security"></span><h2><span class="section-number">7.13.2.1. </span>Security<a class="headerlink" href="#security" title="Permalink to this headline">¶</a></h2>
<p>For security reason, you should not pass an input from users to
Groonga directly. If there is an evil user, the user may input a query
that retrieves records that should not be shown to the user.</p>
<p>Think about the following case.</p>
<p>A Groonga application constructs a Groonga request by the following
program:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>filter = &quot;column @ \&quot;#{user_input}\&quot;&quot;
select_options = {
  # ...
  :filter =&gt; filter,
}
groonga_client.select(select_options)
</pre></div>
</div>
<p><code class="docutils literal notranslate"><span class="pre">user_input</span></code> is an input from user. If the input is <code class="docutils literal notranslate"><span class="pre">query</span></code>,
here is the constructed <a class="reference internal" href="../commands/select.html#select-filter"><span class="std std-ref">filter</span></a> parameter:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column @ &quot;query&quot;
</pre></div>
</div>
<p>If the input is <code class="docutils literal notranslate"><span class="pre">x&quot;</span> <span class="pre">||</span> <span class="pre">true</span> <span class="pre">||</span> <span class="pre">&quot;</span></code>, here is the constructed
<a class="reference internal" href="../commands/select.html#select-filter"><span class="std std-ref">filter</span></a> parameter:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column @ &quot;x&quot; || true || &quot;&quot;
</pre></div>
</div>
<p>This query matches to all records. The user will get all records from
your database. The user may be evil.</p>
<p>It’s better that you just receive an user input as a value. It means
that you don’t accept that user input can contain operator such as
<code class="docutils literal notranslate"><span class="pre">&#64;</span></code> and <code class="docutils literal notranslate"><span class="pre">&amp;&amp;</span></code>. If you accept operator, user can create evil query.</p>
<p>If user input has only value, you blocks evil query by escaping user
input value. Here is a list how to escape user input value:</p>
<blockquote>
<div><ul class="simple">
<li><p>True value: Convert it to <code class="docutils literal notranslate"><span class="pre">true</span></code>.</p></li>
<li><p>False value: Convert it to <code class="docutils literal notranslate"><span class="pre">false</span></code>.</p></li>
<li><p>Numerical value: Convert it to <a class="reference internal" href="#script-syntax-literal-integer"><span class="std std-ref">Integer</span></a>
or <a class="reference internal" href="#script-syntax-literal-float"><span class="std std-ref">Float</span></a>. For example, <code class="docutils literal notranslate"><span class="pre">1.2</span></code>,
<code class="docutils literal notranslate"><span class="pre">-10</span></code>, <code class="docutils literal notranslate"><span class="pre">314e-2</span></code> and so on.</p></li>
<li><p>String value: Replace <code class="docutils literal notranslate"><span class="pre">&quot;</span></code> with <code class="docutils literal notranslate"><span class="pre">\&quot;</span></code> and <code class="docutils literal notranslate"><span class="pre">\</span></code> with <code class="docutils literal notranslate"><span class="pre">\\</span></code> in
the string value and surround substituted string value by
<code class="docutils literal notranslate"><span class="pre">&quot;</span></code>. For example, <code class="docutils literal notranslate"><span class="pre">double</span> <span class="pre">&quot;</span> <span class="pre">quote</span> <span class="pre">and</span> <span class="pre">back</span> <span class="pre">\</span> <span class="pre">slash</span></code> should be
converted to <code class="docutils literal notranslate"><span class="pre">&quot;double</span> <span class="pre">\&quot;</span> <span class="pre">quote</span> <span class="pre">and</span> <span class="pre">back</span> <span class="pre">\\</span> <span class="pre">slash&quot;</span></code>.</p></li>
</ul>
</div></blockquote>
</div>
<div class="section" id="sample-data">
<h2><span class="section-number">7.13.2.2. </span>Sample data<a class="headerlink" href="#sample-data" title="Permalink to this headline">¶</a></h2>
<p>Here are a schema definition and sample data to show usage.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>table_create Entries TABLE_PAT_KEY ShortText
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create Entries content COLUMN_SCALAR Text
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create Entries n_likes COLUMN_SCALAR UInt32
# [[0, 1337566253.89858, 0.000355720520019531], true]
table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create Terms entries_key_index COLUMN_INDEX|WITH_POSITION Entries _key
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content
# [[0, 1337566253.89858, 0.000355720520019531], true]
load --table Entries
[
{&quot;_key&quot;:    &quot;The first post!&quot;,
 &quot;content&quot;: &quot;Welcome! This is my first post!&quot;,
 &quot;n_likes&quot;: 5},
{&quot;_key&quot;:    &quot;Groonga&quot;,
 &quot;content&quot;: &quot;I started to use Groonga. It&#39;s very fast!&quot;,
 &quot;n_likes&quot;: 10},
{&quot;_key&quot;:    &quot;Mroonga&quot;,
 &quot;content&quot;: &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
 &quot;n_likes&quot;: 15},
{&quot;_key&quot;:    &quot;Good-bye Senna&quot;,
 &quot;content&quot;: &quot;I migrated all Senna system!&quot;,
 &quot;n_likes&quot;: 3},
{&quot;_key&quot;:    &quot;Good-bye Tritonn&quot;,
 &quot;content&quot;: &quot;I also migrated all Tritonn system!&quot;,
 &quot;n_likes&quot;: 3}
]
# [[0, 1337566253.89858, 0.000355720520019531], 5]
</pre></div>
</div>
<p>There is a table, <code class="docutils literal notranslate"><span class="pre">Entries</span></code>, for blog entries. An entry has title,
content and the number of likes for the entry. Title is key of
<code class="docutils literal notranslate"><span class="pre">Entries</span></code>. Content is value of <code class="docutils literal notranslate"><span class="pre">Entries.content</span></code> column. The
number of likes is value of <code class="docutils literal notranslate"><span class="pre">Entries.n_likes</span></code> column.</p>
<p><code class="docutils literal notranslate"><span class="pre">Entries._key</span></code> column and <code class="docutils literal notranslate"><span class="pre">Entries.content</span></code> column are indexed
using <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> tokenizer. So both <code class="docutils literal notranslate"><span class="pre">Entries._key</span></code> and
<code class="docutils literal notranslate"><span class="pre">Entries.content</span></code> are fulltext search ready.</p>
<p>OK. The schema and data for examples are ready.</p>
</div>
<div class="section" id="literals">
<span id="script-syntax-literals"></span><h2><span class="section-number">7.13.2.3. </span>Literals<a class="headerlink" href="#literals" title="Permalink to this headline">¶</a></h2>
<div class="section" id="integer">
<span id="script-syntax-literal-integer"></span><h3><span class="section-number">7.13.2.3.1. </span>Integer<a class="headerlink" href="#integer" title="Permalink to this headline">¶</a></h3>
<p>Integer literal is sequence of <code class="docutils literal notranslate"><span class="pre">0</span></code> to <code class="docutils literal notranslate"><span class="pre">9</span></code> such as
<code class="docutils literal notranslate"><span class="pre">1234567890</span></code>. <code class="docutils literal notranslate"><span class="pre">+</span></code> or <code class="docutils literal notranslate"><span class="pre">-</span></code> can be prepended as sign such as
<code class="docutils literal notranslate"><span class="pre">+29</span></code> and <code class="docutils literal notranslate"><span class="pre">-29</span></code>. Integer literal must be decimal. Octal notation,
hex and so on can’t be used.</p>
<p>The maximum value of integer literal is <code class="docutils literal notranslate"><span class="pre">9223372036854775807</span></code> (<code class="docutils literal notranslate"><span class="pre">=</span> <span class="pre">2</span>
<span class="pre">**</span> <span class="pre">63</span> <span class="pre">-</span> <span class="pre">1</span></code>). The minimum value of integer literal is
<code class="docutils literal notranslate"><span class="pre">-9223372036854775808</span></code> (<code class="docutils literal notranslate"><span class="pre">=</span> <span class="pre">-(2</span> <span class="pre">**</span> <span class="pre">63)</span></code>).</p>
</div>
<div class="section" id="float">
<span id="script-syntax-literal-float"></span><h3><span class="section-number">7.13.2.3.2. </span>Float<a class="headerlink" href="#float" title="Permalink to this headline">¶</a></h3>
<p>Float literal is sequence of <code class="docutils literal notranslate"><span class="pre">0</span></code> to <code class="docutils literal notranslate"><span class="pre">9</span></code>, <code class="docutils literal notranslate"><span class="pre">.</span></code> and <code class="docutils literal notranslate"><span class="pre">0</span></code> to <code class="docutils literal notranslate"><span class="pre">9</span></code>
such as <code class="docutils literal notranslate"><span class="pre">3.14</span></code>. <code class="docutils literal notranslate"><span class="pre">+</span></code> or <code class="docutils literal notranslate"><span class="pre">-</span></code> can be prepended as sign such as
<code class="docutils literal notranslate"><span class="pre">+3.14</span></code> and <code class="docutils literal notranslate"><span class="pre">-3.14</span></code>. <code class="docutils literal notranslate"><span class="pre">${RADIX}e${EXPORNENTIAL}</span></code> and
<code class="docutils literal notranslate"><span class="pre">${RADIX}E${EXPORNENTIAL}</span></code> formats are also supported. For example,
<code class="docutils literal notranslate"><span class="pre">314e-2</span></code> is the same as <code class="docutils literal notranslate"><span class="pre">3.14</span></code>.</p>
</div>
<div class="section" id="string">
<span id="script-syntax-literal-string"></span><h3><span class="section-number">7.13.2.3.3. </span>String<a class="headerlink" href="#string" title="Permalink to this headline">¶</a></h3>
<p>String literal is <code class="docutils literal notranslate"><span class="pre">&quot;...&quot;</span></code>. You need to escape <code class="docutils literal notranslate"><span class="pre">&quot;</span></code> in literal by
prepending <code class="docutils literal notranslate"><span class="pre">\\''</span> <span class="pre">such</span> <span class="pre">as</span> <span class="pre">``\&quot;</span></code>. For example, <code class="docutils literal notranslate"><span class="pre">&quot;Say</span> <span class="pre">\&quot;Hello!\&quot;.&quot;</span></code> is
a literal for <code class="docutils literal notranslate"><span class="pre">Say</span> <span class="pre">&quot;Hello!&quot;.</span></code> string.</p>
<p>String encoding must be the same as encoding of database. The default
encoding is UTF-8. It can be changed by <code class="docutils literal notranslate"><span class="pre">--with-default-encoding</span></code>
configure option, <code class="docutils literal notranslate"><span class="pre">--encodiong</span></code> <a class="reference internal" href="../executables/groonga.html"><span class="doc">groonga executable file</span></a> option
and so on.</p>
</div>
<div class="section" id="boolean">
<span id="script-syntax-literal-boolean"></span><h3><span class="section-number">7.13.2.3.4. </span>Boolean<a class="headerlink" href="#boolean" title="Permalink to this headline">¶</a></h3>
<p>Boolean literal is <code class="docutils literal notranslate"><span class="pre">true</span></code> and <code class="docutils literal notranslate"><span class="pre">false</span></code>. <code class="docutils literal notranslate"><span class="pre">true</span></code> means true and
<code class="docutils literal notranslate"><span class="pre">false</span></code> means false.</p>
</div>
<div class="section" id="null">
<span id="script-syntax-literal-null"></span><h3><span class="section-number">7.13.2.3.5. </span>Null<a class="headerlink" href="#null" title="Permalink to this headline">¶</a></h3>
<p>Null literal is <code class="docutils literal notranslate"><span class="pre">null</span></code>. Groonga doesn’t support null value but null
literal is supported.</p>
</div>
<div class="section" id="time">
<span id="script-syntax-literal-time"></span><h3><span class="section-number">7.13.2.3.6. </span>Time<a class="headerlink" href="#time" title="Permalink to this headline">¶</a></h3>
<div class="admonition note">
<p class="admonition-title">Note</p>
<p>This is the groonga original notation.</p>
</div>
<p>Time literal doesn’t exit. There are string time notation, integer
time notation and float time notation.</p>
<p>String time notation is <code class="docutils literal notranslate"><span class="pre">&quot;YYYY/MM/DD</span> <span class="pre">hh:mm:ss.uuuuuu&quot;</span></code> or
<code class="docutils literal notranslate"><span class="pre">&quot;YYYY-MM-DD</span> <span class="pre">hh:mm:ss.uuuuuu&quot;</span></code>. <code class="docutils literal notranslate"><span class="pre">YYYY</span></code> is year, <code class="docutils literal notranslate"><span class="pre">MM</span></code> is month,
<code class="docutils literal notranslate"><span class="pre">DD</span></code> is day, <code class="docutils literal notranslate"><span class="pre">hh</span></code> is hour, <code class="docutils literal notranslate"><span class="pre">mm</span></code> is minute, <code class="docutils literal notranslate"><span class="pre">ss</span></code> is second and
<code class="docutils literal notranslate"><span class="pre">uuuuuu</span></code> is micro second. It is local time. For example,
<code class="docutils literal notranslate"><span class="pre">&quot;2012/07/23</span> <span class="pre">02:41:10.436218&quot;</span></code> is <code class="docutils literal notranslate"><span class="pre">2012-07-23T02:41:10.436218</span></code> in
ISO 8601 format.</p>
<p>Integer time notation is the number of seconds that have elapsed since
midnight UTC, January 1, 1970. It is also known as POSIX time. For
example, <code class="docutils literal notranslate"><span class="pre">1343011270</span></code> is <code class="docutils literal notranslate"><span class="pre">2012-07-23T02:41:10Z</span></code> in ISO 8601 format.</p>
<p>Float time notation is the number of seconds and micro seconds that
have elapsed since midnight UTC, January 1, 1970. For example,
<code class="docutils literal notranslate"><span class="pre">1343011270.436218</span></code> is <code class="docutils literal notranslate"><span class="pre">2012-07-23T02:41:10.436218Z</span></code> in ISO 8601
format.</p>
</div>
<div class="section" id="geo-point">
<span id="script-syntax-literal-geo-point"></span><h3><span class="section-number">7.13.2.3.7. </span>Geo point<a class="headerlink" href="#geo-point" title="Permalink to this headline">¶</a></h3>
<div class="admonition note">
<p class="admonition-title">Note</p>
<p>This is the groonga original notation.</p>
</div>
<p>Geo point literal doesn’t exist. There is string geo point notation.</p>
<p>String geo point notation has the following patterns:</p>
<blockquote>
<div><ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">&quot;LATITUDE_IN_MSECxLONGITUDE_IN_MSEC&quot;</span></code></p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">&quot;LATITUDE_IN_MSEC,LONGITUDE_IN_MSEC&quot;</span></code></p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">&quot;LATITUDE_IN_DEGREExLONGITUDE_IN_DEGREE&quot;</span></code></p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">&quot;LATITUDE_IN_DEGREE,LONGITUDE_IN_DEGREE&quot;</span></code></p></li>
</ul>
</div></blockquote>
<p><code class="docutils literal notranslate"><span class="pre">x</span></code> and <code class="docutils literal notranslate"><span class="pre">,</span></code> can be used for separator. Latitude and longitude can
be represented in milliseconds or degree.</p>
</div>
<div class="section" id="array">
<span id="script-syntax-literal-array"></span><h3><span class="section-number">7.13.2.3.8. </span>Array<a class="headerlink" href="#array" title="Permalink to this headline">¶</a></h3>
<p>Array literal is <code class="docutils literal notranslate"><span class="pre">[element1,</span> <span class="pre">element2,</span> <span class="pre">...]</span></code>.</p>
</div>
<div class="section" id="object-literal">
<span id="script-syntax-literal-object"></span><h3><span class="section-number">7.13.2.3.9. </span>Object literal<a class="headerlink" href="#object-literal" title="Permalink to this headline">¶</a></h3>
<p>Object literal is <code class="docutils literal notranslate"><span class="pre">{name1:</span> <span class="pre">value1,</span> <span class="pre">name2:</span> <span class="pre">value2,</span> <span class="pre">...}</span></code>. Groonga
doesn’t support object literal yet.</p>
</div>
</div>
<div class="section" id="control-syntaxes">
<h2><span class="section-number">7.13.2.4. </span>Control syntaxes<a class="headerlink" href="#control-syntaxes" title="Permalink to this headline">¶</a></h2>
<p>Script syntax doesn’t support statement. So you cannot use control
statement such as <code class="docutils literal notranslate"><span class="pre">if</span></code>. You can only use <code class="docutils literal notranslate"><span class="pre">A</span> <span class="pre">?</span> <span class="pre">B</span> <span class="pre">:</span> <span class="pre">C</span></code> expression as
control syntax.</p>
<p><code class="docutils literal notranslate"><span class="pre">A</span> <span class="pre">?</span> <span class="pre">B</span> <span class="pre">:</span> <span class="pre">C</span></code> returns <code class="docutils literal notranslate"><span class="pre">B</span></code> if <code class="docutils literal notranslate"><span class="pre">A</span></code> is true, <code class="docutils literal notranslate"><span class="pre">C</span></code> otherwise.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == (_id == 1 ? 5 : 3)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         3
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         5,
#         &quot;Good-bye Tritonn&quot;,
#         &quot;I also migrated all Tritonn system!&quot;,
#         3
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">_id</span></code> column value is equal to <code class="docutils literal notranslate"><span class="pre">1</span></code>
and <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal to <code class="docutils literal notranslate"><span class="pre">5</span></code> or <code class="docutils literal notranslate"><span class="pre">_id</span></code> column value is
not equal to 1 and <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal to <code class="docutils literal notranslate"><span class="pre">3</span></code>.</p>
</div>
<div class="section" id="grouping">
<h2><span class="section-number">7.13.2.5. </span>Grouping<a class="headerlink" href="#grouping" title="Permalink to this headline">¶</a></h2>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">(...)</span></code>. <code class="docutils literal notranslate"><span class="pre">...</span></code> is comma separated expression list.</p>
<p><code class="docutils literal notranslate"><span class="pre">(...)</span></code> groups one ore more expressions and they can be processed as
an expression. <code class="docutils literal notranslate"><span class="pre">a</span> <span class="pre">&amp;&amp;</span> <span class="pre">b</span> <span class="pre">||</span> <span class="pre">c</span></code> means that <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> are matched
or <code class="docutils literal notranslate"><span class="pre">c</span></code> is matched. <code class="docutils literal notranslate"><span class="pre">a</span> <span class="pre">&amp;&amp;</span> <span class="pre">(b</span> <span class="pre">||</span> <span class="pre">c)</span></code> means that <code class="docutils literal notranslate"><span class="pre">a</span></code> and one of
<code class="docutils literal notranslate"><span class="pre">b</span></code> and <code class="docutils literal notranslate"><span class="pre">c</span></code> are matched.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes &lt; 5 &amp;&amp; content @ &quot;senna&quot; || content @ &quot;fast&quot;&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         3
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
select Entries --filter &#39;n_likes &lt; 5 &amp;&amp; (content @ &quot;senna&quot; || content @ &quot;fast&quot;)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The first expression doesn’t use grouping. It matches records that
<code class="docutils literal notranslate"><span class="pre">n_likes</span> <span class="pre">&lt;</span> <span class="pre">5</span></code> and <code class="docutils literal notranslate"><span class="pre">content</span> <span class="pre">&#64;</span> <span class="pre">&quot;senna&quot;</span></code> are matched or
<code class="docutils literal notranslate"><span class="pre">content</span> <span class="pre">&#64;</span> <span class="pre">&quot;fast&quot;</span></code> is matched.</p>
<p>The second expression uses grouping. It matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span>
<span class="pre">&lt;</span> <span class="pre">5</span></code> and one of <code class="docutils literal notranslate"><span class="pre">content</span> <span class="pre">&#64;</span> <span class="pre">&quot;senna&quot;</span></code> or <code class="docutils literal notranslate"><span class="pre">content</span> <span class="pre">&#64;</span> <span class="pre">&quot;fast&quot;</span></code> are
matched.</p>
</div>
<div class="section" id="function-call">
<h2><span class="section-number">7.13.2.6. </span>Function call<a class="headerlink" href="#function-call" title="Permalink to this headline">¶</a></h2>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">name(arugment1,</span> <span class="pre">argument2,</span> <span class="pre">...)</span></code>.</p>
<p><code class="docutils literal notranslate"><span class="pre">name(argument1,</span> <span class="pre">argument2,</span> <span class="pre">...)</span></code> calls a function that is named
<code class="docutils literal notranslate"><span class="pre">name</span></code> with arguments <code class="docutils literal notranslate"><span class="pre">argument1</span></code>, <code class="docutils literal notranslate"><span class="pre">argument2</span></code> and <code class="docutils literal notranslate"><span class="pre">...</span></code>.</p>
<p>See <a class="reference internal" href="../function.html"><span class="doc">Function</span></a> for available functin list.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;edit_distance(_key, &quot;Groonga&quot;) &lt;= 1&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression uses <a class="reference internal" href="../functions/edit_distance.html"><span class="doc">edit_distance</span></a>. It
matches records that <code class="docutils literal notranslate"><span class="pre">_key</span></code> column value is similar to
<code class="docutils literal notranslate"><span class="pre">&quot;Groonga&quot;</span></code>. Similality of <code class="docutils literal notranslate"><span class="pre">&quot;Groonga&quot;</span></code> is computed as edit
distance. If edit distance is less than or equal to 1, the value is
treated as similar. In this case, <code class="docutils literal notranslate"><span class="pre">&quot;Groonga&quot;</span></code> and <code class="docutils literal notranslate"><span class="pre">&quot;Mroonga&quot;</span></code> are
treated as similar.</p>
</div>
<div class="section" id="basic-operators">
<h2><span class="section-number">7.13.2.7. </span>Basic operators<a class="headerlink" href="#basic-operators" title="Permalink to this headline">¶</a></h2>
<p>Groonga supports operators defined in ECMAScript.</p>
<div class="section" id="arithmetic-operators">
<h3><span class="section-number">7.13.2.7.1. </span>Arithmetic operators<a class="headerlink" href="#arithmetic-operators" title="Permalink to this headline">¶</a></h3>
<p>Here are arithmetic operators.</p>
<div class="section" id="addition-operator">
<h4><span class="section-number">7.13.2.7.1.1. </span>Addition operator<a class="headerlink" href="#addition-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">+</span> <span class="pre">number2</span></code>.</p>
<p>The operator adds <code class="docutils literal notranslate"><span class="pre">number1</span></code> and <code class="docutils literal notranslate"><span class="pre">number2</span></code> and returns the result.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 10 + 5&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">15</span></code> (= <code class="docutils literal notranslate"><span class="pre">10</span> <span class="pre">+</span> <span class="pre">5</span></code>).</p>
</div>
<div class="section" id="subtraction-operator">
<h4><span class="section-number">7.13.2.7.1.2. </span>Subtraction operator<a class="headerlink" href="#subtraction-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">-</span> <span class="pre">number2</span></code>.</p>
<p>The operator subtracts <code class="docutils literal notranslate"><span class="pre">number2</span></code> from <code class="docutils literal notranslate"><span class="pre">number1</span></code> and returns the result.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 20 - 5&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">15</span></code> (= <code class="docutils literal notranslate"><span class="pre">20</span> <span class="pre">-</span> <span class="pre">5</span></code>).</p>
</div>
<div class="section" id="multiplication-operator">
<h4><span class="section-number">7.13.2.7.1.3. </span>Multiplication operator<a class="headerlink" href="#multiplication-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">*</span> <span class="pre">number2</span></code>.</p>
<p>The operator multiplies <code class="docutils literal notranslate"><span class="pre">number1</span></code> and <code class="docutils literal notranslate"><span class="pre">number2</span></code> and returns the result.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 3 * 5&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">15</span></code> (= <code class="docutils literal notranslate"><span class="pre">3</span> <span class="pre">*</span> <span class="pre">5</span></code>).</p>
</div>
<div class="section" id="division-operator">
<h4><span class="section-number">7.13.2.7.1.4. </span>Division operator<a class="headerlink" href="#division-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">/</span> <span class="pre">number2</span></code> and <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">%</span> <span class="pre">number2</span></code>.</p>
<p>The operator divides <code class="docutils literal notranslate"><span class="pre">number2</span></code> by <code class="docutils literal notranslate"><span class="pre">number1</span></code>. <code class="docutils literal notranslate"><span class="pre">/</span></code> returns the
quotient of result. <code class="docutils literal notranslate"><span class="pre">%</span></code> returns the remainder of result.</p>
<p>Here is simple examples.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 26 / 7&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         5,
#         &quot;Good-bye Tritonn&quot;,
#         &quot;I also migrated all Tritonn system!&quot;,
#         3
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">3</span></code> (= <code class="docutils literal notranslate"><span class="pre">26</span> <span class="pre">/</span> <span class="pre">7</span></code>).</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 26 % 7&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> (= <code class="docutils literal notranslate"><span class="pre">26</span> <span class="pre">%</span> <span class="pre">7</span></code>).</p>
</div>
</div>
<div class="section" id="logical-operators">
<h3><span class="section-number">7.13.2.7.2. </span>Logical operators<a class="headerlink" href="#logical-operators" title="Permalink to this headline">¶</a></h3>
<p>Here are logical operators.</p>
<div class="section" id="logical-not-operator">
<h4><span class="section-number">7.13.2.7.2.1. </span>Logical NOT operator<a class="headerlink" href="#logical-not-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">!condition</span></code>.</p>
<p>The operator inverts boolean value of <code class="docutils literal notranslate"><span class="pre">condition</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;!(n_likes == 5)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         4
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         5,
#         &quot;Good-bye Tritonn&quot;,
#         &quot;I also migrated all Tritonn system!&quot;,
#         3
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is not
equal to <code class="docutils literal notranslate"><span class="pre">5</span></code>.</p>
</div>
<div class="section" id="logical-and-operator">
<h4><span class="section-number">7.13.2.7.2.2. </span>Logical AND operator<a class="headerlink" href="#logical-and-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">condition1</span> <span class="pre">&amp;&amp;</span> <span class="pre">condition2</span></code>.</p>
<p>The operator returns true if both of <code class="docutils literal notranslate"><span class="pre">condition1</span></code> and
<code class="docutils literal notranslate"><span class="pre">condition2</span></code> are true, false otherwise.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content @ &quot;fast&quot; &amp;&amp; n_likes &gt;= 10&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">content</span></code> column value has the
word <code class="docutils literal notranslate"><span class="pre">fast</span></code> and <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is greater or equal to
<code class="docutils literal notranslate"><span class="pre">10</span></code>.</p>
</div>
<div class="section" id="logical-or-operator">
<h4><span class="section-number">7.13.2.7.2.3. </span>Logical OR operator<a class="headerlink" href="#logical-or-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">condition1</span> <span class="pre">||</span> <span class="pre">condition2</span></code>.</p>
<p>The operator returns true if either <code class="docutils literal notranslate"><span class="pre">condition1</span></code> or <code class="docutils literal notranslate"><span class="pre">condition2</span></code> is
true, false otherwise.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 5 || n_likes == 10&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> or <code class="docutils literal notranslate"><span class="pre">10</span></code>.</p>
</div>
<div class="section" id="logical-and-not-operator">
<h4><span class="section-number">7.13.2.7.2.4. </span>Logical AND NOT operator<a class="headerlink" href="#logical-and-not-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">condition1</span> <span class="pre">&amp;!</span> <span class="pre">condition2</span></code>.</p>
<p>The operator returns true if <code class="docutils literal notranslate"><span class="pre">condition1</span></code> is true but <code class="docutils literal notranslate"><span class="pre">condition2</span></code>
is false, false otherwise. It returns difference set.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content @ &quot;fast&quot; &amp;! content @ &quot;mroonga&quot;&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">content</span></code> column value has the
word <code class="docutils literal notranslate"><span class="pre">fast</span></code> but doesn’t have the word <code class="docutils literal notranslate"><span class="pre">mroonga</span></code>.</p>
</div>
</div>
<div class="section" id="bitwise-operators">
<span id="script-syntax-bitwise-operators"></span><h3><span class="section-number">7.13.2.7.3. </span>Bitwise operators<a class="headerlink" href="#bitwise-operators" title="Permalink to this headline">¶</a></h3>
<p>Here are bitwise operators.</p>
<div class="section" id="bitwise-not-operator">
<span id="script-syntax-bitwise-not"></span><h4><span class="section-number">7.13.2.7.3.1. </span>Bitwise NOT operator<a class="headerlink" href="#bitwise-not-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">~number</span></code>.</p>
<p>The operator returns bitwise NOT of <code class="docutils literal notranslate"><span class="pre">number</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;~n_likes == -6&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> because bitwise NOT of <code class="docutils literal notranslate"><span class="pre">5</span></code> is equal to <code class="docutils literal notranslate"><span class="pre">-6</span></code>.</p>
</div>
<div class="section" id="bitwise-and-operator">
<span id="script-syntax-bitwise-and"></span><h4><span class="section-number">7.13.2.7.3.2. </span>Bitwise AND operator<a class="headerlink" href="#bitwise-and-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">&amp;</span> <span class="pre">number2</span></code>.</p>
<p>The operator returns bitwise AND between <code class="docutils literal notranslate"><span class="pre">number1</span></code> and <code class="docutils literal notranslate"><span class="pre">number2</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;(n_likes &amp; 1) == 1&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         4
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         5,
#         &quot;Good-bye Tritonn&quot;,
#         &quot;I also migrated all Tritonn system!&quot;,
#         3
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is even
number because bitwise AND between an even number and <code class="docutils literal notranslate"><span class="pre">1</span></code> is equal
to <code class="docutils literal notranslate"><span class="pre">1</span></code> and bitwise AND between an odd number and <code class="docutils literal notranslate"><span class="pre">1</span></code> is equal to
<code class="docutils literal notranslate"><span class="pre">0</span></code>.</p>
</div>
</div>
<div class="section" id="bitwise-or-operator">
<span id="script-syntax-bitwise-or"></span><h3><span class="section-number">7.13.2.7.4. </span>Bitwise OR operator<a class="headerlink" href="#bitwise-or-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">|</span> <span class="pre">number2</span></code>.</p>
<p>The operator returns bitwise OR between <code class="docutils literal notranslate"><span class="pre">number1</span></code> and <code class="docutils literal notranslate"><span class="pre">number2</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == (1 | 4)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> (= <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">|</span> <span class="pre">4</span></code>).</p>
</div>
<div class="section" id="bitwise-xor-operator">
<span id="script-syntax-bitwise-xor"></span><h3><span class="section-number">7.13.2.7.5. </span>Bitwise XOR operator<a class="headerlink" href="#bitwise-xor-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">^</span> <span class="pre">number2</span></code>.</p>
<p>The operator returns bitwise XOR between <code class="docutils literal notranslate"><span class="pre">number1</span></code> and <code class="docutils literal notranslate"><span class="pre">number2</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == (10 ^ 15)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> (= <code class="docutils literal notranslate"><span class="pre">10</span> <span class="pre">^</span> <span class="pre">15</span></code>).</p>
</div>
<div class="section" id="shift-operators">
<span id="script-syntax-shift-operators"></span><h3><span class="section-number">7.13.2.7.6. </span>Shift operators<a class="headerlink" href="#shift-operators" title="Permalink to this headline">¶</a></h3>
<p>Here are shift operators.</p>
<div class="section" id="left-shift-operator">
<span id="script-syntax-shift-left"></span><h4><span class="section-number">7.13.2.7.6.1. </span>Left shift operator<a class="headerlink" href="#left-shift-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">&lt;&lt;</span> <span class="pre">number2</span></code>.</p>
<p>The operator performs a bitwise left shift operation on <code class="docutils literal notranslate"><span class="pre">number1</span></code> by
<code class="docutils literal notranslate"><span class="pre">number2</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == (5 &lt;&lt; 1)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">10</span></code> (= <code class="docutils literal notranslate"><span class="pre">5</span> <span class="pre">&lt;&lt;</span> <span class="pre">1</span></code>).</p>
</div>
<div class="section" id="signed-right-shift-operator">
<span id="script-syntax-shift-signed-right"></span><h4><span class="section-number">7.13.2.7.6.2. </span>Signed right shift operator<a class="headerlink" href="#signed-right-shift-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">&gt;&gt;</span> <span class="pre">number2</span></code>.</p>
<p>The operator shifts bits of <code class="docutils literal notranslate"><span class="pre">number1</span></code> to right by <code class="docutils literal notranslate"><span class="pre">number2</span></code>. The sign
of the result is the same as <code class="docutils literal notranslate"><span class="pre">number1</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == -(-10 &gt;&gt; 1)&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> (= <code class="docutils literal notranslate"><span class="pre">-(-10</span> <span class="pre">&gt;&gt;</span> <span class="pre">1)</span></code> = <code class="docutils literal notranslate"><span class="pre">-(-5)</span></code>).</p>
</div>
<div class="section" id="unsigned-right-shift-operator">
<span id="script-syntax-shift-unsigned-right"></span><h4><span class="section-number">7.13.2.7.6.3. </span>Unsigned right shift operator<a class="headerlink" href="#unsigned-right-shift-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">number1</span> <span class="pre">&gt;&gt;&gt;</span> <span class="pre">number2</span></code>.</p>
<p>The operator shifts bits of <code class="docutils literal notranslate"><span class="pre">number1</span></code> to right by <code class="docutils literal notranslate"><span class="pre">number2</span></code>. The
leftmost <code class="docutils literal notranslate"><span class="pre">number2</span></code> bits are filled by <code class="docutils literal notranslate"><span class="pre">0</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == (2147483648 - (-10 &gt;&gt;&gt; 1))&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code> (= <code class="docutils literal notranslate"><span class="pre">2147483648</span> <span class="pre">-</span> <span class="pre">(-10</span> <span class="pre">&gt;&gt;&gt;</span> <span class="pre">1)</span></code> = <code class="docutils literal notranslate"><span class="pre">2147483648</span> <span class="pre">-</span> <span class="pre">2147483643</span></code>).</p>
</div>
</div>
<div class="section" id="comparison-operators">
<h3><span class="section-number">7.13.2.7.7. </span>Comparison operators<a class="headerlink" href="#comparison-operators" title="Permalink to this headline">¶</a></h3>
<p>Here are comparison operators.</p>
<div class="section" id="equal-operator">
<span id="script-syntax-equal-operator"></span><h4><span class="section-number">7.13.2.7.7.1. </span>Equal operator<a class="headerlink" href="#equal-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">object1</span> <span class="pre">==</span> <span class="pre">object2</span></code>.</p>
<p>The operator returns true if <code class="docutils literal notranslate"><span class="pre">object1</span></code> equals to <code class="docutils literal notranslate"><span class="pre">object2</span></code>, false
otherwise.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes == 5&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         1,
#         &quot;The first post!&quot;,
#         &quot;Welcome! This is my first post!&quot;,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is equal
to <code class="docutils literal notranslate"><span class="pre">5</span></code>.</p>
</div>
<div class="section" id="not-equal-operator">
<h4><span class="section-number">7.13.2.7.7.2. </span>Not equal operator<a class="headerlink" href="#not-equal-operator" title="Permalink to this headline">¶</a></h4>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">object1</span> <span class="pre">!=</span> <span class="pre">object2</span></code>.</p>
<p>The operator returns true if <code class="docutils literal notranslate"><span class="pre">object1</span></code> does not equal to
<code class="docutils literal notranslate"><span class="pre">object2</span></code>, false otherwise.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;n_likes != 5&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         4
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         4,
#         &quot;Good-bye Senna&quot;,
#         &quot;I migrated all Senna system!&quot;,
#         3
#       ],
#       [
#         5,
#         &quot;Good-bye Tritonn&quot;,
#         &quot;I also migrated all Tritonn system!&quot;,
#         3
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that <code class="docutils literal notranslate"><span class="pre">n_likes</span></code> column value is not
equal to <code class="docutils literal notranslate"><span class="pre">5</span></code>.</p>
</div>
<div class="section" id="less-than-operator">
<h4><span class="section-number">7.13.2.7.7.3. </span>Less than operator<a class="headerlink" href="#less-than-operator" title="Permalink to this headline">¶</a></h4>
<p>TODO: …</p>
</div>
<div class="section" id="less-than-or-equal-to-operator">
<h4><span class="section-number">7.13.2.7.7.4. </span>Less than or equal to operator<a class="headerlink" href="#less-than-or-equal-to-operator" title="Permalink to this headline">¶</a></h4>
<p>TODO: …</p>
</div>
<div class="section" id="greater-than-operator">
<h4><span class="section-number">7.13.2.7.7.5. </span>Greater than operator<a class="headerlink" href="#greater-than-operator" title="Permalink to this headline">¶</a></h4>
<p>TODO: …</p>
</div>
<div class="section" id="greater-than-or-equal-to-operator">
<h4><span class="section-number">7.13.2.7.7.6. </span>Greater than or equal to operator<a class="headerlink" href="#greater-than-or-equal-to-operator" title="Permalink to this headline">¶</a></h4>
<p>TODO: …</p>
</div>
</div>
</div>
<div class="section" id="assignment-operators">
<h2><span class="section-number">7.13.2.8. </span>Assignment operators<a class="headerlink" href="#assignment-operators" title="Permalink to this headline">¶</a></h2>
<div class="section" id="addition-assignment-operator">
<h3><span class="section-number">7.13.2.8.1. </span>Addition assignment operator<a class="headerlink" href="#addition-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">+=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs addition assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score += n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         4
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         4
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         11
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         16
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         6
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs addition assignment operation such as ‘_score = _score + n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">+</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="subtraction-assignment-operator">
<h3><span class="section-number">7.13.2.8.2. </span>Subtraction assignment operator<a class="headerlink" href="#subtraction-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">-=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs subtraction assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score -= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         -2
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         -2
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         -9
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         -14
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         -4
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score - n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">-</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="multiplication-assignment-operator">
<h3><span class="section-number">7.13.2.8.3. </span>Multiplication assignment operator<a class="headerlink" href="#multiplication-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">*=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs multiplication assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score *= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         3
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         3
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         10
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         15
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score * n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">*</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="division-assignment-operator">
<h3><span class="section-number">7.13.2.8.4. </span>Division assignment operator<a class="headerlink" href="#division-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">/=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs division assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score /= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         0
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         0
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         0
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         0
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         0
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score / n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">/</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="modulo-assignment-operator">
<h3><span class="section-number">7.13.2.8.5. </span>Modulo assignment operator<a class="headerlink" href="#modulo-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">%=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs modulo assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score %= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         1
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         1
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         1
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         1
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         1
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score % n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">%</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="bitwise-left-shift-assignment-operator">
<h3><span class="section-number">7.13.2.8.6. </span>Bitwise left shift assignment operator<a class="headerlink" href="#bitwise-left-shift-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">&lt;&lt;=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs left shift assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score &lt;&lt;= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         8
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         8
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         1024
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         32768
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         32
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score &lt;&lt; n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">&lt;&lt;</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="bitwise-signed-right-shift-assignment-operator">
<h3><span class="section-number">7.13.2.8.7. </span>Bitwise signed right shift assignment operator<a class="headerlink" href="#bitwise-signed-right-shift-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column2</span> <span class="pre">&gt;&gt;=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs signed right shift assignment operation on column1 by column2.</p>
</div>
<div class="section" id="bitwise-unsigned-right-shift-assignment-operator">
<h3><span class="section-number">7.13.2.8.8. </span>Bitwise unsigned right shift assignment operator<a class="headerlink" href="#bitwise-unsigned-right-shift-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">&gt;&gt;&gt;=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs unsigned right shift assignment operation on column1 by column2.</p>
</div>
<div class="section" id="bitwise-and-assignment-operator">
<h3><span class="section-number">7.13.2.8.9. </span>Bitwise AND assignment operator<a class="headerlink" href="#bitwise-and-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">&amp;=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs bitwise AND assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score &amp;= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         1
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         1
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         0
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         1
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         1
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score &amp; n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Groonga” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 10.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">&amp;</span> <span class="pre">10</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="bitwise-or-assignment-operator">
<span id="script-syntax-bitwise-or-assign"></span><h3><span class="section-number">7.13.2.8.10. </span>Bitwise OR assignment operator<a class="headerlink" href="#bitwise-or-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">|=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs bitwise OR assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score |= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         3
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         3
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         11
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         15
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         5
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score | n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Groonga” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 10.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">|</span> <span class="pre">10</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
<div class="section" id="bitwise-xor-assignment-operator">
<h3><span class="section-number">7.13.2.8.11. </span>Bitwise XOR assignment operator<a class="headerlink" href="#bitwise-xor-assignment-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column1</span> <span class="pre">^=</span> <span class="pre">column2</span></code>.</p>
<p>The operator performs bitwise XOR assignment operation on column1 by column2.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --output_columns _key,n_likes,_score --filter true --scorer &#39;_score ^= n_likes&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         5
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_score&quot;,
#           &quot;Int32&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;,
#         3,
#         2
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;,
#         3,
#         2
#       ],
#       [
#         &quot;Groonga&quot;,
#         10,
#         11
#       ],
#       [
#         &quot;Mroonga&quot;,
#         15,
#         14
#       ],
#       [
#         &quot;The first post!&quot;,
#         5,
#         4
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> by <code class="docutils literal notranslate"><span class="pre">--filter</span></code> is always 1 in this case,
then performs subtraction assignment operation such as ‘_score = _score ^ n_likes’ for each records.</p>
<p>For example, the value of <code class="docutils literal notranslate"><span class="pre">_score</span></code> about the record which stores “Good-bye Senna” as the <code class="docutils literal notranslate"><span class="pre">_key</span></code>
is 3.</p>
<p>So the expression <code class="docutils literal notranslate"><span class="pre">1</span> <span class="pre">^</span> <span class="pre">3</span></code> is evaluated and stored to <code class="docutils literal notranslate"><span class="pre">_score</span></code> column as the execution result.</p>
</div>
</div>
<div class="section" id="original-operators">
<h2><span class="section-number">7.13.2.9. </span>Original operators<a class="headerlink" href="#original-operators" title="Permalink to this headline">¶</a></h2>
<p>Script syntax adds the original binary opearators to ECMAScript
syntax. They operate search specific operations. They are starts with
<code class="docutils literal notranslate"><span class="pre">&#64;</span></code> or <code class="docutils literal notranslate"><span class="pre">*</span></code>.</p>
<div class="section" id="match-operator">
<span id="script-syntax-match-operator"></span><h3><span class="section-number">7.13.2.9.1. </span>Match operator<a class="headerlink" href="#match-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column</span> <span class="pre">&#64;</span> <span class="pre">value</span></code>.</p>
<p>The operator searches <code class="docutils literal notranslate"><span class="pre">value</span></code> by inverted index of <code class="docutils literal notranslate"><span class="pre">column</span></code>.
Normally, full text search is operated but tag search can be operated.
Because tag search is also implemented by inverted index.</p>
<p><a class="reference internal" href="query_syntax.html"><span class="doc">Query syntax</span></a> uses this operator by default.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content @ &quot;fast&quot;&#39; --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;
#       ],
#       [
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that contain a word <code class="docutils literal notranslate"><span class="pre">fast</span></code> in
<code class="docutils literal notranslate"><span class="pre">content</span></code> column value.</p>
</div>
<div class="section" id="prefix-search-operator">
<span id="script-syntax-prefix-search-operator"></span><h3><span class="section-number">7.13.2.9.2. </span>Prefix search operator<a class="headerlink" href="#prefix-search-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column</span> <span class="pre">&#64;^</span> <span class="pre">value</span></code>.</p>
<p>The operator does prefix search with <code class="docutils literal notranslate"><span class="pre">value</span></code>. Prefix search searches
records that contain a word that starts with <code class="docutils literal notranslate"><span class="pre">value</span></code>.</p>
<p>You can use fast prefix search against a column. The column must be
indexed and index table must be patricia trie table
(<code class="docutils literal notranslate"><span class="pre">TABLE_PAT_KEY</span></code>) or double array trie table
(<code class="docutils literal notranslate"><span class="pre">TABLE_DAT_KEY</span></code>). You can also use fast prefix search against
<code class="docutils literal notranslate"><span class="pre">_key</span></code> pseudo column of patricia trie table or double array trie
table. You don’t need to index <code class="docutils literal notranslate"><span class="pre">_key</span></code>.</p>
<p>Prefix search can be used with other table types but it causes all
records scan. It’s not problem for small records but it spends more
time for large records.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;_key @^ &quot;Goo&quot;&#39; --output_columns _key
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ]
#       ],
#       [
#         &quot;Good-bye Senna&quot;
#       ],
#       [
#         &quot;Good-bye Tritonn&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that contain a word that starts with
<code class="docutils literal notranslate"><span class="pre">Goo</span></code> in <code class="docutils literal notranslate"><span class="pre">_key</span></code> pseudo column value. <code class="docutils literal notranslate"><span class="pre">Good-bye</span> <span class="pre">Senna</span></code> and
<code class="docutils literal notranslate"><span class="pre">Good-bye</span> <span class="pre">Tritonn</span></code> are matched with the expression.</p>
</div>
<div class="section" id="suffix-search-operator">
<span id="script-syntax-suffix-search-operator"></span><h3><span class="section-number">7.13.2.9.3. </span>Suffix search operator<a class="headerlink" href="#suffix-search-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column</span> <span class="pre">&#64;$</span> <span class="pre">value</span></code>.</p>
<p>This operator does suffix search with <code class="docutils literal notranslate"><span class="pre">value</span></code>. Suffix search
searches records that contain a word that ends with <code class="docutils literal notranslate"><span class="pre">value</span></code>.</p>
<p>You can use fast suffix search against a column. The column must be
indexed and index table must be patricia trie table
(<code class="docutils literal notranslate"><span class="pre">TABLE_PAT_KEY</span></code>) with <code class="docutils literal notranslate"><span class="pre">KEY_WITH_SIS</span></code> flag. You can also use fast
suffix search against <code class="docutils literal notranslate"><span class="pre">_key</span></code> pseudo column of patricia trie table
(<code class="docutils literal notranslate"><span class="pre">TABLE_PAT_KEY</span></code>) with <code class="docutils literal notranslate"><span class="pre">KEY_WITH_SIS</span></code> flag. You don’t need to
index <code class="docutils literal notranslate"><span class="pre">_key</span></code>. We recommended that you use index column based fast
suffix search instead of <code class="docutils literal notranslate"><span class="pre">_key</span></code> based fast suffix search. <code class="docutils literal notranslate"><span class="pre">_key</span></code>
based fast suffix search returns automatically registered
substrings. (TODO: write document about suffix search and link to it
from here.)</p>
<div class="admonition note">
<p class="admonition-title">Note</p>
<p>Fast suffix search can be used only for non-ASCII characters such
as hiragana in Japanese. You cannot use fast suffix search for
ASCII character.</p>
</div>
<p>Suffix search can be used with other table types or patricia trie
table without <code class="docutils literal notranslate"><span class="pre">KEY_WITH_SIS</span></code> flag but it causes all records
scan. It’s not problem for small records but it spends more time for
large records.</p>
<p>Here is a simple example. It uses fast suffix search for hiragana in
Japanese that is one of non-ASCII characters.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>table_create Titles TABLE_NO_KEY
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create Titles content COLUMN_SCALAR ShortText
# [[0, 1337566253.89858, 0.000355720520019531], true]
table_create SuffixSearchTerms TABLE_PAT_KEY|KEY_WITH_SIS ShortText
# [[0, 1337566253.89858, 0.000355720520019531], true]
column_create SuffixSearchTerms index COLUMN_INDEX Titles content
# [[0, 1337566253.89858, 0.000355720520019531], true]
load --table Titles
[
{&quot;content&quot;: &quot;ぐるんが&quot;},
{&quot;content&quot;: &quot;むるんが&quot;},
{&quot;content&quot;: &quot;せな&quot;},
{&quot;content&quot;: &quot;とりとん&quot;}
]
# [[0, 1337566253.89858, 0.000355720520019531], 4]
select Titles --query &#39;content:$んが&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;ShortText&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;むるんが&quot;
#       ],
#       [
#         1,
#         &quot;ぐるんが&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that have value that ends with <code class="docutils literal notranslate"><span class="pre">んが</span></code>
in <code class="docutils literal notranslate"><span class="pre">content</span></code> column value. <code class="docutils literal notranslate"><span class="pre">ぐるんが</span></code> and <code class="docutils literal notranslate"><span class="pre">むるんが</span></code> are matched
with the expression.</p>
</div>
<div class="section" id="near-search-operator">
<span id="script-syntax-near-search-operator"></span><h3><span class="section-number">7.13.2.9.4. </span>Near search operator<a class="headerlink" href="#near-search-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is one of them:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column *N &quot;word1 word2 ...&quot;
column *N${MAX_INTERVAL} &quot;word1 word2 ...&quot;
</pre></div>
</div>
<p>Here are the examples of the second form:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column *N29 &quot;word1 word2 ...&quot;
column *N-1 &quot;word1 word2 ...&quot;
</pre></div>
</div>
<p>The first example means that <code class="docutils literal notranslate"><span class="pre">29</span></code> is used for the max interval.</p>
<p>The second example means that <code class="docutils literal notranslate"><span class="pre">-1</span></code> is used for the max interval.
<code class="docutils literal notranslate"><span class="pre">-1</span></code> max interval means no limit.</p>
<p>The operator does near search with words <code class="docutils literal notranslate"><span class="pre">word1</span> <span class="pre">word2</span> <span class="pre">...</span></code>. Near
search searches records that contain the words and the words are
appeared in the specified order and the max interval.</p>
<p>The max interval is <code class="docutils literal notranslate"><span class="pre">10</span></code> by default. The unit of the max interval is
the number of characters in N-gram family tokenizers and the number of
words in morphological analysis family tokenizers.</p>
<p>However, <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> doesn’t split ASCII only word into tokens.
Because <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> uses white-space-separate like tokenize method
for ASCII characters in this case.</p>
<p>So the unit for ASCII words with <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> is the number of
words even if <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> is a N-gram family tokenizer.</p>
<p>Note that an index column for full text search must be defined for
<code class="docutils literal notranslate"><span class="pre">column</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content *N &quot;I fast&quot;&#39;      --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;
#       ]
#     ]
#   ]
# ]
select Entries --filter &#39;content *N &quot;I Really&quot;&#39;    --output_columns content
# [[0, 1337566253.89858, 0.000355720520019531], [[[0], [[&quot;content&quot;, &quot;Text&quot;]]]]]
select Entries --filter &#39;content *N &quot;also Really&quot;&#39; --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The first expression matches records that contain <code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">fast</span></code>
and the max interval of those words are in 10 words. So the record
that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">started</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span> <span class="pre">also</span> <span class="pre">very</span>
<span class="pre">fast!</span> <span class="pre">...</span></code> is matched. The number of words between <code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">fast</span></code>
is just 10.</p>
<p>The second expression matches records that contain <code class="docutils literal notranslate"><span class="pre">I</span></code> and
<code class="docutils literal notranslate"><span class="pre">Really</span></code> and the max interval of those words are in 10 words. So the
record that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">started</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span> <span class="pre">also</span>
<span class="pre">very</span> <span class="pre">fast!</span> <span class="pre">Really</span> <span class="pre">fast!</span></code> is not matched. The number of words between
<code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">Really</span></code> is 11.</p>
<p>The third expression matches records that contain <code class="docutils literal notranslate"><span class="pre">also</span></code> and
<code class="docutils literal notranslate"><span class="pre">Really</span></code> and the max interval of those words are in 10 words. So
the record that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">st</span> <span class="pre">arted</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span>
<span class="pre">also</span> <span class="pre">very</span> <span class="pre">fast!</span> <span class="pre">Really</span> <span class="pre">fast!</span></code> is matched. The number of words between
<code class="docutils literal notranslate"><span class="pre">also</span></code> and <code class="docutils literal notranslate"><span class="pre">Really</span></code> is 10.</p>
</div>
<div class="section" id="near-phrase-search-operator">
<span id="script-syntax-near-phrase-search-operator"></span><h3><span class="section-number">7.13.2.9.5. </span>Near phrase search operator<a class="headerlink" href="#near-phrase-search-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is one of them:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column *NP &quot;phrase1 phrase2 ...&quot;
column *NP${MAX_INTERVAL} &quot;phrase1 phrase2 ...&quot;
</pre></div>
</div>
<p>Here are the examples of the second form:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>column *NP29 &quot;phrase1 phrase2 ...&quot;
column *NP-1 &quot;phrase1 phrase2 ...&quot;
</pre></div>
</div>
<p>The first example means that <code class="docutils literal notranslate"><span class="pre">29</span></code> is used for the max interval.</p>
<p>The second example means that <code class="docutils literal notranslate"><span class="pre">-1</span></code> is used for the max interval.
<code class="docutils literal notranslate"><span class="pre">-1</span></code> max interval means no limit.</p>
<p>The operator does near phrase search with phrases <code class="docutils literal notranslate"><span class="pre">phrase1</span> <span class="pre">phrase2</span>
<span class="pre">...</span></code>. Near phrase search searches records that contain the phrases
and the phrases are appeared in the specified order and the max
interval.</p>
<p>The max interval is <code class="docutils literal notranslate"><span class="pre">10</span></code> by default. The unit of the max interval is
the number of characters in N-gram family tokenizers and the number of
words in morphological analysis family tokenizers.</p>
<p>However, <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> doesn’t split ASCII only word into tokens.
Because <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> uses white-space-separate like tokenize method
for ASCII characters in this case.</p>
<p>So the unit for ASCII words with <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> is the number of
words even if <code class="docutils literal notranslate"><span class="pre">TokenBigram</span></code> is a N-gram family tokenizer.</p>
<p>Note that an index column for full text search must be defined for
<code class="docutils literal notranslate"><span class="pre">column</span></code>.</p>
<p>TODO: Use index that has <code class="docutils literal notranslate"><span class="pre">TokenNgram(&quot;unify_alphabet&quot;,</span> <span class="pre">false)</span></code>
tokenizer to show difference with near search with English text.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content *NP &quot;I fast&quot;&#39;      --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;
#       ]
#     ]
#   ]
# ]
select Entries --filter &#39;content *NP &quot;I Really&quot;&#39;    --output_columns content
# [[0, 1337566253.89858, 0.000355720520019531], [[[0], [[&quot;content&quot;, &quot;Text&quot;]]]]]
select Entries --filter &#39;content *NP &quot;also Really&quot;&#39; --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         1
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The first expression matches records that contain <code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">fast</span></code>
and the max interval of those words are in 10 words. So the record
that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">started</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span> <span class="pre">also</span> <span class="pre">very</span>
<span class="pre">fast!</span> <span class="pre">...</span></code> is matched. The number of words between <code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">fast</span></code>
is just 10.</p>
<p>The second expression matches records that contain <code class="docutils literal notranslate"><span class="pre">I</span></code> and
<code class="docutils literal notranslate"><span class="pre">Really</span></code> and the max interval of those words are in 10 words. So the
record that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">started</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span> <span class="pre">also</span>
<span class="pre">very</span> <span class="pre">fast!</span> <span class="pre">Really</span> <span class="pre">fast!</span></code> is not matched. The number of words between
<code class="docutils literal notranslate"><span class="pre">I</span></code> and <code class="docutils literal notranslate"><span class="pre">Really</span></code> is 11.</p>
<p>The third expression matches records that contain <code class="docutils literal notranslate"><span class="pre">also</span></code> and
<code class="docutils literal notranslate"><span class="pre">Really</span></code> and the max interval of those words are in 10 words. So
the record that its content is <code class="docutils literal notranslate"><span class="pre">I</span> <span class="pre">also</span> <span class="pre">st</span> <span class="pre">arted</span> <span class="pre">to</span> <span class="pre">use</span> <span class="pre">mroonga.</span> <span class="pre">It's</span>
<span class="pre">also</span> <span class="pre">very</span> <span class="pre">fast!</span> <span class="pre">Really</span> <span class="pre">fast!</span></code> is matched. The number of words between
<code class="docutils literal notranslate"><span class="pre">also</span></code> and <code class="docutils literal notranslate"><span class="pre">Really</span></code> is 10.</p>
</div>
<div class="section" id="similar-search">
<span id="script-syntax-similar-search-operator"></span><h3><span class="section-number">7.13.2.9.6. </span>Similar search<a class="headerlink" href="#similar-search" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column</span> <span class="pre">*S</span> <span class="pre">&quot;document&quot;</span></code>.</p>
<p>The operator does similar search with document <code class="docutils literal notranslate"><span class="pre">document</span></code>. Similar
search searches records that have similar content to
<code class="docutils literal notranslate"><span class="pre">document</span></code>.</p>
<p>Note that an index column for full text search must be defined for
<code class="docutils literal notranslate"><span class="pre">column</span></code>.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content *S &quot;I migrated all Solr system!&quot;&#39; --output_columns content
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ]
#       ],
#       [
#         &quot;I migrated all Senna system!&quot;
#       ],
#       [
#         &quot;I also migrated all Tritonn system!&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression matches records that have similar content to <code class="docutils literal notranslate"><span class="pre">I</span>
<span class="pre">migrated</span> <span class="pre">all</span> <span class="pre">Solr</span> <span class="pre">system!</span></code>. In this case, records that have <code class="docutils literal notranslate"><span class="pre">I</span>
<span class="pre">migrated</span> <span class="pre">all</span> <span class="pre">XXX</span> <span class="pre">system!</span></code> content are matched.</p>
<p>You should use <code class="docutils literal notranslate"><span class="pre">TokenMecab</span></code> tokenizer for similar search against Japanese documents.
Because <code class="docutils literal notranslate"><span class="pre">TokenMecab</span></code> will tokenize target documents to almost words, it improves similar search precision.</p>
</div>
<div class="section" id="term-extract-operator">
<span id="script-syntax-term-extract-operator"></span><h3><span class="section-number">7.13.2.9.7. </span>Term extract operator<a class="headerlink" href="#term-extract-operator" title="Permalink to this headline">¶</a></h3>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">_key</span> <span class="pre">*T</span> <span class="pre">&quot;document&quot;</span></code>.</p>
<p>The operator extracts terms from <code class="docutils literal notranslate"><span class="pre">document</span></code>. Terms must be
registered as keys of the table of <code class="docutils literal notranslate"><span class="pre">_key</span></code>.</p>
<p>Note that the table must be patricia trie (<code class="docutils literal notranslate"><span class="pre">TABLE_PAT_KEY</span></code>) or
double array trie (<code class="docutils literal notranslate"><span class="pre">TABLE_DAT_KEY</span></code>). You can’t use hash table
(<code class="docutils literal notranslate"><span class="pre">TABLE_HASH_KEY</span></code>) and array (<code class="docutils literal notranslate"><span class="pre">TABLE_NO_KEY</span></code>) because they don’t
support longest common prefix search. Longest common prefix search is
used to implement the operator.</p>
<p>Here is a simple example.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>table_create Words TABLE_PAT_KEY ShortText --normalizer NormalizerAuto
# [[0, 1337566253.89858, 0.000355720520019531], true]
load --table Words
[
{&quot;_key&quot;: &quot;groonga&quot;},
{&quot;_key&quot;: &quot;mroonga&quot;},
{&quot;_key&quot;: &quot;Senna&quot;},
{&quot;_key&quot;: &quot;Tritonn&quot;}
]
# [[0, 1337566253.89858, 0.000355720520019531], 4]
select Words --filter &#39;_key *T &quot;Groonga is the successor project to Senna.&quot;&#39; --output_columns _key
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ]
#       ],
#       [
#         &quot;groonga&quot;
#       ],
#       [
#         &quot;senna&quot;
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>The expression extrcts terms that included in document <code class="docutils literal notranslate"><span class="pre">Groonga</span> <span class="pre">is</span>
<span class="pre">the</span> <span class="pre">successor</span> <span class="pre">project</span> <span class="pre">to</span> <span class="pre">Senna.</span></code>. In this case, <code class="docutils literal notranslate"><span class="pre">NormalizerAuto</span></code>
normalizer is specified to <code class="docutils literal notranslate"><span class="pre">Words</span></code>. So <code class="docutils literal notranslate"><span class="pre">Groonga</span></code> can be extracted
even if it is loaded as <code class="docutils literal notranslate"><span class="pre">groonga</span></code> into <code class="docutils literal notranslate"><span class="pre">Words</span></code>. All of extracted
terms are also normalized.</p>
</div>
<div class="section" id="regular-expression-operator">
<span id="script-syntax-regular-expression-operator"></span><h3><span class="section-number">7.13.2.9.8. </span>Regular expression operator<a class="headerlink" href="#regular-expression-operator" title="Permalink to this headline">¶</a></h3>
<div class="versionadded">
<p><span class="versionmodified added">New in version 5.0.1.</span></p>
</div>
<p>Its syntax is <code class="docutils literal notranslate"><span class="pre">column</span> <span class="pre">&#64;~</span> <span class="pre">&quot;pattern&quot;</span></code>.</p>
<p>The operator searches records by the regular expression
<code class="docutils literal notranslate"><span class="pre">pattern</span></code>. If a record’s <code class="docutils literal notranslate"><span class="pre">column</span></code> value is matched to <code class="docutils literal notranslate"><span class="pre">pattern</span></code>,
the record is matched.</p>
<p><code class="docutils literal notranslate"><span class="pre">pattern</span></code> must be valid regular expression syntax. See
<a class="reference internal" href="../regular_expression.html"><span class="doc">Regular expression</span></a> about regular expression syntax
details.</p>
<p>The following example uses <code class="docutils literal notranslate"><span class="pre">.roonga</span></code> as pattern. It matches
<code class="docutils literal notranslate"><span class="pre">Groonga</span></code>, <code class="docutils literal notranslate"><span class="pre">Mroonga</span></code> and so on.</p>
<p>Execution example:</p>
<div class="highlight-none notranslate"><div class="highlight"><pre><span></span>select Entries --filter &#39;content @~ &quot;.roonga&quot;&#39;
# [
#   [
#     0,
#     1337566253.89858,
#     0.000355720520019531
#   ],
#   [
#     [
#       [
#         2
#       ],
#       [
#         [
#           &quot;_id&quot;,
#           &quot;UInt32&quot;
#         ],
#         [
#           &quot;_key&quot;,
#           &quot;ShortText&quot;
#         ],
#         [
#           &quot;content&quot;,
#           &quot;Text&quot;
#         ],
#         [
#           &quot;n_likes&quot;,
#           &quot;UInt32&quot;
#         ]
#       ],
#       [
#         2,
#         &quot;Groonga&quot;,
#         &quot;I started to use Groonga. It&#39;s very fast!&quot;,
#         10
#       ],
#       [
#         3,
#         &quot;Mroonga&quot;,
#         &quot;I also started to use Mroonga. It&#39;s also very fast! Really fast!&quot;,
#         15
#       ]
#     ]
#   ]
# ]
</pre></div>
</div>
<p>In most cases, regular expression is evaluated sequentially. So it may
be slow against many records.</p>
<p>In some cases, Groonga evaluates regular expression by index. It’s
very fast. See <a class="reference internal" href="../regular_expression.html"><span class="doc">Regular expression</span></a> for details.</p>
</div>
</div>
</div>


            <div class="clearer"></div>
          </div>
        </div>
      </div>
      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
        <div class="sphinxsidebarwrapper">
  <h3><a href="../../index.html">Table of Contents</a></h3>
  <ul>
<li><a class="reference internal" href="#">7.13.2. Script syntax</a><ul>
<li><a class="reference internal" href="#security">7.13.2.1. Security</a></li>
<li><a class="reference internal" href="#sample-data">7.13.2.2. Sample data</a></li>
<li><a class="reference internal" href="#literals">7.13.2.3. Literals</a><ul>
<li><a class="reference internal" href="#integer">7.13.2.3.1. Integer</a></li>
<li><a class="reference internal" href="#float">7.13.2.3.2. Float</a></li>
<li><a class="reference internal" href="#string">7.13.2.3.3. String</a></li>
<li><a class="reference internal" href="#boolean">7.13.2.3.4. Boolean</a></li>
<li><a class="reference internal" href="#null">7.13.2.3.5. Null</a></li>
<li><a class="reference internal" href="#time">7.13.2.3.6. Time</a></li>
<li><a class="reference internal" href="#geo-point">7.13.2.3.7. Geo point</a></li>
<li><a class="reference internal" href="#array">7.13.2.3.8. Array</a></li>
<li><a class="reference internal" href="#object-literal">7.13.2.3.9. Object literal</a></li>
</ul>
</li>
<li><a class="reference internal" href="#control-syntaxes">7.13.2.4. Control syntaxes</a></li>
<li><a class="reference internal" href="#grouping">7.13.2.5. Grouping</a></li>
<li><a class="reference internal" href="#function-call">7.13.2.6. Function call</a></li>
<li><a class="reference internal" href="#basic-operators">7.13.2.7. Basic operators</a><ul>
<li><a class="reference internal" href="#arithmetic-operators">7.13.2.7.1. Arithmetic operators</a><ul>
<li><a class="reference internal" href="#addition-operator">7.13.2.7.1.1. Addition operator</a></li>
<li><a class="reference internal" href="#subtraction-operator">7.13.2.7.1.2. Subtraction operator</a></li>
<li><a class="reference internal" href="#multiplication-operator">7.13.2.7.1.3. Multiplication operator</a></li>
<li><a class="reference internal" href="#division-operator">7.13.2.7.1.4. Division operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#logical-operators">7.13.2.7.2. Logical operators</a><ul>
<li><a class="reference internal" href="#logical-not-operator">7.13.2.7.2.1. Logical NOT operator</a></li>
<li><a class="reference internal" href="#logical-and-operator">7.13.2.7.2.2. Logical AND operator</a></li>
<li><a class="reference internal" href="#logical-or-operator">7.13.2.7.2.3. Logical OR operator</a></li>
<li><a class="reference internal" href="#logical-and-not-operator">7.13.2.7.2.4. Logical AND NOT operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#bitwise-operators">7.13.2.7.3. Bitwise operators</a><ul>
<li><a class="reference internal" href="#bitwise-not-operator">7.13.2.7.3.1. Bitwise NOT operator</a></li>
<li><a class="reference internal" href="#bitwise-and-operator">7.13.2.7.3.2. Bitwise AND operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#bitwise-or-operator">7.13.2.7.4. Bitwise OR operator</a></li>
<li><a class="reference internal" href="#bitwise-xor-operator">7.13.2.7.5. Bitwise XOR operator</a></li>
<li><a class="reference internal" href="#shift-operators">7.13.2.7.6. Shift operators</a><ul>
<li><a class="reference internal" href="#left-shift-operator">7.13.2.7.6.1. Left shift operator</a></li>
<li><a class="reference internal" href="#signed-right-shift-operator">7.13.2.7.6.2. Signed right shift operator</a></li>
<li><a class="reference internal" href="#unsigned-right-shift-operator">7.13.2.7.6.3. Unsigned right shift operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#comparison-operators">7.13.2.7.7. Comparison operators</a><ul>
<li><a class="reference internal" href="#equal-operator">7.13.2.7.7.1. Equal operator</a></li>
<li><a class="reference internal" href="#not-equal-operator">7.13.2.7.7.2. Not equal operator</a></li>
<li><a class="reference internal" href="#less-than-operator">7.13.2.7.7.3. Less than operator</a></li>
<li><a class="reference internal" href="#less-than-or-equal-to-operator">7.13.2.7.7.4. Less than or equal to operator</a></li>
<li><a class="reference internal" href="#greater-than-operator">7.13.2.7.7.5. Greater than operator</a></li>
<li><a class="reference internal" href="#greater-than-or-equal-to-operator">7.13.2.7.7.6. Greater than or equal to operator</a></li>
</ul>
</li>
</ul>
</li>
<li><a class="reference internal" href="#assignment-operators">7.13.2.8. Assignment operators</a><ul>
<li><a class="reference internal" href="#addition-assignment-operator">7.13.2.8.1. Addition assignment operator</a></li>
<li><a class="reference internal" href="#subtraction-assignment-operator">7.13.2.8.2. Subtraction assignment operator</a></li>
<li><a class="reference internal" href="#multiplication-assignment-operator">7.13.2.8.3. Multiplication assignment operator</a></li>
<li><a class="reference internal" href="#division-assignment-operator">7.13.2.8.4. Division assignment operator</a></li>
<li><a class="reference internal" href="#modulo-assignment-operator">7.13.2.8.5. Modulo assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-left-shift-assignment-operator">7.13.2.8.6. Bitwise left shift assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-signed-right-shift-assignment-operator">7.13.2.8.7. Bitwise signed right shift assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-unsigned-right-shift-assignment-operator">7.13.2.8.8. Bitwise unsigned right shift assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-and-assignment-operator">7.13.2.8.9. Bitwise AND assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-or-assignment-operator">7.13.2.8.10. Bitwise OR assignment operator</a></li>
<li><a class="reference internal" href="#bitwise-xor-assignment-operator">7.13.2.8.11. Bitwise XOR assignment operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#original-operators">7.13.2.9. Original operators</a><ul>
<li><a class="reference internal" href="#match-operator">7.13.2.9.1. Match operator</a></li>
<li><a class="reference internal" href="#prefix-search-operator">7.13.2.9.2. Prefix search operator</a></li>
<li><a class="reference internal" href="#suffix-search-operator">7.13.2.9.3. Suffix search operator</a></li>
<li><a class="reference internal" href="#near-search-operator">7.13.2.9.4. Near search operator</a></li>
<li><a class="reference internal" href="#near-phrase-search-operator">7.13.2.9.5. Near phrase search operator</a></li>
<li><a class="reference internal" href="#similar-search">7.13.2.9.6. Similar search</a></li>
<li><a class="reference internal" href="#term-extract-operator">7.13.2.9.7. Term extract operator</a></li>
<li><a class="reference internal" href="#regular-expression-operator">7.13.2.9.8. Regular expression operator</a></li>
</ul>
</li>
</ul>
</li>
</ul>

  <h4>Previous topic</h4>
  <p class="topless"><a href="query_syntax.html"
                        title="previous chapter"><span class="section-number">7.13.1. </span>Query syntax</a></p>
  <h4>Next topic</h4>
  <p class="topless"><a href="../regular_expression.html"
                        title="next chapter"><span class="section-number">7.14. </span>Regular expression</a></p>
<div id="searchbox" style="display: none" role="search">
  <h3 id="searchlabel">Quick search</h3>
    <div class="searchformwrapper">
    <form class="search" action="../../search.html" method="get">
      <input type="text" name="q" aria-labelledby="searchlabel" />
      <input type="submit" value="Go" />
    </form>
    </div>
</div>
<script>$('#searchbox').show(0);</script>
        </div>
      </div>
      <div class="clearer"></div>
    </div>
    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../../genindex.html" title="General Index"
             >index</a></li>
        <li class="right" >
          <a href="../regular_expression.html" title="7.14. Regular expression"
             >next</a> |</li>
        <li class="right" >
          <a href="query_syntax.html" title="7.13.1. Query syntax"
             >previous</a> |</li>
        <li class="nav-item nav-item-0"><a href="../../index.html">Groonga v10.1.1-31-g1e46ba6 documentation</a> &#187;</li>
          <li class="nav-item nav-item-1"><a href="../../reference.html" ><span class="section-number">7. </span>Reference manual</a> &#187;</li>
          <li class="nav-item nav-item-2"><a href="../grn_expr.html" ><span class="section-number">7.13. </span>grn_expr</a> &#187;</li>
        <li class="nav-item nav-item-this"><a href=""><span class="section-number">7.13.2. </span>Script syntax</a></li> 
      </ul>
    </div>
    <div class="footer" role="contentinfo">
        &#169; Copyright 2009-2021, Brazil, Inc.
    </div>
  </body>
</html>