Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b4cae844cddc53bccb5157dd071e5d48 |
| 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
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 =, <, >, <=, >=, <>,
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 =, <, >, <=, >=, <>,
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:
|