|
2014-07-30
| ||
| 11:49 | Merge all recent trunk changes, and especially the R-Tree IN operator fix of ticket [d2889096e7bdeac]. (check-in: 654c6c65 user: drh tags: apple-osx) | |
|
2014-07-29
| ||
| 12:53 | • Fixed ticket [d2889096]: Problem with rtree tables with IN() operators or as the inner loop of a join. plus 3 other changes (artifact: d17ac0ca user: drh) | |
| 12:40 | Merge recent trunk changes, and especially the fix for the R-Tree problem described in ticket [d2889096e7bdeac6]. (check-in: 8f1beead user: drh tags: sessions) | |
| 11:54 | Have calls to the xFilter() method of rtree virtual tables ensure that cursor is initialized before proceeding. Fix for [d2889096e7bdeac]. (check-in: 8cc41b0b user: dan tags: trunk) | |
| 11:18 | • Ticket [d2889096] Problem with rtree tables with IN() operators or as the inner loop of a join. status still Open with 6 other changes (artifact: c90fa76d user: dan) | |
| 11:15 | • New ticket [d2889096]. (artifact: f95aae06 user: dan) | |
| Ticket Hash: | d2889096e7bdeac6d2608a8040a0b67f28da6e75 | |||
| Title: | Problem with rtree tables with IN() operators or as the inner loop of a join. | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2014-07-29 12:53:17 | |||
| Version Found In: | 3.8.5 | |||
| User Comments: | ||||
|
dan added on 2014-07-29 11:15:09:
The following script returns a single row: CREATE VIRTUAL TABLE t3 USING rtree(Pid, xmin, xmax); INSERT INTO t3 VALUES(1,0,0); INSERT INTO t3 VALUES(2,0,0); SELECT * FROM t3 WHERE Pid IN (1, 2); But should return two. Introduced by [af2cbe64adab5f9e]. Bug first appeared in 3.8.5. dan added on 2014-07-29 11:18:12: Or the same problem using a join: WITH r(x) AS ( SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 ) SELECT * FROM r CROSS JOIN t3 WHERE Pid=x; | ||||