Hi !
I'm encountering a very strange error.
I have a query which works well with two different FILTER clauses, but when
I use both FILTER at the same time (simply combining them with AND), I get
the following error :
SQL error: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso
> Server]SQ200: Stack Overflow in cost model, SQL state 37000 in SQLExecDirect
You'll find the whole query below (as well as on
http://pastebin.com/CuBQk0xX ). I've been asking on irc #swig, and they
thought it may be a Virtuoso bug...
Virtuoso version (I need the dev version because of that "No table rdf_obj"
bug in stable) :
> Virtuoso Open Source Edition (Column Store) (multi threaded)
> Version 7.1.1-dev.3210-pthreads as of Jun 23 2014
> Compiled for Linux (x86_64-unknown-linux-gnu)
Is it indeed a bug ? Or am I doing something wrong ? Do you see a
workaround ?
Thanks a lot !
Olivier Dalang
---
Digital Humanities Lab (DHLAB) - http://dhlab.epfl.ch
EPFL CDH DHLAB / CM 2 271
Station 10 / CH-1015 Lausanne
Tel. +41 21 693 02 46
1. ##### THE FOLLOWING QUERY GIVES ME THIS ERROR :
2. # Warning: odbc_exec(): SQL error: [unixODBC][OpenLink][Virtuoso
iODBC Driver][Virtuoso Server]SQ200: Stack Overflow in cost model, SQL
state 37000 in SQLExecDirect in
/var/www/html/ontowiki-scripts/model_the_source-virtuoso_to_webmap.php on
line 20
3.
4. ##### BUT IT WORKS IF I COMMENT OUT (in the FILTER clause)
5. # AND
6. # bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(<?=$xmin?>
<?=$ymin?>, <?=$xmax?> <?=$ymax?>)") )
7.
8. ##### AND IT ALSO WORKS IF I COMMENT OUT (in the FILTER clause)
9. # ?min_zoom <= "<?=$zoom?>"^^xsd:integer
10. # AND
11. # ?max_zoom >= "<?=$zoom?>"^^xsd:integer
12. # AND
13.
14. ##### SO IT'S ONLY WHEN I COMBINE BOTH THAT I GET THE ERROR ?!?!
15.
16. PREFIX geo: <http://www.opengis.net/ont/geosparql#>
17. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
18. PREFIX : <http://dhlabpc2.epfl.ch/OntoWiki/vtm/#>
19.
20. SELECT *
21. FROM <http://dhlabpc2.epfl.ch/OntoWiki/vtm/>
22.
23. WHERE{
24. # select the entity
25. ?entity a ?class .
26.
27. # whose class is a subclass of :class_entity
28. ?class rdfs:subClassOf :class_entity .
29.
30. # get details for the subclass
31. ?class rdfs:label ?subclass_label .
32. ?class :zindex ?zindex .
33. ?class :min_zoom ?min_zoom .
34. ?class :max_zoom ?max_zoom .
35.
36. # that have a defined shape
37. ?entity :shape_defined_by ?geometry_defining_entity .
38. ?geometry_defining_entity geo:geometry ?geom .
39.
40. FILTER (
41. ?min_zoom <= 19
42. AND
43. ?max_zoom >= 19
44. AND
45. bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(12.3352
45.4382, 12.33521 45.43821)") )
46. )
47.
48. }
49. ORDER BY ?entity
50.
51. LIMIT 500
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
