]
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}