Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo in FTS3 docs. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
58a14bf9e113b57c82783f177d7cbf2c |
| User & Date: | drh 2016-08-10 12:01:58 |
Context
|
2016-08-11
| ||
| 18:08 | Update the change log for version 3.14.1. (check-in: d986e123df user: drh tags: trunk) | |
|
2016-08-10
| ||
| 12:01 | Fix typo in FTS3 docs. (check-in: 58a14bf9e1 user: drh tags: trunk) | |
|
2016-08-09
| ||
| 19:48 | Update fts5.html to document negative column filters. (check-in: e79e555f14 user: dan tags: trunk) | |
Changes
Changes to pages/fts3.in.
2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 |
root BLOB, <i>-- B-tree root node</i>
PRIMARY KEY(level, idx)
);
</codeblock>
<p>
The schema depicted above is not designed to store the full-text index
directly. Instead, it is used to one or more b-tree structures. There
is one b-tree for each row in the %_segdir table. The %_segdir table
row contains the root node and various meta-data associated with the
b-tree structure, and the %_segments table contains all other (non-root)
b-tree nodes. Each b-tree is referred to as a "segment". Once it has
been created, a segment b-tree is never updated (although it may be
deleted altogether).
|
| |
2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 |
root BLOB, <i>-- B-tree root node</i>
PRIMARY KEY(level, idx)
);
</codeblock>
<p>
The schema depicted above is not designed to store the full-text index
directly. Instead, it is used to store one or more b-tree structures. There
is one b-tree for each row in the %_segdir table. The %_segdir table
row contains the root node and various meta-data associated with the
b-tree structure, and the %_segments table contains all other (non-root)
b-tree nodes. Each b-tree is referred to as a "segment". Once it has
been created, a segment b-tree is never updated (although it may be
deleted altogether).
|