Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
20f06bf2e659212a68dcf138e444da7b |
| User & Date: | dan 2019-05-09 16:57:39 |
Context
|
2019-05-09
| ||
| 17:10 | Disable the optimization where a REAL value with no fractional part is stored as an INTEGER when the integer uses as much space as the real value it proposes to stand in for (8 bytes). This avoids corner cases of comparing integers against real values that are beyond the resolution of an IEEE 754 double. Fix for ticket [6c1d3febc00b22d457c78c2] (check-in: 9b091527 user: drh tags: trunk) | |
| 16:57 | Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. (check-in: 20f06bf2 user: dan tags: trunk) | |
| 16:22 | Improved debugging output from the OP_MakeRecord opcode. (check-in: ac790729 user: drh tags: trunk) | |
Changes
Changes to src/shell.c.in.
6575 6575 " WHERE x>0" 6576 6576 " UNION" 6577 6577 " SELECT shell_int32(" 6578 6578 " (SELECT data FROM sqlite_dbpage WHERE pgno=trunk.pgno), 0) AS x " 6579 6579 " FROM trunk WHERE x>0" 6580 6580 ")," 6581 6581 "freelist(data, n, freepgno) AS (" 6582 - " SELECT data, shell_int32(data, 1)-1, t.pgno " 6582 + " SELECT data, min(16384, shell_int32(data, 1)-1), t.pgno " 6583 6583 " FROM trunk t, sqlite_dbpage s WHERE s.pgno=t.pgno" 6584 6584 " UNION ALL" 6585 6585 " SELECT data, n-1, shell_int32(data, 2+n) " 6586 6586 " FROM freelist WHERE n>=0" 6587 6587 ")" 6588 6588 "REPLACE INTO recovery.freelist SELECT freepgno FROM freelist;" 6589 6589 );