[infinispan-issues] [JBoss JIRA] (ISPN-8483) Error when grouping by property that is a path
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)