Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typo. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
b4cae844cddc53bccb5157dd071e5d48 |
User & Date: | mistachkin 2016-03-24 23:46:46.520 |
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 | 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> | | | 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: |
︙ | ︙ |