[CAY-2031] Fetching distinct related objects in EJBQL throws an exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.M2
• Fix Version/s: 4.0.B2
• Component/s: Core Library
• Environment: Java 1.8.0_45 running on OS X
• Assignee: Nikita Timofeev
• Reporter: Hugi Thordarson
• Created: 23/Sep/15 07:40
• Updated: 29/Mar/18 08:25
• Resolved: 29/Mar/18 08:25

Description

Retrieving a list of distinct related objects in EJBQL using the following syntax fails:

"select distinct receipt.shop from Receipt receipt”

Stack trace:
https://gist.github.com/hugith/c3f48c4576e6a55383b3

Same query works fine without the "distinct" keyword.
Same query works fine if you specify an attribute on "shop" (not just the related object).

Issue Links

• relates to: CAY-2037 EJBQL: COUNT(DISTINCT .. ) doesn't properly translate paths ending with relationship