Ticket Hash: | acd12990885d927645a036e0acda6abf3d88ce4b | |||
Title: | CREATE TABLE AS fails with a false report of database corruption | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Important | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2015-09-09 13:28:24 | |||
Version Found In: | 3.8.11.1 | |||
User Comments: | ||||
drh added on 2015-09-09 12:34:14:
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. |