HughWilliams
commented
9 years ago @pbellini: Is this a public dataset you are querying, which can be setup locally to recreate ?
We do have previous reports of this error which is to be looked into by development ...
pbellini
On virtuoso-opensource 07.20.3213 built from develop/7 the query:
PREFIX km4c:http://www.disit.org/km4city/schema# select count(*) where { ?s a km4c:Hotel. ?s geo:geometry ?geo filter(bif:st_intersects (?geo, bif:st_point (11.24926507472992,43.77551354191501), 3.7)) }
gives error "Virtuoso S0002 Error SQ200: No table rdf_obj" while if I change the third st_intersects parameter from 3.7km to 3.6km it returns a result.
The explain funtion with 3.7km (not working) returns: { { fork RDF_QUAD_POGS 5.2e+03 rows(t1.S) P = ##type , O = ##Hotel RDF_QUAD 0.0074 rows(t3.O) inlined P = ##geometry , S = t1.S
Precode: 0: ro_id := Call ro_digest_id (t3.O) 5: BReturn 0 geo 3 st_intersects (<tag 238 c POINT(11.24926507473 43.775513541915)>) node on DB.DBA.RDF_GEO 0.0073 rows ro_id geo prec: 3.7
After code: 0: sum callret-0 1 set no set_ctr 5: BReturn 0 } skip node 1000 set_ctr
Select (callret-0)
}
while with a radius of 3.6km (working) explain returns: { { hash filler geo 3 st_intersects (<tag 238 c POINT(11.24926507473 43.775513541915)>) node on DB.DBA.RDF_GEO 0.0026 rows t3.O geo prec: 3.6 RDF_QUAD_POGS 6.2e+03 rows(t3.S) P = ##geometry , O = cast Sort hf 44 (t3.S) } { fork RDF_QUAD_POGS 5.2e+03 rows(t1.S) P = ##type , O = ##Hotel hash partition+bloom by 48 (tmp)hash join merged if unique card 0.0026 -> () Hash source 44 0.0026 rows(t1.S) -> ()
After code: 0: sum callret-0 1 set no set_ctr 5: BReturn 0 } skip node 1000 set_ctr
Select (callret-0)
}
The cardinalities are: 5238 Hotel 1924677 geo:geometry 83299 geo:geometry within 3.7km 81521 geo:geometry within 3.6km