[CAY-2619] "to-dep PK" related dbimport delta confuses the Modeler

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.1.RC1
• Fix Version/s: 4.1.RC1, 4.2.M1
• Environment: CayenneModeler 4.1.B3-SNAPSHOT, Aug 23 build
• Assignee: Nikita Timofeev
• Reporter: Andrus Adamchik
• Created: 14/Sep/19 08:27
• Updated: 17/Sep/19 19:43
• Resolved: 17/Sep/19 19:43

Description

I am using CayenneModeler 4.1, Aug 23 build. Scenario:

• Initial state: A model with a many-to-many join table (mapped itself as an ObjEntity). Join table has formal FKs and a compound PK, made from those FKs.
• I make change in the DB, adding a separate PK column. FKs remain, but they are no longer part of the pk
• Run dbimport
• Click "Save". Modeler shows validation for relationships to the join table, saying that "to-dep PK" is checked for columns that are not pks. I can't uncheck it in the modeler, as "to-dep PK" checkboxes are disabled. But saving seems to be done correctly (to-dep PK is unset)
• Reopening the project clears validation errors.

We need to make sure that "to Dep PK" state is properly synchronized in the model and in the Modeler on such a delta during dbimport.