Hi Francesco, I have been able to recreate this issue with the latest open source develop/7 build and reported to development to look into:
SQL> SPARQL PREFIX km4c:<http://www.disit.org/km4city/schema# <http://www.disit.org/km4city/schema#>> PREFIX foaf:<http://xmlns.com/foaf/0.1/ <http://xmlns.com/foaf/0.1/>> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns# <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> SELECT ?ride (MAX(?avmr) AS ?avmrLast) WHERE{ ?bs rdf:type km4c:BusStop. ?bs foaf:name "PIAZZA DI SAN MARCO". ?bsf km4c:isForecastOfBusStop ?bs. ?bsf km4c:isForecastOfAVM ?avmr. ?ride km4c:hasAVMRecord ?avmr. } GROUP BY ?ride ORDER BY DESC (?avmrLast) LIMIT 15; ride avmrLast LONG VARCHAR LONG VARCHAR _______________________________________________________________________________ http://www.disit.org/km4city/resource/4900006 <http://www.disit.org/km4city/resource/4900006> iri_id_0_with_no_name_entry 1 Rows. -- 8 msec. SQL> SPARQL PREFIX km4c:<http://www.disit.org/km4city/schema# <http://www.disit.org/km4city/schema#>> PREFIX foaf:<http://xmlns.com/foaf/0.1/ <http://xmlns.com/foaf/0.1/>> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns# <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> SELECT ?ride (?avmr AS ?avmrLast) WHERE{ ?bs rdf:type km4c:BusStop. ?bs foaf:name "PIAZZA DI SAN MARCO". ?bsf km4c:isForecastOfBusStop ?bs. ?bsf km4c:isForecastOfAVM ?avmr. ?ride km4c:hasAVMRecord ?avmr. } GROUP BY ?ride ORDER BY DESC (?avmrLast) LIMIT 15; ride avmrLast LONG VARCHAR LONG VARCHAR _______________________________________________________________________________ http://www.disit.org/km4city/resource/4900006 <http://www.disit.org/km4city/resource/4900006> http://www.disit.org/km4city/resource/2015-12-11T10:10:02.3500006+02:00+4900006 <http://www.disit.org/km4city/resource/2015-12-11T10:10:02.3500006+02:00+4900006> 1 Rows. -- 9 msec. SQL> status(''); REPORT VARCHAR _______________________________________________________________________________ OpenLink Virtuoso VDB Server Version 07.20.3214-pthreads for Linux as of Nov 5 2015 Registered to OpenLink Development (Internal Use Only) (Personal Edition, 500 connections) Started on: 2015-11-12 02:15 GMT+1 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ <http://www.openlinksw.com/> Weblog -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/> LinkedIn -- http://www.linkedin.com/company/openlink-software/ <http://www.linkedin.com/company/openlink-software/> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> Google+ -- http://plus.google.com/100570109519069333827/ <http://plus.google.com/100570109519069333827/> Facebook -- http://www.facebook.com/OpenLinkSoftware <http://www.facebook.com/OpenLinkSoftware> Universal Data Access, Integration, and Management Technology Providers > On 11 Nov 2015, at 18:09, Francesco Balzu <i_ba...@hotmail.it > <mailto:i_ba...@hotmail.it>> wrote: > > Excuse me if I submit again the same question, but it is important to me to > know where I am mistaken. > I have a problem with the MAX aggregate function in SPARQL. I provide the > data and the query that generates the wrong (according to me) result. The > query is slightly different from the one that I sent last time: this > recreates the issue, in my pc. > > The two graphs needed are at > https://www.dropbox.com/sh/fl1yzk98bg2de1r/AABoMoXSHYWZXqgi96I7URbca?dl=0 > <https://www.dropbox.com/sh/fl1yzk98bg2de1r/AABoMoXSHYWZXqgi96I7URbca?dl=0> > The file avm_dump_25K.ttl contains the graph > <http://localhost:8890/avm_quadStore_25K > <http://localhost:8890/avm_quadStore_25K>>, whereas the file > Autobus_lotto_metropolitano_f.ttl contains the graph < > http://www.disit.org/km4city/resource/Autobus/5_Lotto_Metropolitano_Firenze_f > <http://www.disit.org/km4city/resource/Autobus/5_Lotto_Metropolitano_Firenze_f>> > I load the two graphs into Virtuoso Quad Store > I run the following query: > > > PREFIX km4c:<http://www.disit.org/km4city/schema# > <http://www.disit.org/km4city/schema#>> > PREFIX foaf:<http://xmlns.com/foaf/0.1/ <http://xmlns.com/foaf/0.1/>> > PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns# > <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> > > SELECT ?ride (MAX(?avmr) AS ?avmrLast) > WHERE{ > ?bs rdf:type km4c:BusStop. > ?bs foaf:name "PIAZZA DI SAN MARCO". > ?bsf km4c:isForecastOfBusStop ?bs. > ?bsf km4c:isForecastOfAVM ?avmr. > ?ride km4c:hasAVMRecord ?avmr. > } > GROUP BY ?ride ORDER BY DESC (?avmrLast) LIMIT 15 > > > and I obtain as result > > > ride avmrLast > http://www.disit.org/km4city/resource/4900006 > <http://www.disit.org/km4city/resource/4900006> iri_id_0_with_no_name_entry > <http://localhost:8890/conductor/iri_id_0_with_no_name_entry> > > If I don't use MAX function, that is if I run > > > PREFIX km4c:<http://www.disit.org/km4city/schema# > <http://www.disit.org/km4city/schema#>> > PREFIX foaf:<http://xmlns.com/foaf/0.1/ <http://xmlns.com/foaf/0.1/>> > PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns# > <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> > > SELECT ?ride (?avmr AS ?avmrLast) > WHERE{ > ?bs rdf:type km4c:BusStop. > ?bs foaf:name "PIAZZA DI SAN MARCO". > ?bsf km4c:isForecastOfBusStop ?bs. > ?bsf km4c:isForecastOfAVM ?avmr. > ?ride km4c:hasAVMRecord ?avmr. > } > GROUP BY ?ride ORDER BY DESC (?avmrLast) LIMIT 15 > > I obtain > ride avmrLast > http://www.disit.org/km4city/resource/4900006 > <http://www.disit.org/km4city/resource/4900006> > http://www.disit.org/km4city/resource/2015-12-11T10:10:02.3500006+02:00+4900006 > > <http://www.disit.org/km4city/resource/2015-12-11T10:10:02.3500006+02:00+4900006> > > In this case the dataset is small and I get only one row as result, but in > general it may be much bigger and so I would need to use max function. > > Thanks for your precious help. > Best regards, > Francesco Balzano. > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > <mailto:Virtuoso-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users