Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-22228

Fix MySQL and MSSQL migration scripts (missing NOT NULL) for Access and Artifactory

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None

      Description

      When creating a migration script which modifies a column which is NOT NULL 

      the ALTER TABLE statement must include the NOT NULL again or else the column will turn to NULLABLE (this happens both in MySQL and MSSQL)

       For example:

      in file: mysql.sql
      
      CREATE TABLE artifactory_servers (
        server_id                VARCHAR(128) NOT NULL,
      
      ... 
      
      in file mysql_v211_server_id.sql: 
      ALTER TABLE artifactory_servers MODIFY server_id VARCHAR(128);  -- causes the server_id to be NULLABLE (in mysql and mssql) 

       I Identified few scripts which didn't do that and therefore the migration and initial scripts are not aligned.

      server_id(artifactory_servers)
      tasks_context(tasks)
      version(artifact_bundles) 
      data(access_config)

       

       

        Attachments

          Issue Links

            Activity

                People

                Assignee:
                Unassigned
                Reporter:
                avishayh Avishay Halpren [X] (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated: