Problems with ORDER BY

2 views
Skip to first unread message

uli3480

unread,
Jun 30, 2009, 5:17:35 AM6/30/09
to OntoWiki User Discussion
Hi,

in the SPARQL Query Editor I made same queries and tried to order the
results using ORDER BY. Here is an example:

SELECT DISTINCT ?label ?classlabel
WHERE
{
?s mwmkis:stammtAus mwmkis:UKLeipzig2005.
?s rdfs:label ?label.
?s a ?class.
?class rdfs:label ?classlabel.
}
ORDER BY ?s LIMIT 200

When I use this query I get results. But when I say "ORDER BY ?label"
I get no results. Can anybody say me, why?

Thanks,
Uli

Michael Martin

unread,
Jun 30, 2009, 7:04:35 AM6/30/09
to ontowi...@googlegroups.com

Hi Uli,

yes this is really a bug, which i can reproduce with ZendDb Backend. Or did you use also other backends like virtuoso for testing.

the query
SELECT DISTINCT ?s ?l
WHERE
{
 ?s ?p ?l
}
ORDER BY ?l
LIMIT 20
is also returning a really different resultset like ordering by ?s or ?p

i will create an issue.

All the best and thank you for reporting this bug.
Micha



2009/6/30 uli3480 <uli...@googlemail.com>

uli3480

unread,
Jun 30, 2009, 7:09:19 AM6/30/09
to OntoWiki User Discussion
Hi Micha,

thanks for your answer.

> yes this is really a bug, which i can reproduce with ZendDb Backend. Or did
> you use also other backends like virtuoso for testing.

I guess, I also use the ZendDB, I have a normal installation with a
MySQL database.

Bye,
Uli

uli3480

unread,
Jun 30, 2009, 8:07:08 AM6/30/09
to OntoWiki User Discussion
Hi Micha,

thanks for your answer.

> yes this is really a bug, which i can reproduce with ZendDb Backend. Or did
> you use also other backends like virtuoso for testing.

Reply all
Reply to author
Forward
0 new messages