[jira] [Created] (DELTASPIKE-1242) select distinct generates wrong JPQL

[Mark Struberg (JIRA)]

Mark Struberg created DELTASPIKE-1242:
-----------------------------------------

             Summary: 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)