OLD | NEW |
| (Empty) |
1 *** Throughout this document, a page is deemed to have been synced | |
2 automatically as soon as it is written when PRAGMA synchronous=OFF. | |
3 Otherwise, the page is not synced until the xSync method of the VFS | |
4 is called successfully on the file containing the page. | |
5 | |
6 *** Definition: A page of the database file is said to be "overwriteable" if | |
7 one or more of the following are true about the page: | |
8 | |
9 (a) The original content of the page as it was at the beginning of | |
10 the transaction has been written into the rollback journal and | |
11 synced. | |
12 | |
13 (b) The page was a freelist leaf page at the start of the transaction. | |
14 | |
15 (c) The page number is greater than the largest page that existed in | |
16 the database file at the start of the transaction. | |
17 | |
18 (1) A page of the database file is never overwritten unless one of the | |
19 following are true: | |
20 | |
21 (a) The page and all other pages on the same sector are overwriteable. | |
22 | |
23 (b) The atomic page write optimization is enabled, and the entire | |
24 transaction other than the update of the transaction sequence | |
25 number consists of a single page change. | |
26 | |
27 (2) The content of a page written into the rollback journal exactly matches | |
28 both the content in the database when the rollback journal was written | |
29 and the content in the database at the beginning of the current | |
30 transaction. | |
31 | |
32 (3) Writes to the database file are an integer multiple of the page size | |
33 in length and are aligned to a page boundary. | |
34 | |
35 (4) Reads from the database file are either aligned on a page boundary and | |
36 an integer multiple of the page size in length or are taken from the | |
37 first 100 bytes of the database file. | |
38 | |
39 (5) All writes to the database file are synced prior to the rollback journal | |
40 being deleted, truncated, or zeroed. | |
41 | |
42 (6) If a master journal file is used, then all writes to the database file | |
43 are synced prior to the master journal being deleted. | |
44 | |
45 *** Definition: Two databases (or the same database at two points it time) | |
46 are said to be "logically equivalent" if they give the same answer to | |
47 all queries. Note in particular the content of freelist leaf | |
48 pages can be changed arbitarily without effecting the logical equivalence | |
49 of the database. | |
50 | |
51 (7) At any time, if any subset, including the empty set and the total set, | |
52 of the unsynced changes to a rollback journal are removed and the | |
53 journal is rolled back, the resulting database file will be logical | |
54 equivalent to the database file at the beginning of the transaction. | |
55 | |
56 (8) When a transaction is rolled back, the xTruncate method of the VFS | |
57 is called to restore the database file to the same size it was at | |
58 the beginning of the transaction. (In some VFSes, the xTruncate | |
59 method is a no-op, but that does not change the fact the SQLite will | |
60 invoke it.) | |
61 | |
62 (9) Whenever the database file is modified, at least one bit in the range | |
63 of bytes from 24 through 39 inclusive will be changed prior to releasing | |
64 the EXCLUSIVE lock. | |
65 | |
66 (10) The pattern of bits in bytes 24 through 39 shall not repeat in less | |
67 than one billion transactions. | |
68 | |
69 (11) A database file is well-formed at the beginning and at the conclusion | |
70 of every transaction. | |
71 | |
72 (12) An EXCLUSIVE lock must be held on the database file before making | |
73 any changes to the database file. | |
74 | |
75 (13) A SHARED lock must be held on the database file before reading any | |
76 content out of the database file. | |
OLD | NEW |