Re: [Virtuoso-users] DISTINCT query problem

2010-11-22 Thread Hugh Williams
Hi Sören, The same query is actually being passed by PHP to the Virtuoso as I can see the query it receives using the trace_on('exec') call to enable tracing of SQL stmts in Virtuoso: sparql SELECT DISTINCT ?o FROM WHERE {?s a ?o} What I do also see in the Virtuos

Re: [Virtuoso-users] DISTINCT query problem

2010-11-22 Thread Sören Auer
Thanks Hugh for the quick reply! Its quite weired, that the PHP odbc drive has such side-effects - I thought the odbc client just forwards the query to the server and makes the results it obtains from there available. I somehow found a workaround last night - simply also selecting COUNT(*) s

Re: [Virtuoso-users] DISTINCT query problem

2010-11-22 Thread Hugh Williams
Hi Sören, I have installed the 1M BSBM data into a 64bit Windows Virtuoso 6.2 instance and querying via the Conductor , isql or ODBC Directly I get the same 159 distinct rows returned: $ /opt/virtuoso/bin/isql opluswinbuild: Connected to OpenLink Virtuoso Driver: 06.02.3128 OpenLink Virtuos

[Virtuoso-users] DISTINCT query problem

2010-11-21 Thread Sören Auer
Hi all, I have a problem with a SPARQL query using the DISTINCT feature. I installed the commercial Virtuoso 6.2 distribution for Windows. In order to run some experiments, I loaded the 1M BSBM data [1]. When I run the following query in conductor I get the correct results: SELECT DISTINCT ?o F