[DELTASPIKE-1242] select distinct generates wrong JPQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.2
• Fix Version/s: 1.8.0
• Component/s: Data-Module
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 12/Apr/17 21:35
• Updated: 30/Dec/17 14:53
• Resolved: 13/Apr/17 16:27

Description

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.