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. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
e7771db6ccec2df627a019cd22e30850 |
| User & Date: | drh 2019-09-26 19:34:22 |
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 100 101 102 103 104 105 106 107 |
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>The target database may not contain [indexes on expressions].
<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>
|
| > > |
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>
|