Documentation Source Text

Check-in [77c08efc0e]
Login

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

Overview
Comment:Update the change log for the unlocked-recovery enhancement.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 77c08efc0ec60d89d5f46f3d29264250e5635c08fad5c778c80c99dfc97274b9
User & Date: drh 2020-07-28 17:30:16.883
Context
2020-07-28
19:39
Update the size-and-speed spreadsheet. (check-in: 1c1f5f5f3b user: drh tags: trunk)
17:30
Update the change log for the unlocked-recovery enhancement. (check-in: 77c08efc0e user: drh tags: trunk)
2020-07-26
16:11
Merge branch-3.32 fixed into trunk. (check-in: ace42c454f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
49
50
51
52
53
54
55




56
57
58
59
60
61
62
     <li> Do a better job of
          detecting missing, incomplete, and/or dodgy [sqlite_stat1]
          data and generates good query plans in spite of the
          misinformation.
     <li> Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)"
          assuming an index on t(x,y).
     </ol>




}

chng {2020-06-18 (3.32.3)} {
<li> Various minor bug fixes including fixes for tickets
     [https://www.sqlite.org/src/info/8f157e8010b22af0|8f157e8010b22af0],
     [https://www.sqlite.org/src/info/9fb26d37cefaba40|9fb26d37cefaba40],
     [https://www.sqlite.org/src/info/e367f31901ea8700|e367f31901ea8700],







>
>
>
>







49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
     <li> Do a better job of
          detecting missing, incomplete, and/or dodgy [sqlite_stat1]
          data and generates good query plans in spite of the
          misinformation.
     <li> Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)"
          assuming an index on t(x,y).
     </ol>
<li> In [WAL mode], if a writer crashes and leaves the [shm file] in an inconsistent
     state, subsequent transactions are now able to recover the shm file even if
     there are active read transactions.  Before this enhancement, shm file recovery
     that scenario would result in an [SQLITE_PROTOCOL] error.
}

chng {2020-06-18 (3.32.3)} {
<li> Various minor bug fixes including fixes for tickets
     [https://www.sqlite.org/src/info/8f157e8010b22af0|8f157e8010b22af0],
     [https://www.sqlite.org/src/info/9fb26d37cefaba40|9fb26d37cefaba40],
     [https://www.sqlite.org/src/info/e367f31901ea8700|e367f31901ea8700],