[infinispan-issues] [JBoss JIRA] (ISPN-8483) Error when grouping by property that is a path

[Gustavo Fernandes (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-8483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gustavo Fernandes updated ISPN-8483:
------------------------------------
    Component/s: Embedded Querying
                 Remote Querying


> Error when grouping by property that is a path
> ----------------------------------------------
>
>                 Key: ISPN-8483
>                 URL: https://issues.jboss.org/browse/ISPN-8483
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Embedded Querying, Remote Querying
>    Affects Versions: 9.2.0.Alpha2
>            Reporter: Gustavo Fernandes
>            Assignee: Adrian Nistor
>
> If the GROUP BY clause is done on fields of internal entities of the entity queried on, the query fails.
> Example, consider a 'Character' entity/message, which has an internal 'Wiki' message, both defined in protobuf. The following query:
> {code:sql}
>    select count(c.name), c.wiki.place_of_birth from Character c group by c.wiki.place_of_birth
> {code}
> results in 
> {noformat}
>    ISPN014026: The expression 'wiki.place_of_birth' must be part of an aggregate function or it 
>   should be included in the GROUP BY clause
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)