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

Do not restrict measure max numeric value to ~2 billions

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database, Measures
    • Labels:
      None
    • Edition:
      Community

      Description

      Value type of numeric measures is implemented as Java integer so that max value is 2^31-1.
      Long type should be used (max is 2^63-1).

      The type of DB column PROJECT_MEASURES.VALUE should also be verified as decimal type is used. It does not accept Long.MAX value on all of our supported databases.

      It is possible to respect this Long max value with this datatype => decimal or numeric (38,19) (2^63 before the comma and same range after it).

      The direct change is possible in MYSQL (quite long) , MSSQL , POSTGRESQL.
      The procedure to change the scale of a number columns in Oracle is much more complex (temporary column , move ...)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                simon.brandhof Simon Brandhof
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: