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

Bug 367593

Summary:	JPA Problem: The left parenthesis is missing from the IN expression. (but there's NO right either!)
Product:	[WebTools] Dali JPA Tools	Reporter:	elhanan Maayan <elh.mailgate>
Component:	JPA	Assignee:	Pascal Filion <pascal.filion>
Status:	RESOLVED FIXED	QA Contact:
Severity:	major
Priority:	P2	CC:	ari1meyer, kwutzke, neil.hauge
Version:	3.0.1
Target Milestone:	3.0.2
Hardware:	PC
OS:	Windows XP
Whiteboard:
Bug Depends on:	367656
Bug Blocks:

Description elhanan Maayan

2011-12-28 03:59:42 EST

consider this named query:
SELECT R FROM ApplicationRole R JOIN R.groupRoles G WHERE G.id.organizationGroup.name IN :groups

why should there be any brackets?

Comment 1 Pascal Filion

2012-01-17 15:27:02 EST

Base bug has been checked in, once Eclipse JEE picks up EclipseLink 2.3.3, then this bug will not be seen in Dali.

Comment 2 Pascal Filion

2012-03-30 14:23:26 EDT

*** Bug 375676 has been marked as a duplicate of this bug. ***

Comment 3 Karsten Wutzke

2017-05-30 09:31:29 EDT

This bug is *NOT* fixed. In the latest Eclipse Neon, a query of the form

[code]
SELECT we 
FROM Whatever we
  JOIN we.trade trd
  JOIN we.whateverType wet
WHERE trd.partnerId = :partnerId AND we.whateverType.id IN :whateverTypeIds
ORDER BY we.whateverType.id
[/code]
is still being validated with an Error/Warning

See forum: https://www.eclipse.org/forums/index.php/t/1086491/

Comment 4 Karsten Wutzke

2017-05-30 10:39:41 EDT

Note that we use JPA 1.0 Project Facet, but as to what I see when changing the project facet to anything JPA 2.x is validates the IN expression, but using any JPA 1.0 Facet and library configuration, this fails to validate, even though using parentheses with IN expressions was even wrong in JPA 1.0.

https://stackoverflow.com/q/1557085/396732