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

use TYPES.DOUBLE instead of TYPES.DECIMAL to set null into double columns

    Details

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

      Description

      During investigation of SONAR-12251, we found out that using TYPES.DECIMAL to set a null into a double column in a prepared statement was causing a significant performance hit on SQL Server during DB migration performing massive inserts.

      The fix for that was to use TYPES.DOUBLE instead. The fix was applied only to SQL Server.

      Given that TYPES.DOUBLE is used in (to be confirmed) all mapping defined in MyBatis (ie. for all DB operations at runtime but for DB migrations), it seems safe to change the type for all SGDBs.

      This ticket is about:

      1. doing the change for all supported SGBDs
      2. verify Types.DOUBLE is used every where needed in MyBatis mappings

        Attachments

          Activity

            People

            • Assignee:
              sebastien.lesaint Sebastien Lesaint
              Reporter:
              sebastien.lesaint Sebastien Lesaint
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: