| Ticket Hash: | 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 15.36 years ago |
Created: |
2010-02-24 13:52:28 15.36 years ago |
| 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: | ||||