OpenJPA
  1. OpenJPA
  2. OPENJPA-1074

OrderColumn does not maintain index upon inter-list element removal - Phase 1

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-M2
    • Fix Version/s: 2.0.0-M3
    • Component/s: jdbc
    • Labels:
      None

      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

          Activity

          Donald Woods made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Donald Woods made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Donald Woods made changes -
          Link This issue relates to OPENJPA-1595 [ OPENJPA-1595 ]
          Donald Woods made changes -
          Summary OrderColumn does not maintain index upon inter-list element removal OrderColumn does not maintain index upon inter-list element removal - Phase 1
          Fix Version/s 2.0.0-M3 [ 12314148 ]
          Fix Version/s 2.1.0 [ 12314542 ]
          Kevin Sutter made changes -
          Fix Version/s 2.1.0 [ 12314542 ]
          Fix Version/s 2.0.0 [ 12314019 ]
          Jeremy Bauer made changes -
          Link This issue incorporates OPENJPA-1582 [ OPENJPA-1582 ]
          Donald Woods made changes -
          Field Original Value New Value
          Fix Version/s 2.0.0 [ 12314019 ]
          Priority Major [ 3 ] Critical [ 2 ]
          Due Date 2009-05-15 07:00:00.0 2009-05-15 00:00:00.0
          Jeremy Bauer created issue -

            People

            • Assignee:
              Jeremy Bauer
              Reporter:
              Jeremy Bauer
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Development