Issue Details (XML | Word | Printable)

Key: NUCCORE-456
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.
DataNucleus Core

Generic compile of JPQL "Case" expressions

Created: 31/Jan/10 10:42 AM   Updated: 26/Apr/10 03:37 PM   Resolved: 05/Apr/10 11:23 AM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 2.1.0.m2


 Description  « Hide
4.6.17.3 Case Expressions
The following forms of case expressions are supported: general case expressions, simple case expressions, coalesce expressions, and nullif expressions.

case_expression::=
general_case_expression |
simple_case_expression |
coalesce_expression |
nullif_expression

general_case_expression::=
CASE when_clause {when_clause}* ELSE scalar_expression END
when_clause::= WHEN conditional_expression THEN scalar_expression

simple_case_expression::=
CASE case_operand simple_when_clause {simple_when_clause}*
ELSE scalar_expression
END
case_operand::= state_field_path_expression | type_discriminator
simple_when_clause::= WHEN scalar_expression THEN scalar_expression


Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 01/Apr/10 10:42 AM
Required by 2.1 completion for JPA TCK

Andy Jefferson added a comment - 05/Apr/10 11:23 AM
SVN trunk now handles the generic compile of JPQL CASE expressions