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
- foundin changed to: "3.8.11.1"
- 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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Important"
- status changed to: "Open"
- title changed to:
CREATE TABLE AS fails with a false report of database corruption
- type changed to: "Code_Defect"