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

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

    XMLWordPrintable

    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: