Documentation Source Text

Check-in [b4cae844cd]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix typo.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b4cae844cddc53bccb5157dd071e5d48029d9b67
User & Date: mistachkin 2016-03-24 23:46:46
Context
2016-03-25
13:00
Additional fragments in the cli.html page. check-in: 84a1842726 user: drh tags: trunk
2016-03-24
23:46
Fix typo. check-in: b4cae844cd user: mistachkin tags: trunk
2016-03-23
11:51
Update testing statistics. check-in: ad4c9929f2 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/partialindex.in.

163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
in the query.  ^If a term of the form "6=b" appears in the index, it will
never match anything.</p>

<li><p>^If a term in X is of the form "z IS NOT NULL" and if a term in
       W is a comparison operator on "z" other than "IS", then those
       terms match.</p>

^(<p>Example:  Let the index by
<blockquote>
CREATE INDEX ex2 ON tab2(b,c) WHERE c IS NOT NULL;
</blockquote>
<p>Then any query that uses operators =, &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;,
or IN on column "c" would be usable with the partial index because those
comparison operators are only true if "c" is not NULL.)^  ^(So the following
query could use the partial index:







|







163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
in the query.  ^If a term of the form "6=b" appears in the index, it will
never match anything.</p>

<li><p>^If a term in X is of the form "z IS NOT NULL" and if a term in
       W is a comparison operator on "z" other than "IS", then those
       terms match.</p>

^(<p>Example:  Let the index be
<blockquote>
CREATE INDEX ex2 ON tab2(b,c) WHERE c IS NOT NULL;
</blockquote>
<p>Then any query that uses operators =, &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;,
or IN on column "c" would be usable with the partial index because those
comparison operators are only true if "c" is not NULL.)^  ^(So the following
query could use the partial index: