/ Ticket Change Details
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Artifact ID: 1dabaa837c4910372cd891c6e7173b790603b97e6285b928f5756dd68006409b
Ticket: 8a6fa2bb22d7aa777920b055366a1f7261e6cf03
FTS order=DESC results into integrity-check failing
User & Date: mrigger 2019-10-10 21:47:35

  1. Change foundin to "3.30.0"
  2. Change icomment to:

    Consider the following test case:

    CREATE VIRTUAL TABLE vt0 USING fts4(c0, order=DESC);
    INSERT INTO vt0(c0) VALUES (0), (0);
    INSERT INTO vt0(vt0) VALUES('integrity-check'); database disk image is malformed

    Unexpectedly, the integrity-check results in an error "database disk image is malformed".

  3. Change login to "mrigger"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to:

    FTS order=DESC results into integrity-check failing

  8. Change type to "Code_Defect"