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
- foundin changed to: "3.28"
- icomment:
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.
- login: "mrigger"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Minor"
- status changed to: "Open"
- title changed to:
Malformed image when using no journal mode, zero cache size, and failing when creating an index.
- type changed to: "Code_Defect"