SQLite
View Ticket
Not logged in
Ticket UUID: bc115541132dad13607e5cbdf1251f6f19e16f1e
Title: Assertion fault on a dodgy CREATE TABLE statement using WITHOUT ROWID
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-07-31 11:26:16
Version Found In:
User Comments:
drh added on 2017-07-30 18:25:00: (text/x-fossil-wiki)
The following SQL leads to an assertion fault:

<blockquote><verbatim>
CREATE TABLE t1(x INTEGER PRIMARY KEY UNIQUE, b) WITHOUT ROWID;
CREATE INDEX t1x ON t1(x);
</verbatim></blockquote>

This problem appears in all versions of SQLite that support WITHOUT ROWID
tables, which is to say all versions since 3.8.2 (2013-12-06).

This problem was discovered by [https://github.com/google/oss-fuzz|OSSFuzz].