Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update documentation to note that fts5 contentless and external content tables do not support REPLACE. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
8885fffc21dea3f90bf3e076f76acdb7 |
| User & Date: | dan 2015-10-27 19:18:30 |
Context
|
2015-10-29
| ||
| 18:16 | Bring the formatchng.html document up-to-date. (check-in: afff09ce00 user: drh tags: trunk) | |
|
2015-10-27
| ||
| 19:18 | Update documentation to note that fts5 contentless and external content tables do not support REPLACE. (check-in: 8885fffc21 user: dan tags: trunk) | |
| 17:23 | Rework the website menu to add the Purchase link. (check-in: 8ba3eb4736 user: drh tags: trunk) | |
Changes
Changes to pages/fts5.in.
625
626
627
628
629
630
631
632
633
634
635
636
637
638
...
685
686
687
688
689
690
691
692
693
694
695
696
697
698
|
<codeblock>
CREATE VIRTUAL TABLE f1 USING fts5(a, b, c, content='');
</codeblock>
<p> Contentless FTS5 tables do not support UPDATE or DELETE statements, or
INSERT statements that do not supply a non-NULL value for the rowid field.
Rows may be deleted from a contentless table using an [FTS5 delete command].
<p> Attempting to read any column value except the rowid from a contentless
FTS5 table returns an SQL NULL value.
<h3 tags="FTS5 external content tables">External Content Tables</h3>
................................................................................
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
END;
CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
</codeblock>
<h2 tags="FTS5 columnsize option">The Columnsize Option</h2>
<p>Normally, FTS5 maintains a special backing table within the database that
stores the size of each column value in tokens inserted into the main FTS5
table in a separate table. This backing table is used by the
<a href=#xColumnSize>xColumnSize<a> API function, which is in turn used by
|
>
>
>
>
>
>
|
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
...
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
|
<codeblock> CREATE VIRTUAL TABLE f1 USING fts5(a, b, c, content=''); </codeblock> <p> Contentless FTS5 tables do not support UPDATE or DELETE statements, or INSERT statements that do not supply a non-NULL value for the rowid field. Contentless tables do not support REPLACE conflict handling. REPLACE and INSERT OR REPLACE statements are treated as regular INSERT statements. Rows may be deleted from a contentless table using an [FTS5 delete command]. <p> Attempting to read any column value except the rowid from a contentless FTS5 table returns an SQL NULL value. <h3 tags="FTS5 external content tables">External Content Tables</h3> ................................................................................ INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c); END; CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c); INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c); END; </codeblock> <p> Like contentless tables, external content tables do not support REPLACE conflict handling. Any operations that specify REPLACE conflict handling are handled using ABORT. <h2 tags="FTS5 columnsize option">The Columnsize Option</h2> <p>Normally, FTS5 maintains a special backing table within the database that stores the size of each column value in tokens inserted into the main FTS5 table in a separate table. This backing table is used by the <a href=#xColumnSize>xColumnSize<a> API function, which is in turn used by |