[OPENJPA-1074] OrderColumn does not maintain index upon inter-list element removal - Phase 1

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.0.0-M2
• Fix Version/s: 2.0.0-M3
• Component/s: jdbc
• Assignee: Jeremy Bauer
• Reporter: Jeremy Bauer
• Due: 15/May/09
• Created: 08/May/09 15:16
• Updated: 22/Apr/10 20:32
• Resolved: 23/Mar/10 01:21

Description

The current order column reordering mechanism does not maintain a contiguous index value when an item is deleted from anywhere except the end of a collection. Per the latest JPA 2.0 spec, a contiguous index value must be maintained.

The current reordering mechanism does a full delete and reinsert of the container/collection table values if a reorder is required for inserts. For deletes, it just removes entries and leaves an empty index value. The first phase of the fix will be to maintain contiguous ordering using the same mechanism as inserts (delete/re-insert). The second phase will be to update the ChangeTracker to record the indexes of the updated list items and to use that information to provide a more intelligent update strategy in the handlers.

Issue Links

• incorporates: OPENJPA-1582 @OrderColumn(updatable=false) may have the order column field updated
• relates to: OPENJPA-1595 OrderColumn does not maintain index upon inter-list element removal - Phase 2

Sub-Tasks

• OrderColumn does not maintain index upon inter-list element removal - Phase 2: Open