Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo in partial index documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.12 |
| Files: | files | file ages | folders |
| SHA1: |
544f9ccc33b8fe37af30b3a985908164 |
| User & Date: | drh 2016-04-15 11:43:05 |
Context
|
2016-04-18
| ||
| 18:05 | Update the change log and news for the 3.12.2 patch release. check-in: cf2965ab99 user: drh tags: branch-3.12 | |
|
2016-04-15
| ||
| 11:43 | Fix typo in partial index documentation. check-in: 544f9ccc33 user: drh tags: branch-3.12 | |
|
2016-04-08
| ||
| 15:12 | Changes for the 3.12.1 release. check-in: 38b637c8ea user: drh tags: branch-3.12 | |
Changes
Changes to pages/partialindex.in.
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
are created by UNIQUE or PRIMARY KEY constraints inside of CREATE TABLE
statements) are ordinary full indexes.
</p>
<p>
^The expression following the WHERE clause may contain operators,
literal values, and names of columns in the table being indexed.
^The WHERE clause may <em>not</em> contains subqueries, references to other
tables, functions, or [bound parameters]. The LIKE, GLOB, MATCH,
and REGEXP operators in SQLite are implemented as functions by the same name.
^Since functions are prohibited in the
WHERE clause of a CREATE INDEX statement, so too are the LIKE, GLOB,
MATCH, and REGEXP operators.</p>
<p>
|
| |
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
are created by UNIQUE or PRIMARY KEY constraints inside of CREATE TABLE statements) are ordinary full indexes. </p> <p> ^The expression following the WHERE clause may contain operators, literal values, and names of columns in the table being indexed. ^The WHERE clause may <em>not</em> contain subqueries, references to other tables, functions, or [bound parameters]. The LIKE, GLOB, MATCH, and REGEXP operators in SQLite are implemented as functions by the same name. ^Since functions are prohibited in the WHERE clause of a CREATE INDEX statement, so too are the LIKE, GLOB, MATCH, and REGEXP operators.</p> <p> |