[jira] [Commented] (JENA-1507) GROUP BY and aggregates when there are no matching of the WHERE pattern.

2018-03-14 Thread ASF subversion and git services (JIRA) 

[ 
https://issues.apache.org/jira/browse/JENA-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16398716#comment-16398716
 ] 

ASF subversion and git services commented on JENA-1507:
---

Commit 65d4e11692bd55175f2f489d56526f3fbcb3e669 in jena's branch 
refs/heads/master from [~andy.seaborne]
[ https://git-wip-us.apache.org/repos/asf?p=jena.git;h=65d4e11 ]

JENA-1507: Merge commit 'refs/pull/382/head' of https://github.com/apache/jena

This closes #382.


> GROUP BY and aggregates when there are no matching of the WHERE pattern.
> 
>
> Key: JENA-1507
> URL: https://issues.apache.org/jira/browse/JENA-1507
> Project: Apache Jena
>  Issue Type: Bug
>  Components: ARQ
>Affects Versions: Jena 3.6.0
>Reporter: Andy Seaborne
>Assignee: Andy Seaborne
>Priority: Major
> Fix For: 3.7.0
>
>
> There are two bugs in ARQs handling of grouping when there are no results in 
> the WHERE clause.
> When there is a GROUP BY, the outcome should be no rows. 
>  * JENA-1487
>  * [users list 
> discussion|https://lists.apache.org/thread.html/72c2045e639c589880619443beafec5be963733e0f9f0887e134d467@%3Cusers.jena.apache.org%3E]
> When there is no GROUP BY, no aggregates, and no pattern match, the result 
> should be one row of no columns; when there is no GROUP BY, the result is 
> always one row.  It returns zero rows (v3.6.0 and before).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (JENA-1507) GROUP BY and aggregates when there are no matching of the WHERE pattern.

2018-03-14 Thread ASF GitHub Bot (JIRA) 

[ 
https://issues.apache.org/jira/browse/JENA-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16398718#comment-16398718
 ] 

ASF GitHub Bot commented on JENA-1507:
--

Github user asfgit closed the pull request at:

https://github.com/apache/jena/pull/382


> GROUP BY and aggregates when there are no matching of the WHERE pattern.
> 
>
> Key: JENA-1507
> URL: https://issues.apache.org/jira/browse/JENA-1507
> Project: Apache Jena
>  Issue Type: Bug
>  Components: ARQ
>Affects Versions: Jena 3.6.0
>Reporter: Andy Seaborne
>Assignee: Andy Seaborne
>Priority: Major
> Fix For: 3.7.0
>
>
> There are two bugs in ARQs handling of grouping when there are no results in 
> the WHERE clause.
> When there is a GROUP BY, the outcome should be no rows. 
>  * JENA-1487
>  * [users list 
> discussion|https://lists.apache.org/thread.html/72c2045e639c589880619443beafec5be963733e0f9f0887e134d467@%3Cusers.jena.apache.org%3E]
> When there is no GROUP BY, no aggregates, and no pattern match, the result 
> should be one row of no columns; when there is no GROUP BY, the result is 
> always one row.  It returns zero rows (v3.6.0 and before).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (JENA-1507) GROUP BY and aggregates when there are no matching of the WHERE pattern.

2018-03-14 Thread ASF subversion and git services (JIRA) 

[ 
https://issues.apache.org/jira/browse/JENA-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16398714#comment-16398714
 ] 

ASF subversion and git services commented on JENA-1507:
---

Commit 8a64ffeef483df37bcbd313ada28104a945d2027 in jena's branch 
refs/heads/master from [~andy.seaborne]
[ https://git-wip-us.apache.org/repos/asf?p=jena.git;h=8a64ffe ]

JENA-1507: No rows when no match if GROUP BY used


> GROUP BY and aggregates when there are no matching of the WHERE pattern.
> 
>
> Key: JENA-1507
> URL: https://issues.apache.org/jira/browse/JENA-1507
> Project: Apache Jena
>  Issue Type: Bug
>  Components: ARQ
>Affects Versions: Jena 3.6.0
>Reporter: Andy Seaborne
>Assignee: Andy Seaborne
>Priority: Major
> Fix For: 3.7.0
>
>
> There are two bugs in ARQs handling of grouping when there are no results in 
> the WHERE clause.
> When there is a GROUP BY, the outcome should be no rows. 
>  * JENA-1487
>  * [users list 
> discussion|https://lists.apache.org/thread.html/72c2045e639c589880619443beafec5be963733e0f9f0887e134d467@%3Cusers.jena.apache.org%3E]
> When there is no GROUP BY, no aggregates, and no pattern match, the result 
> should be one row of no columns; when there is no GROUP BY, the result is 
> always one row.  It returns zero rows (v3.6.0 and before).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (JENA-1507) GROUP BY and aggregates when there are no matching of the WHERE pattern.

2018-03-13 Thread ASF GitHub Bot (JIRA) 

[ 
https://issues.apache.org/jira/browse/JENA-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16397107#comment-16397107
 ] 

ASF GitHub Bot commented on JENA-1507:
--

GitHub user afs opened a pull request:

https://github.com/apache/jena/pull/382

JENA-1507: Fixes for aggregates when no WHERE match.

This includes the two commits of PR #381.

Commit 8a64ffee are the actual functional changes for JENA-1507.

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/afs/jena jena-1507_aggregates

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/jena/pull/382.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #382


commit eb3b9beda79d35347daea1925752306b4ef5911f
Author: Andy Seaborne 
Date:   2018-03-13T13:59:35Z

Remove test printing. Remove info warnings.

commit 459a2b88f5e9544e5ddcc9979914eb0dca14b0d7
Author: Andy Seaborne 
Date:   2018-03-13T14:00:06Z

Reformat

commit 8a64ffeef483df37bcbd313ada28104a945d2027
Author: Andy Seaborne 
Date:   2018-03-13T15:21:29Z

JENA-1507: No rows when no match if GROUP BY used




> GROUP BY and aggregates when there are no matching of the WHERE pattern.
> 
>
> Key: JENA-1507
> URL: https://issues.apache.org/jira/browse/JENA-1507
> Project: Apache Jena
>  Issue Type: Bug
>  Components: ARQ
>Affects Versions: Jena 3.6.0
>Reporter: Andy Seaborne
>Assignee: Andy Seaborne
>Priority: Major
>
> There are two bugs in ARQs handling of grouping when there are no results in 
> the WHERE clause.
> When there is a GROUP BY, the outcome should be no rows. 
>  * JENA-1487
>  * [users list 
> discussion|https://lists.apache.org/thread.html/72c2045e639c589880619443beafec5be963733e0f9f0887e134d467@%3Cusers.jena.apache.org%3E]
> When there is no GROUP BY, no aggregates, and no pattern match, the result 
> should be one row of no columns; when there is no GROUP BY, the result is 
> always one row.  It returns zero rows (v3.6.0 and before).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (JENA-1507) GROUP BY and aggregates when there are no matching of the WHERE pattern.

2018-03-13 Thread Andy Seaborne (JIRA) 

[ 
https://issues.apache.org/jira/browse/JENA-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16397081#comment-16397081
 ] 

Andy Seaborne commented on JENA-1507:
-

The SPARQL spec is wrong as well:

In the definition of "Group", 
[https://www.w3.org/TR/sparql11-query/#defn_algGroup]

If the pattern does not match, Ω is empty and so "Group(exprlist, Ω)" is the 
empty set ∅ because it says at the end "| μ in Ω }"; Ω is empty so there is 
for-each evaluation.

Once "Group(exprlist, Ω)" is the empty set, it is identical to "GROUP BY" and 
no match, ending up in no rows.

But, for example, COUNT(*) is supposed to be 0 in the single row. There is 
always a single row when there is no GROUP  BY, even if it is a row of no 
columns (no aggregate functions). (It is not possible to write  that in SPARQL 
- an aggregate is needed to trigger being all-one-group).

 

> GROUP BY and aggregates when there are no matching of the WHERE pattern.
> 
>
> Key: JENA-1507
> URL: https://issues.apache.org/jira/browse/JENA-1507
> Project: Apache Jena
>  Issue Type: Bug
>  Components: ARQ
>Affects Versions: Jena 3.6.0
>Reporter: Andy Seaborne
>Assignee: Andy Seaborne
>Priority: Major
>
> There are two bugs in ARQs handling of grouping when there are no results in 
> the WHERE clause.
> When there is a GROUP BY, the outcome should be no rows. 
>  * JENA-1487
>  * [users list 
> discussion|https://lists.apache.org/thread.html/72c2045e639c589880619443beafec5be963733e0f9f0887e134d467@%3Cusers.jena.apache.org%3E]
> When there is no GROUP BY, no aggregates, and no pattern match, the result 
> should be one row of no columns; when there is no GROUP BY, the result is 
> always one row.  It returns zero rows (v3.6.0 and before).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)