Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-1364

Upgrade tool from 2.0 script error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.1.1
    • 2.1.2, 3.0.0
    • core
    • None

    Description

      The upgrade.sql file generated with the upgrade tool has a script error: wrong column name

      INSERT INTO RealmAction(task_id,implementation_id) VALUES( ...
      

      and should be

      INSERT INTO RealmAction(realm_id,implementation_id) VALUES( ...
      

      I think the problem is in core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java (line 381)

      OUT.write("_INSERT_ _INTO_ _RealmAction_(task_id,implementation_id) VALUES("
      

      should be corrected to

      OUT.write("_INSERT_ _INTO_ _RealmAction_(realm_id,implementation_id) VALUES("
      

      (test with postgres DB)

      Attachments

        Activity

          People

            ilgrosso Francesco Chicchiriccò
            filipe.silva Filipe Silva
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: