Documentation Source Text

Check-in [3c56514778]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix an error in the previous commit.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3c5651477815a9f5a5421eb5b5e59cdae42be608
User & Date: dan 2015-08-20 08:58:31
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/fts5.in.

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 --&gt; (2, 0, 0)
  X --&gt; (1, 0, 0)
  Y --&gt; (1, 0, 1) (1, 1, 0) (2, 1, 0) (2, 1, 1)
  Z --&gt; (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







|







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 --&gt; (2, 0, 0)
  X --&gt; (1, 0, 0)
  Y --&gt; (1, 0, 1) (1, 1, 0) (2, 1, 0) (2, 1, 1)
  Z --&gt; (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