/ 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. Change foundin to "3.8.11.1"
  2. Change icomment to:

    The second statement in the following script reports an SQLITE_CORRUPT error:

    CREATE TABLE t1(a);
    CREATE TABLE t2 AS SELECT name FROM sqlite_master;
    

    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. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Important"
  6. Change status to "Open"
  7. Change title to:

    CREATE TABLE AS fails with a false report of database corruption

  8. Change type to "Code_Defect"