I'm hitting a problem with Virtuoso 7 with the use of large filters
...... the scenario is that I'm setting a query variable value to be one
of many things ... rather than returning all values for that query variable
e.g. select ?yhing ?x ?y ?x where {?thing predicate1 ?x . ?thing
predicate2 ?y . ?thing predicate3 ?z filter (? thing =
<http://host/id/thing/1> || ?thing = <http://host/id/thing/2> || ?thing
= <http://host/id/thing/3> || ?thing = <http://host/id/thing/4> ||
?thing = <http://host/id/thing/5> || ....
there might be 100-200 things in the filter list ... but there may be
millions of instances of ?thing.
The error thrown is:
Virtuoso 37000 Error SQ156: Internal Optimized compiler error : unknown
table for a column dfe in sqldf.c:1422.
Please report the statement compiled.
SPARQL query:
Virtuoso 37000 Error SQ156: Internal Optimized compiler error : unknown
table for a column dfe in sqldf.c:1422.
Please report the statement compiled.
With trace_on() setup, it l;ooks like the filter is being truncated. Can
you try and replicate such a test case. It's important for my
application, as I'm using the OR filter pattern, as a way of delivering
data services of the form ... do a search to identify a set of things of
interest and then return lots of data about the items that have been
returned by the search ..... I'm open to suggestions of a workaround
tpo, if this is aknown problem, to be able to handle such a data pattern.
Ian
--
Ian Harrison Email: i...@big-data-analytics.com
Tel: +44 (0)7580 618125
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
