A number of counting queries are wrong

[ian_hopkinson]

No description provided.

[ian_hopkinson]

Marco provided a fix for event_label_frequency_count, although it still doesn't appear to work properly

[ian_hopkinson]

1. actors_of_a_type 10 8 4 count good
2. actors_sharing_event_with_an_actor 1 0.5 count good
3. event_details_filtered_by_actor = count good
4. event_label_frequency_count = bad count
5. properties_of_a_type = count good
6. property_of_actors_of_a_type = count good
7. summary_of_events_with_actor = bad count
8. summary_of_events_with_event_label = count OK (off by 2 pages)
9. summary_of_events_with_two_actors = count OK (off by 2 pages)
10. types_of_actors = count good
11. summary_of_events_with_framenet = count bad
12. framenet_frequency_count = count bad

[ian_hopkinson]

Maybe this is why I think I have counting problems, I only get a maximum offset of 10,000 rows...

Subject Predicate   Object
<req:18poqvund> rdf:type    ksr:Invocation
<req:18poqvund> ksr:status  ksr:error_unexpected
<req:18poqvund> ksr:message java.io.IOException: Query evaluation failed after 84 ms Virtuoso 22023 Error SR353: Sorted TOP clause specifies more then 10020 rows to sort. Only 10000 are allowed. Either decrease the offset and/or row count or use a scrollable cursor SPARQL query: SELECT ?event (COUNT(*) AS ?event_size) ?datetime ?event_label WHERE { { SELECT DISTINCT ?event ?datetime ?event_label WHERE { ?event ; ?event_label ; ; ?t . ?t ?d ; ?datetimetmp . BIND (SUBSTR(?datetimetmp, 1, 10) AS ?datetime) FILTER (REGEX(?datetimetmp, "\\d{4}-\\d{2}")) } ORDER BY ASC(?datetime) OFFSET 10000 LIMIT 20 } ?event ?p ?o . } GROUP BY ?event ?datetime ?event_label ORDER BY ASC(?datetime), 86 ms

[ian_hopkinson]

Issues #67 and #69 are also about counting, I've closed them and I'll use this as the master "counting" problem issue.

[ian_hopkinson]

Currently all bit three queries pass the counting tests, for the three that fail the error is generally small and appears to be the result of our paging rather than an error with the query itself.