Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the file format document. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
01b45f38af6e724bfbf0a36f7bb9927b |
| User & Date: | drh 2017-03-07 22:25:07 |
Context
|
2017-03-09
| ||
| 13:36 | Initial work on improving the CLI documentation. Much more needed here. (check-in: fcac2a0e45 user: drh tags: trunk) | |
|
2017-03-07
| ||
| 22:25 | Fix a typo in the file format document. (check-in: 01b45f38af user: drh tags: trunk) | |
| 13:08 | Merge the search form fix from the 3.17 branch. (check-in: 4a748fb25c user: drh tags: trunk) | |
Changes
Changes to pages/fileformat2.in.
1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 |
table and entries in each index associated with that table.
^However, in a [partial index], the index b-tree only contains entries
corresponding to table rows for which the WHERE clause expression on the
CREATE INDEX statement is true.
^Corresponding rows in the index and table b-trees share the same rowid
or primary key values and contain the same value for all indexed columns.</p>
<h3>Suppression of redundant columns in WITHOUT ROWID secondary indexed
</h3>
<p> ^In an index on a WITHOUT ROWID table, if one or more of the columns
of the table PRIMARY KEY are also columns of the index, then the
indexed column is not repeated in the table-key suffix on the end of
the index record. ^(As an example, consider the following SQL:
|
| |
1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 |
table and entries in each index associated with that table.
^However, in a [partial index], the index b-tree only contains entries
corresponding to table rows for which the WHERE clause expression on the
CREATE INDEX statement is true.
^Corresponding rows in the index and table b-trees share the same rowid
or primary key values and contain the same value for all indexed columns.</p>
<h3>Suppression of redundant columns in WITHOUT ROWID secondary indexes
</h3>
<p> ^In an index on a WITHOUT ROWID table, if one or more of the columns
of the table PRIMARY KEY are also columns of the index, then the
indexed column is not repeated in the table-key suffix on the end of
the index record. ^(As an example, consider the following SQL:
|