| 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 | |||
| Description: | ||||
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: | ||||