Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Freebase example query yields noncredible result #303

Closed
graue70 opened this issue Jan 9, 2020 · 1 comment
Closed

Freebase example query yields noncredible result #303

graue70 opened this issue Jan 9, 2020 · 1 comment

Comments

@graue70
Copy link
Contributor

graue70 commented Jan 9, 2020

Running the example query "Cities in Germany population latest" (see below) on http://qlever.informatik.uni-freiburg.de/Clueweb+Freebase yields a strange result. It seems to suggest that the population of the first 73 cities is identical with the value of 7124543962.

PREFIX fb: <http://rdf.freebase.com/ns/>
SELECT ?city_name ?latest ?population_value WHERE {
  {
    SELECT ?city (MAX(?date) as ?latest) WHERE {
	  ?city fb:type.object.type fb:location.citytown .
      ?city fb:location.location.containedby fb:m.0345h .
      ?city fb:location.statistical_region.population ?population .
      ?population fb:measurement_unit.dated_integer.year ?date .
    }
	GROUP BY ?city
  }
  ?population fb:measurement_unit.dated_integer.year ?latest .
  ?population fb:measurement_unit.dated_integer.number ?population_value .
  ?city fb:type.object.name ?city_name .
}
ORDER BY DESC(?population_value)
@hannahbast
Copy link
Member

The way subqueries are handled has been refactored and this bug no longer occurs.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants