/ Check-in [279ac7fd]
Login

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

Overview
Comment:Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 279ac7fdec0b1409cd400b7b093f89089d93c49f596f378c6a3032434a85bf83
User & Date: dan 2019-08-26 14:57:58
Context
2019-08-27
10:05
If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schema is detached, move the trigger to reference the TEMP schema before completing the detach, so that the trigger does not hold a dangling schema pointer. Ticket [ac8dd4a32ba4322f] check-in: 069c2f4c user: drh tags: trunk
2019-08-26
20:41
Merge in recent fixes from trunk. Closed-Leaf check-in: ad816d01 user: drh tags: nulls-last
14:57
Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. check-in: 279ac7fd user: dan tags: trunk
14:18
Improved detection of number of column mismatch for vector assignment in UPDATE statements. Ticket [78acc9d40f0786e8] check-in: bd4bda73 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/shell.c.in.

  6708   6708       "      SELECT 0, i, (SELECT pgno FROM recovery.dbptr WHERE child=i)"
  6709   6709       "        UNION "
  6710   6710       "      SELECT i, p.parent, "
  6711   6711       "        (SELECT pgno FROM recovery.dbptr WHERE child=p.parent) FROM p"
  6712   6712       "    )"
  6713   6713       "    SELECT pgno FROM p WHERE (parent IS NULL OR pgno = orig)"
  6714   6714       ") "
  6715         -    "FROM pages WHERE maxlen > 0 AND i NOT IN freelist;"
         6715  +    "FROM pages WHERE maxlen IS NOT NULL AND i NOT IN freelist;"
  6716   6716       "UPDATE recovery.map AS o SET intkey = ("
  6717   6717       "  SELECT substr(data, 1, 1)==X'0D' FROM sqlite_dbpage WHERE pgno=o.pgno"
  6718   6718       ");"
  6719   6719   
  6720   6720       /* Extract data from page 1 and any linked pages into table
  6721   6721       ** recovery.schema. With the same schema as an sqlite_master table.  */
  6722   6722       "CREATE TABLE recovery.schema(type, name, tbl_name, rootpage, sql);"