/ View Ticket
Login
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;