(text/x-fossil-wiki)
The following SQL causes an assertion fault while running sqlite3_prepare()
on the DELETE statement:
<blockquote><verbatim>
CREATE TABLE t1(x);
CREATE TABLE t2(y);
CREATE VIRTUAL TABLE t3 USING rtree(a,b,c);
CREATE TRIGGER t2del AFTER DELETE ON t2 WHEN (SELECT 1 from t1) BEGIN
DELETE FROM t3 WHERE a=old.y;
END;
DELETE FROM t2 WHERE y=1;
</verbatim></blockquote>
The problem appears to have been introduced by the addition of support
for WITHOUT ROWID tables in SQLite version 3.8.2, specifically on
check-in [c80e229dd9c1230a] on 2013-11-07.
|