SQLite: Check-in [20f06bf2]

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:	20f06bf2e659212a68dcf138e444da7bd4220548ec15a97cfd7eb82e028b3630
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

Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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       );