Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix an error in an example in the FTS5 documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
2ff6a32555f6e1a3d6f5e92c7399419b |
User & Date: | dan 2015-08-20 05:47:33.461 |
Context
2015-08-20
| ||
08:58 | Fix an error in the previous commit. (check-in: 3c56514778 user: dan tags: trunk) | |
05:47 | Fix an error in an example in the FTS5 documentation. (check-in: 2ff6a32555 user: dan tags: trunk) | |
2015-08-19
| ||
13:55 | Fix the argvIndex description in the virtual table documentation. (check-in: 26089f7cd9 user: drh tags: trunk) | |
Changes
Changes to pages/fts5.in.
︙ | ︙ | |||
1450 1451 1452 1453 1454 1455 1456 | CREATE VIRTUAL TABLE ft USING fts5(a, b); INSERT INTO ft(rowid, a, b) VALUES(1, 'X Y', 'Y Z'); INSERT INTO ft(rowid, a, b) VALUES(2, 'A Z', 'Y Y'); <i>-- The FTS5 module creates the following mapping on disk:</i> A --> (2, 0, 0) X --> (1, 0, 0) | | | | 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 | CREATE VIRTUAL TABLE ft USING fts5(a, b); INSERT INTO ft(rowid, a, b) VALUES(1, 'X Y', 'Y Z'); INSERT INTO ft(rowid, a, b) VALUES(2, 'A Z', 'Y Y'); <i>-- The FTS5 module creates the following mapping on disk:</i> A --> (2, 0, 0) X --> (1, 0, 0) Y --> (1, 0, 1) (1, 1, 0) (2, 1, 0) (2, 1, 1) Z --> (1, 2, 1) (2, 0, 1) </codeblock> <p>In the example above, each triple identifies the location of a token instance by rowid, column number (columns are numbered sequentially starting at 0 from left to right) and position within the column value (the first token in a column value is 0, the second is 1, and so on). Using this index, FTS5 is able to provide timely answers to queries such as "the set |
︙ | ︙ |