Ticket #62 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Spatial function in ORDER BY is not evaluated/taken into account

Reported by: giannis Owned by: mple
Priority: major Milestone:
Component: evaluation Version:
Keywords: query translation Cc:

Description

Take this example query: (http://geo.linkedopendata.gr/public-transport-endpoint/)

SELECT ?region ?population
WHERE
{
?m rdf:type gag:Περιφέρεια .
?m gag:έχει_επίσημο_όνομα ?region .
?m gag:έχει_πληθυσμό ?population .
?m gag:έχει_γεωμετρία ?geo .
}
ORDER BY DESC(strdf:area(?geo)) LIMIT 1

No actual sorting occurs as the output is "ΠΕΡΙΦΕΡΕΙΑ ΘΕΣΣΑΛΙΑΣ" which is not true.

However, this alternative form works fine:

SELECT ?region ?population (strdf:area(?geo) as ?area)
WHERE
{
?m rdf:type gag:Περιφέρεια .
?m gag:έχει_επίσημο_όνομα ?region .
?m gag:έχει_πληθυσμό ?population .
?m gag:έχει_γεωμετρία ?geo .
}
ORDER BY DESC(?area)

Change History

comment:1 Changed 3 years ago by mple

  • Owner changed from pyravlos-team to mple
  • Status changed from new to assigned

comment:2 Changed 3 years ago by mple

  • Status changed from assigned to closed
  • Resolution set to fixed

Solved in changeset 1345:4b7dbc54ae9d

Note: See TracTickets for help on using tickets.