Overview
| Artifact ID: | 65efc0ddbb746e77bca3e98445f70ae8468d4160ec677a7a71a1f79b3f46df44 |
|---|---|
| Ticket: | b41031ea2b5372378cb3d2d43cf9fe2a4a5c2510
ALTER TABLE returns an error on certain schemas |
| User & Date: | drh 2018-09-16 20:03:33 |
Changes
- foundin changed to: "3.25.0"
- icomment:
The newly enhanced ALTER TABLE in SQLite 3.25.0 hits an assertion fault when there are operations on an rtree virtual table in the body of the trigger. <blockquote><verbatim> CREATE TABLE t1(a INTEGER PRIMARY KEY, b); CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1); CREATE TRIGGER r1 AFTER UPDATE ON t1 BEGIN DELETE FROM t2 WHERE id = OLD.a; END; ALTER TABLE t1 RENAME TO t3; </verbatim></blockquote>
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Severe"
- status changed to: "Open"
- title changed to: "Assertion fault on ALTER TABLE"
- type changed to: "Code_Defect"