nakijun / qspatialite

Automatically exported from code.google.com/p/qspatialite
0 stars 0 forks source link

no such function: RTreeintersects #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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 lhosti...@gmail.com on 23 Dec 2014 at 3:18

GoogleCodeExporter commented 9 years ago
Hi,
What version of SpatiaLite are you using ?

Original comment by romain.r...@gmail.com on 6 Feb 2015 at 7:55