Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10910

MSSQL upgrade scripts have incorrect SQL syntax when adding columns

    Details

      Description

      Within the /db/mssql/scripts/updates/v9_add_provider_method_context_fields.sql script, there are several column additions made to various tables with incorrect syntax:

      ALTER TABLE [openidm].[auditactivity] ADD COLUMN context NVARCHAR(25) NULL;
      

      The syntax for this should be as follows:

      ALTER TABLE [openidm].[auditactivity] ADD context NVARCHAR(25) NULL;
      

        Attachments

          Activity

            People

            • Assignee:
              matthias.grabiak Matthias Grabiak
              Reporter:
              tom.wood Tom Wood
              QA Assignee:
              Michal Orlik
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: