Documentation Source Text

Check-in [237bf9365d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Include "OR ROLLBACK" among the examples of how to omit statement journals.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 237bf9365d134351bc2609229dd27b4376fdeba2
User & Date: drh 2016-02-27 14:20:37
Context
2016-03-02
13:16
Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. check-in: d4c54c7ebe user: drh tags: trunk
2016-02-27
14:20
Include "OR ROLLBACK" among the examples of how to omit statement journals. check-in: 237bf9365d user: drh tags: trunk
2016-02-26
15:54
Updated documentation related to fts3_tokenizer() and the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. check-in: 1483127f32 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/tempfiles.in.

282
283
284
285
286
287
288

289
290
291

292
293
294
295
296
297
298
used.  For example:
</p>

<blockquote><pre>
UPDATE OR FAIL ...
UPDATE OR IGNORE ...
UPDATE OR REPLACE ...

INSERT OR FAIL ...
INSERT OR IGNORE ...
INSERT OR REPLACE ...

REPLACE INTO ....
</pre></blockquote>

<p>
The statement journal is given a randomized name, not necessarily
in the same directory as the main database, and is automatically
deleted at the conclusion of the transaction.  The size of the







>



>







282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
used.  For example:
</p>

<blockquote><pre>
UPDATE OR FAIL ...
UPDATE OR IGNORE ...
UPDATE OR REPLACE ...
UPDATE OR ROLLBACK ...
INSERT OR FAIL ...
INSERT OR IGNORE ...
INSERT OR REPLACE ...
INSERT OR ROLLBACK ...
REPLACE INTO ....
</pre></blockquote>

<p>
The statement journal is given a randomized name, not necessarily
in the same directory as the main database, and is automatically
deleted at the conclusion of the transaction.  The size of the