[SYNCOPE-1364] Upgrade tool from 2.0 script error

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.1.1
• Fix Version/s: 2.1.2, 3.0.0-M0
• Component/s: core
• Assignee: Francesco Chicchiriccò
• Reporter: Filipe Silva
• Created: 05/Sep/18 10:54
• Updated: 02/Nov/18 11:31
• Resolved: 05/Sep/18 11:29

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)