no such function: RTreeintersects

[GoogleCodeExporter]

What steps will reproduce the problem?
1. import two tables in QSpatilaite
2. create spatial indexes 
select createspatialindex(  'GeoSirene_2006_27561' ,'geometry' )
select createspatialindex( 'Communes_pm_recues','geometry' )
3. trying to use an RTree in an SQL query
select 
 s.'FID',
 c.'NOM_COMM' 
from  "GeoSirene_2006_27561" as s
join  "Communes_pm_recues" as c on (
st_intersects(s.geometry, c.geometry)
) and s.'PKUID'  in (
select  'pkid' 
from "idx_Communes_pm_recues_Geometry"
where  'pkid' match RTreeintersects (
        MbrMinX(s.geometry),
        MbrMinY(s.geometry),
        MbrMaxX(s.geometry),
        MbrMaxY(s.geometry)))

4. run SQL

What is the expected output? What do you see instead?
an error message 
The SQL query seems to be invalid.
no such function: RTreeintersects


What version of the product are you using? On what operating system?
QSpatialite V7
QGIS 2.6
Ubuntu 14.04

Please provide any additional information below.

Original issue reported on code.google.com by [email protected] on 23 Dec 2014 at 3:18

[GoogleCodeExporter]

Hi,
What version of SpatiaLite are you using ?

Original comment by [email protected] on 6 Feb 2015 at 7:55

• Changed state: Accepted