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

Drop usage of deprecated columns type in MSSQL

    XMLWordPrintable

    Details

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

      Description

      There are columns which are using deprecated data type "IMAGE".

      Definition of those columns are coming from old instances (able to reproduce with migration: `4.5.7 -> 5.6.7 -> 6.7.7 -> 7.9.6` ).

      Object dbo.file_sources.binary_data uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 9, Column 5.
      Object dbo.issues.locations uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 26, Column 5.
      Object dbo.notifications.data uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 2, Column 5.
      Object dbo.project_measures.measure_data uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 8, Column 5.
      

      Column type should be changed to not use deprecated type IMAGE, VARBINARY(MAX) should be used instead.

        Attachments

          Activity

            People

            Assignee:
            jacek.poreda Jacek Poreda
            Reporter:
            jacek.poreda Jacek Poreda
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: