[
https://issues.apache.org/jira/browse/DELTASPIKE-1242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Struberg resolved DELTASPIKE-1242.
---------------------------------------
Resolution: Fixed
Fix Version/s: 1.8.0
We now use select if there is only 1 result type, otherwise multiselect.
> select distinct generates wrong JPQL
> ------------------------------------
>
> Key: DELTASPIKE-1242
> URL: https://issues.apache.org/jira/browse/DELTASPIKE-1242
> Project: DeltaSpike
> Issue Type: Bug
> Components: Data-Module
> Affects Versions: 1.7.2
> Reporter: Mark Struberg
> Assignee: Mark Struberg
> Fix For: 1.8.0
>
>
> The Data module generateds brackets into a distinct JPQL statement
> Instead of
> {source}
> SELECT DISTINCT e.mycol from SomeEntity e
> {source}
> we currently generate:
> {source}
> SELECT DISTINCT(e.mycol) from SomeEntity e
> {source}
> But this is not correct according to the JPA spec. It also actually only
> works on Hibernate but fails on both EclipseLink (RI) and OpenJPA.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
