Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 314026

Summary:	groupBy ignored in criteria
Product:	z_Archived	Reporter:	lethalman88
Component:	Eclipselink	Assignee:	Nobody - feel free to take it <nobody>
Status:	CLOSED WORKSFORME	QA Contact:
Severity:	normal
Priority:	P3	CC:	gordon.yorke, tom.ware
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Linux
Whiteboard:

Description lethalman88

2010-05-22 17:53:48 EDT

Build Identifier: 

Hello,
I'm using eclipselink in glassfishv3, the latest 2.2 version. I'm creating a query using the CriteriaBuilder and CriteriaQuery from within a container managed stateless session bean. The query has also a subquery (I don't know if this is relevant).
Problem: CriteriaQuery.groupBy(...) is called but completely ignored. I'm logging the SQL queries and I see no GROUP BY clause. Is groupBy() supposed to work in eclipselink?
I've searched the BTS and Internet with no luck, I couldn't even find an groupBy() example.

Reproducible: Always

Steps to Reproduce:
1. Create a CriteriaBuilder.
2. Create a CriteriaQuery.
3. Use groupBy()
4. GROUP BY not generated

Comment 1 Gordon Yorke

2010-05-27 09:18:43 EDT

Can you please post your test code?  We have tests that test our groupby support in CriteriaQueries and they continue to succeed.

Comment 2 lethalman88

2010-05-29 18:05:40 EDT

(In reply to comment #1)
> Can you please post your test code?  We have tests that test our groupby
> support in CriteriaQueries and they continue to succeed.

Thanks for your help.

I've tried with a more simple test case (count + group by an attribute) and it works (I see the GROUP BY in the logs). With my real case (a bit complicated to extract a test case) it does not. What are the cases where .groupBy() is not supposed to work (or ignored)? Maybe some error report is missing?

Comment 3 Tom Ware

2010-06-07 14:35:16 EDT

Closing as worksforme.  Please reopen if you can provide code that allows us to recreate the problem.

Comment 4 Eclipse Webmaster

2022-06-09 10:31:17 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink