/ 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:
    
    <pre>
    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
    </pre>
    
    Is this expected? The documentation mentions that the <i>ROLLBACK</i> statement cannot be used with <i>journal_mode=OFF</i>, 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"