Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the RBU documentation to remove the constraint about it not working with indexes on expressions. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
e7771db6ccec2df627a019cd22e30850 |
User & Date: | drh 2019-09-26 19:34:22.794 |
Context
2019-09-27
| ||
11:30 | Type fixes (check-in: 003eb4df17 user: drh tags: trunk) | |
2019-09-26
| ||
19:34 | Update the RBU documentation to remove the constraint about it not working with indexes on expressions. (check-in: e7771db6cc user: drh tags: trunk) | |
19:24 | More documentation on how PRAGMA index_info and PRAGMA index_xinfo handle indexes on expressions. (check-in: d9d337b927 user: drh tags: trunk) | |
Changes
Changes to pages/rbu.in.
︙ | ︙ | |||
93 94 95 96 97 98 99 | named "rbu_control".</p></li> <li><p>The RBU update will not fire any triggers.</p></li> <li><p>The RBU update will not detect or prevent foreign key or CHECK constraint violations.</p></li> <li><p>All RBU updates use the "OR ROLLBACK" constraint handling mechanism. </p></li> <li><p>The target database may not be in [WAL mode].</p></li> | | > > | 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 | named "rbu_control".</p></li> <li><p>The RBU update will not fire any triggers.</p></li> <li><p>The RBU update will not detect or prevent foreign key or CHECK constraint violations.</p></li> <li><p>All RBU updates use the "OR ROLLBACK" constraint handling mechanism. </p></li> <li><p>The target database may not be in [WAL mode].</p></li> <li><p><s>The target database may not contain [indexes on expressions].</s> Indexes on expressions are supported beginning with SQLite 3.30.0 ([dateof:3.30.0]). <li><p>No other writes may occur on the target database while the RBU update is being applied. A read-lock is held on the target database to prevent this.</p></li> </ul> <h2>Preparing an RBU Update File</h2> |
︙ | ︙ |