Issue Details (XML | Word | Printable)

Key: NUCRDBMS-401
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 Store RDBMS

JPA2 : Support JPQL "INDEX"

Created: 28/May/10 08:46 AM   Updated: 11/Jun/10 01:38 PM   Resolved: 29/May/10 08:24 AM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 2.1.0.release


 Description  « Hide
JPA2 spec has
"INDEX(identification_variable)

The INDEX function returns an integer value corresponding to the position of its argument in an ordered list. The INDEX function can only be applied to identification variables denoting types for which an order column has been specified."

e.g
SELECT w.name
FROM Course c JOIN c.studentWaitlist w
WHERE c.name = 'Calculus'
AND INDEX(w) = 0

Andy Jefferson made changes - 28/May/10 08:48 AM
Field Original Value New Value
Description JPA2 spec has
"INDEX(identification_variable)

The INDEX function returns an integer value corresponding to the position of its argument in an ordered list. The INDEX function can only be applied to identification variables denoting types for which an order column has been specified."
JPA2 spec has
"INDEX(identification_variable)

The INDEX function returns an integer value corresponding to the position of its argument in an ordered list. The INDEX function can only be applied to identification variables denoting types for which an order column has been specified."

e.g
SELECT w.name
FROM Course c JOIN c.studentWaitlist w
WHERE c.name = 'Calculus'
AND INDEX(w) = 0
Andy Jefferson made changes - 28/May/10 10:52 AM
Summary Generic compilation : support compilation of JPQL "INDEX" JPA2 : Support JPQL "INDEX"
Andy Jefferson made changes - 28/May/10 10:52 AM
Project DataNucleus Core [ 10143 ] DataNucleus RDBMS [ 10144 ]
Key NUCCORE-537 NUCRDBMS-401
Component/s Queries [ 10142 ]
Component/s Queries [ 10154 ]
Andy Jefferson added a comment - 29/May/10 08:24 AM
SVN trunk now supports this

Andy Jefferson made changes - 29/May/10 08:24 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.1.0.release [ 10832 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 11/Jun/10 01:38 PM
Status Resolved [ 5 ] Closed [ 6 ]