Re: Problem with MAX when no result expected

good morning; > On 2017-10-10, at 23:32, George News wrote: > > > On 2017-10-10 11:25, Rob Vesse wrote: >> Personally I am certain that Jena is correct in its interpretation of >> specification and that the specification is the appropriate. >> >> The key point here is

Re: Problem with MAX when no result expected

On 2017-10-10 11:25, Rob Vesse wrote: > Personally I am certain that Jena is correct in its interpretation of > specification and that the specification is the appropriate. > > The key point here is that any aggregation requires at least one group to > operate over, in the absence of a GROUP

Re: Problem with MAX when no result expected

On 2017-10-09 17:19, Andy Seaborne wrote: > > > On 09/10/17 15:27, George News wrote: >> On 2017-10-09 12:31, james anderson wrote: >>> good afternoon; On 2017-10-09, at 12:03, George News wrote: On 2017-10-09 11:53, Lorenz Buehmann wrote: > > >

Re: Problem with MAX when no result expected

Personally I am certain that Jena is correct in its interpretation of specification and that the specification is the appropriate. The key point here is that any aggregation requires at least one group to operate over, in the absence of a GROUP BY then there is an implicit group of all

Re: Problem with MAX when no result expected

On 09/10/17 15:27, George News wrote: On 2017-10-09 12:31, james anderson wrote: good afternoon; On 2017-10-09, at 12:03, George News wrote: On 2017-10-09 11:53, Lorenz Buehmann wrote: On 09.10.2017 10:22, George News wrote: Hi all, Here it goes. The MWE is below.

Re: Problem with MAX when no result expected

On 2017-10-09 12:31, james anderson wrote: > good afternoon; >> On 2017-10-09, at 12:03, George News wrote: >> >> On 2017-10-09 11:53, Lorenz Buehmann wrote: >>> >>> >>> On 09.10.2017 10:22, George News wrote: Hi all, Here it goes. The MWE is below.

Re: Problem with MAX when no result expected

good afternoon; > On 2017-10-09, at 12:03, George News wrote: > > On 2017-10-09 11:53, Lorenz Buehmann wrote: >> >> >> On 09.10.2017 10:22, George News wrote: >>> Hi all, >>> >>> Here it goes. The MWE is below. >>> >>> As you can see when I execute Q_without.rq I get an

Re: Problem with MAX when no result expected

On 2017-10-09 11:53, Lorenz Buehmann wrote: > > > On 09.10.2017 10:22, George News wrote: >> Hi all, >> >> Here it goes. The MWE is below. >> >> As you can see when I execute Q_without.rq I get an empty array in >> bindings. However with Qmax_without.rq I get {} (empty object) in >> bindings.

Re: Problem with MAX when no result expected

On 09.10.2017 10:22, George News wrote: > Hi all, > > Here it goes. The MWE is below. > > As you can see when I execute Q_without.rq I get an empty array in bindings. > However with Qmax_without.rq I get {} (empty object) in bindings. > > What I'm saying is that if I'm getting nothing when

Re: Problem with MAX when no result expected

Hi all, Here it goes. The MWE is below. As you can see when I execute Q_without.rq I get an empty array in bindings. However with Qmax_without.rq I get {} (empty object) in bindings. What I'm saying is that if I'm getting nothing when listing the matching entities, I don't know why I get an

Re: Problem with MAX when no result expected

On 2017-10-08 13:07, Lorenz B. wrote: > Hello George, > > right now it's really hard to help you. A complete query + sample data > is missing to reproduce it. In addition, the second query seems to be an > invalid SPARQL query - at least I don't see grouping by ?id and the > other values are not

Re: Problem with MAX when no result expected

On 2017-10-08 11:18, Andy Seaborne wrote: > Please - a complete, verifiable, minimal example. I will try to compile one simple :( > Complete query, small amount of data. > > Snippets remove details that may matter. > > With a complete, verifiable, minimal example we can agree on what the >

Re: Problem with MAX when no result expected

Hello George, right now it's really hard to help you. A complete query + sample data is missing to reproduce it. In addition, the second query seems to be an invalid SPARQL query - at least I don't see grouping by ?id and the other values are not aggregates. I don't think this is valid in

Re: Problem with MAX when no result expected

Please - a complete, verifiable, minimal example. Complete query, small amount of data. Snippets remove details that may matter. With a complete, verifiable, minimal example we can agree on what the question is. Indeed, it is not clear your output is even from Jena. The JSON formatting is

Re: Problem with MAX when no result expected

Hi, You answer just realized I committed an error while typing the question. I have just sent a good one. But from the answer below you confirm that the current Jena output is the desired behaviour. I still don't know why the aggregate for MAX or MIN returns one row in result. I will have to

Re: Problem with MAX when no result expected

Hi, Forget the last one. I've just realized again I included a mistake this is the good one (I hope ;)) # Case 1) select ?id ?value ?latitude ?longitude where { .. } -- { "head": { "vars": [ "id", "value", "latitude", "longitude" ] },

Re: Problem with MAX when no result expected

If there is an aggregation, you will get one row. SELECT (MAX(?x) AS ?M) { FILTER(false) } ==> (sparql --query Q.rq) - | M | = | | - which is: (sparql --query Q.rq --results json) { "head": { "vars": [ "M" ] } , "results": { "bindings": [ { } ] } }

Re: Problem with MAX when no result expected

Hi Andy, Now I understand the misunderstanding between you and me. The responses I included in my original mail where wrong :( Please accept my apologizes. These are the right query/responses: # Case 1) select ?id (MAX(?ti) as ?time) ?value ?latitude ?longitude where { .. }-- {

Re: Problem with MAX when no result expected

hasNext()? https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html#hasNext-- On Fri, Oct 6, 2017 at 1:26 PM, George News wrote: > On 2017-10-06 11:25, Andy Seaborne wrote: > > The two result sets you show both have one row, with bindings.

Re: Problem with MAX when no result expected

On 2017-10-06 11:25, Andy Seaborne wrote: > The two result sets you show both have one row, with bindings. That's > consistent with aggregation of nothing (no groups, or if no GROUP BY, no > results from the WHERE pattern. I don't see it the same way. The first one (without max) is an empty

Re: Problem with MAX when no result expected

The two result sets you show both have one row, with bindings. That's consistent with aggregation of nothing (no groups, or if no GROUP BY, no results from the WHERE pattern. MAX() of nothing is unbound but for any aggregation, there always is a row/ c.f. COUNT(*) is 0 when there are no

Problem with MAX when no result expected

Hi all, I am executing a SPARQL with MAX aggregate function and I'm facing a strange behaviour, or at least I think it is. The snipset of the select variables is the following: select ?id (MAX(?ti) as ?time) ?value ?latitude ?longitude where { .. } If I launch the SPARQL query and there