/ Ticket Change Details
Login
Overview

Artifact ID: 7c7394890ca323c0989e4f72fc64a892b85ddccf08d8578114dd934f1ad133d9
Ticket: f4ec250930342e0c146bade2571c10f43085be34
Malformed image when using no journal mode, zero cache size, and failing when creating an index.
User & Date: mrigger 2019-05-17 12:48:17
Changes

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

    Consider the following example:

    PRAGMA journal_mode=OFF;
    PRAGMA main.cache_size=0;
    CREATE TABLE IF NOT EXISTS t0 (c0);
    CREATE INDEX i0 ON t0(1);
    DROP INDEX "i0";
    INSERT OR IGNORE INTO t0(c0) VALUES (1), (2);
    CREATE UNIQUE INDEX i0 ON t0(1); -- UNIQUE constraint failed: index 'i0'
    CREATE UNIQUE INDEX i0 ON t0(1); -- database disk image is malformed
    

    Is this expected? The documentation mentions that the ROLLBACK statement cannot be used with journal_mode=OFF, but it does not mention failed index creation.

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

    Malformed image when using no journal mode, zero cache size, and failing when creating an index.

  8. Change type to "Code_Defect"