/ View Ticket
Ticket UUID: d2f02d37f52bfe23e421f2c60fbb8586ac76ff01
Title: Assertion fault on UPDATE involving two virtual tables.
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2010-02-24 15:11:51
Version Found In: 3.6.22
In a shell that supports both FTS3 and RTREE, the UPDATE in the following code causes an assertion fault:
  CREATE VIRTUAL TABLE t1 USING rtree(id, x0, y0, x1, y1);
  CREATE VIRTUAL TABLE t2 USING fts3(title, content);
  UPDATE t2 SET docid=(SELECT id FROM t1 WHERE x0>:lower AND x1<:upper)
   WHERE t2 MATCH 'this is a test';

This problem was originally reported by Gunter Hick on the sqlite-users mailing list.

drh added on 2010-02-24 14:03:03:
The problem was introduced by check-in [f678ed34faab88f4e126e553119773386c7c84fa] on 2009-05-19.