Details
-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
9.2.0.Alpha2
-
None
Description
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:
select count(c.name), c.wiki.place_of_birth from Character c group by c.wiki.place_of_birth
results in
ISPN014026: The expression 'wiki.place_of_birth' must be part of an aggregate function or it should be included in the GROUP BY clause