Documentation Source Text

Check-in [35441559aa]
Login

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

Overview
Comment:Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 35441559aa477c9f68d06127ed1c230e201c4557
User & Date: drh 2013-04-25 11:35:55
Context
2013-04-26
14:38
Add documentation for the fts3tokenize table. check-in: a6e655aa62 user: drh tags: trunk
2013-04-25
11:35
Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table. check-in: 35441559aa user: drh tags: trunk
2013-04-24
22:09
If the website keyword search fails, try again after lowercasing the input text. This avoids problems when users enter "OR" and "NEAR" as search terms rather than operators. check-in: 78cbbe549b user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/fts3.in.

  1560   1560   <codeblock>
  1561   1561     CREATE TABLE t2(id INTEGER PRIMARY KEY, a, b, c);
  1562   1562     CREATE VIRTUAL TABLE t3 USING fts4(content="t2", a, c);
  1563   1563   </codeblock>
  1564   1564   
  1565   1565   <p>
  1566   1566     Assuming the nominated table does exist, then its columns must be the same 
  1567         -  as or a superset of those defined for the FTS table.
         1567  +  as or a superset of those defined for the FTS table.  The external table
         1568  +  must also be in the same database file as the FTS table.  In other words,
         1569  +  The external table cannot be in a different database file connected using
         1570  +  [ATTACH] nor may one of the FTS table and the external content be in the
         1571  +  TEMP database when the other is in a persistent database file such as MAIN.
  1568   1572   
  1569   1573   <p>
  1570   1574     When a users query on the FTS table requires a column value other than
  1571         -  docid, FTS attempts to read this value from the corresponding column of
         1575  +  docid, FTS attempts to read the requested value from the corresponding column of
  1572   1576     the row in the content table with a rowid value equal to the current FTS
  1573   1577     docid. Or, if such a row cannot be found in the content table, a NULL
  1574   1578     value is used instead. For example:
  1575   1579   
  1576   1580   <codeblock>
  1577   1581     CREATE TABLE t2(id INTEGER PRIMARY KEY, a, b, c, d);
  1578   1582     CREATE VIRTUAL TABLE t3 USING fts4(content="t2", b, c);