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

Support Upsert Operations for DB Vendors

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Community
    • Production Notes:
      None

      Description

      Currently, SQ is only supporting upsert operations for the latest PostgreSQL versions.

      We should investigate if it would be possible to leverage that operation with other DB Vendors we support.

      If it's possible, SonarQube source code would need to be updated to drop specific sql syntax prior to PostgreSQL 9.5 (when upsert was introduced), and to implement this operation for the other vendors.

       

      See PersistDuplicationDataStep:130,  PersistLiveMeasuresStep:126  and AbstractDialect:82

       

       

       

       

        Attachments

          Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. SONAR-12885 PostgreSQL 9.3, 9.4, 9.5 end of support / PostgreSQL 13 support

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              belen.pruvost Belén Pruvost
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: