[JBoss JIRA] (ISPN-8483) Error when grouping by property that is a path
by Gustavo Fernandes (JIRA)
[ https://issues.jboss.org/browse/ISPN-8483?page=com.atlassian.jira.plugin.... ]
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)
6 years, 7 months
[JBoss JIRA] (ISPN-8482) Projection of enum field returns number instead of constant
by Gustavo Fernandes (JIRA)
Gustavo Fernandes created ISPN-8482:
---------------------------------------
Summary: Projection of enum field returns number instead of constant
Key: ISPN-8482
URL: https://issues.jboss.org/browse/ISPN-8482
Project: Infinispan
Issue Type: Bug
Components: Remote Querying
Affects Versions: 9.2.0.Alpha2
Reporter: Gustavo Fernandes
Assignee: Adrian Nistor
Consider the query below where Gender is mapped in protobuf as an {{enum}}:
{code:sql}
select p.gender, count(p.name) from Person p group by p.gender
{code}
The returned projection is numeric rather than MALE/FEMALE.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 7 months