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

[Gustavo Fernandes (JIRA)]

Gustavo Fernandes created ISPN-8483:
---------------------------------------

             Summary: 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
    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)