[OPENJPA-491] JPQL extension: scalar functions in GROUP BY

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0, 0.9.6, 0.9.7, 1.0.0, 1.0.1
• Fix Version/s: 1.1.0
• Assignee: Unassigned
• Reporter: Patrick Linskey
• Created: 16/Jan/08 02:23
• Updated: 09/Mar/10 18:32
• Resolved: 16/Jan/08 07:32

Description

JPQL does not allow scalar functions to be used in GROUP BY clauses. This can be useful. Example:

select substring(o.stringField, 1, 1), count(o) from AllFieldTypes o
group by substring(o.stringField, 1, 1)