/ Ticket Change Details
Login
Overview

Artifact ID: 16828871e712007d5be8980bee49eeeb085f4d86
Ticket: acd12990885d927645a036e0acda6abf3d88ce4b
CREATE TABLE AS fails with a false report of database corruption
User & Date: drh 2015-09-09 12:34:14
Changes

  1. foundin changed to: "3.8.11.1"
  2. icomment:
    The second statement in the following script reports an SQLITE_CORRUPT error:
    
    <blockquote><verbatim>
    CREATE TABLE t1(a);
    CREATE TABLE t2 AS SELECT name FROM sqlite_master;
    </verbatim></blockquote>
    
    The database is not actually corrupt.  This is a malfunction in the CREATE TABLE AS statement.
    
    Bisecting indicates that this problem was introduced by check-in
    [972881c6d3] on [2013-11-21], first released with version 3.8.2.
    
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Important"
  6. status changed to: "Open"
  7. title changed to:
    CREATE TABLE AS fails with a false report of database corruption
    
  8. type changed to: "Code_Defect"