Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 367593 - JPA Problem: The left parenthesis is missing from the IN expression. (but there's NO right either!)
Summary: JPA Problem: The left parenthesis is missing from the IN expression. (but the...
Status: RESOLVED FIXED
Alias: None
Product: Dali JPA Tools
Classification: WebTools
Component: JPA (show other bugs)
Version: 3.0.1   Edit
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: 3.0.2   Edit
Assignee: Pascal Filion CLA
QA Contact:
URL:
Whiteboard:
Keywords:
: 375676 (view as bug list)
Depends on: 367656
Blocks:
  Show dependency tree
 
Reported: 2011-12-28 03:59 EST by elhanan Maayan CLA
Modified: 2017-05-30 10:39 EDT (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description elhanan Maayan CLA 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 CLA 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 CLA 2012-03-30 14:23:26 EDT 
*** Bug 375676 has been marked as a duplicate of this bug. ***
Comment 3 Karsten Wutzke CLA 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 CLA 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