Documentation Source Text

Check-in [544f9ccc33]
Login

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: 544f9ccc33b8fe37af30b3a98590816454fa9d7b
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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>