Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-12214

Do not rely on autogenerated id for sorting

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 7.8
    • Fix Version/s: 8.0
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Community
    • Production Notes:
      None

      Description

      On some SGDBs (at least Oracle Real Application Cluster), autogenerated ids are guaranted to be unique but not sequential. Therefor, sorting on such column can lead to wrong sorting.

      At least one use case has been reported on the background task page.

      There may be others. They should be looked up, reported in this ticket and fixed.

        Attachments

          Activity

            People

            • Assignee:
              jacek.poreda Jacek Poreda
              Reporter:
              sebastien.lesaint Sebastien Lesaint
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: