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

Do not rely on autogenerated id for sorting

    XMLWordPrintable

    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

          Issue Links

            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: