Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-2922

ordering of multiple task queries fails on H2

    • Icon: Bug Report Bug Report
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • engine
    • None

      Currently the ordering of tasks with the same attribute value (e.g. priority = 50) is not deterministic. This leads to the behavior that every time
      the tasklist is updated the ordering changes.

      We should figure out if it is possible to influence the H2 sorting for ORDER BY so it generates a deterministic ordering. Otherwise it should
      be documented at least for the tasklist.

      For a failing test case see:
      https://github.com/camunda/camunda-bpm-platform/commit/ae13183f7dfdb7e3ec04eb6d2222f2a746ca96ac

        This is the controller panel for Smart Panels app

            [CAM-2922] ordering of multiple task queries fails on H2

            Michael Schoettes created issue -
            Michael Schoettes made changes -
            Link New: This issue is related to CAM-2589 [ CAM-2589 ]
            Sebastian Menski made changes -
            Description New: Currently the ordering of tasks with the same attribute value (e.g. priority = 50) is not deterministic. This leads to the behavior that every time
            the tasklist is updated the ordering changes.

            We should figure out if it is possible to influence the H2 sorting for ORDER BY so it generates a deterministic ordering. Otherwise it should
            be documented at least for the tasklist.

            For a failing test case see:
            Sebastian Menski made changes -
            Description Original: Currently the ordering of tasks with the same attribute value (e.g. priority = 50) is not deterministic. This leads to the behavior that every time
            the tasklist is updated the ordering changes.

            We should figure out if it is possible to influence the H2 sorting for ORDER BY so it generates a deterministic ordering. Otherwise it should
            be documented at least for the tasklist.

            For a failing test case see:
            New: Currently the ordering of tasks with the same attribute value (e.g. priority = 50) is not deterministic. This leads to the behavior that every time
            the tasklist is updated the ordering changes.

            We should figure out if it is possible to influence the H2 sorting for ORDER BY so it generates a deterministic ordering. Otherwise it should
            be documented at least for the tasklist.

            For a failing test case see:
            https://github.com/camunda/camunda-bpm-platform/commit/ae13183f7dfdb7e3ec04eb6d2222f2a746ca96ac
            Robert Gimbel made changes -
            Fix Version/s Original: 7.3.0 [ 13391 ]
            Thorben Lindhauer made changes -
            Workflow Original: camunda BPM [ 27947 ] New: Backup_camunda BPM [ 55311 ]
            Thorben Lindhauer made changes -
            Resolution New: Won't Fix [ 2 ]
            Status Original: Open [ 1 ] New: Closed [ 6 ]

              Unassigned Unassigned
              michael.schoettes Michael Schoettes
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: