Documentation Source Text

Check-in [e7771db6cc]
Login

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: e7771db6ccec2df627a019cd22e308504cc8a52b5cf72d7bf05ea7b9d683c601
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
Unified Diff Ignore Whitespace Patch
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>