Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix an error in the previous commit. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3c5651477815a9f5a5421eb5b5e59cda |
User & Date: | dan 2015-08-20 08:58:31.021 |
Context
2015-08-21
| ||
14:22 | Add NDSeV to the front page as an acknowledged SQLite Consortium member. (check-in: ccecfa130e user: drh tags: trunk) | |
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) | |
Changes
Changes to pages/fts5.in.
︙ | ︙ | |||
1451 1452 1453 1454 1455 1456 1457 | 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) | | | 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 | 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, 1, 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 |
︙ | ︙ |