Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Improved names for triggers in the FTS documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
851c7d53b753d8e92380867539b10de2 |
User & Date: | drh 2012-08-22 22:50:55.741 |
Context
2012-08-25
| ||
01:56 | Update the change log for 3.7.14 to reflect the latest additions. (check-in: c98f1a5ff9 user: drh tags: trunk) | |
2012-08-22
| ||
22:50 | Improved names for triggers in the FTS documentation. (check-in: 851c7d53b7 user: drh tags: trunk) | |
2012-08-21
| ||
21:14 | Mention the SQLITE_DISABLE_FTS4_DEFERRED compile-time option in the release notes for 3.7.14. (check-in: 9bb0a29008 user: drh tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
1619 1620 1621 1622 1623 1624 1625 | CREATE TRIGGER t2_bu BEFORE UPDATE ON t2 BEGIN DELETE FROM t3 WHERE docid=old.rowid; END; CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN DELETE FROM t3 WHERE docid=old.rowid; END; | | | | 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 | CREATE TRIGGER t2_bu BEFORE UPDATE ON t2 BEGIN DELETE FROM t3 WHERE docid=old.rowid; END; CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN DELETE FROM t3 WHERE docid=old.rowid; END; CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); END; CREATE TRIGGER t2_ai AFTER INSERT ON t2 BEGIN INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); END; </codeblock> <p> The DELETE trigger must be fired before the actual delete takes place on the content table. This is so that FTS4 can still retrieve the original |
︙ | ︙ |