Hi Frans,
This is a known issue reported with other geospatial queries and to be looked
into by development.
For your query can you please provide query profiles for both queries ie the
one that works and the one that does not, when run from isql using the “set
profile on” command as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 6 Jan 2015, at 12:41, Frans Knibbe | Geodan <frans.kni...@geodan.nl> wrote:
>
> Hello,
>
> I know support for geographical functions in Virtuoso is a work in progress,
> but I want to report the following issue anyway. Perhaps developers are
> unaware of the issue, or perhaps there is a fix available in the current
> version of Virtuoso (I use 7.10.3211).
>
> I notice that when I try to use st_within
> <http://docs.openlinksw.com/virtuoso/fn_st_within.html> with a search radius
> I get the error "Virtuoso 42000 Error SQ200: Stack Overflow in cost model"
> when the radius (prec parameter) gets below a certain threshold. This query
> runs well (on SPARQL endpoint http://lod.geodan.nl/sparql
> <http://lod.geodan.nl/sparql>) :
>
> prefix bag: <http://lod.geodan.nl/vocab/bag#>
> <http://lod.geodan.nl/vocab/bag#>
> select count(*)
> from <http://lod.geodan.nl/basisreg/bag/pand/>
> <http://lod.geodan.nl/basisreg/bag/pand/>
> from <http://lod.geodan.nl/basisreg/bag/verblijfsobject/>
> <http://lod.geodan.nl/basisreg/bag/verblijfsobject/>
> where {
> ?pandmutatie a bag:Pandmutatie .
> ?pandmutatie bag:geometrie ?geom .
> ?pandmutatie bag:pand ?pand .
> ?verblijfsobjectmutatie a bag:Verblijfsobjectmutatie .
> ?verblijfsobjectmutatie bag:pand ?pand .
> filter (bif:st_within(?geom, bif:st_point (4.91, 52.38), 0.002))
> }
>
> But when the radius is changed to 0.001 the query returns the "Stack Overflow
> in cost model" error.
>
> Regards,
> Frans
>
> Frans Knibbe
> Geodan
> President Kennedylaan 1
> 1079 MB Amsterdam (NL)
>
> T +31 (0)20 - 5711 347
> E frans.kni...@geodan.nl <mailto:frans.kni...@geodan.nl>
> www.geodan.nl <http://www.geodan.nl/> | disclaimer
> <http://www.geodan.nl/disclaimer>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now.
> http://goparallel.sourceforge.net_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
