Issue Details (XML | Word | Printable)

Key: RDBMS-62
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JPOX RDBMS (ARCHIVED)

JPQL : Support IN

Created: 09/Dec/07 11:18 AM   Updated: 08/Jan/09 11:26 AM   Resolved: 14/Jan/08 12:57 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 1.2.0-rc-1


 Description  « Hide
From JPA spec 4.6.8 :-

The syntax for the use of the comparison operator [NOT] IN in a conditional expression is as follows:
in_expression ::= state_field_path_expression [NOT] IN ( in_item {, in_item}* | subquery)
in_item ::= literal | input_parameter

The state_field_path_expression must have a string, numeric, or enum value. The literal and/or input_parameter values must be like the same abstract schema type of the state_field_path_expression in type. (See Section 4.12). The results of the subquery must be like the same abstract schema type of the state_field_path_expression in type. Subqueries are discussed in Section 4.6.15, "Subqueries".


Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 09/Dec/07 09:32 PM
SVN trunk supports "[NOT] IN (literal{,literal})" syntax, and 4 more JPA TCK tests pass

Andy Jefferson added a comment - 14/Jan/08 12:57 PM
SVN trunk supports
FROM clause : IN(...) AS ...
WHERE/HAVING clause : ... IN(in_item [,in_item]) with in_item a literal or parameter