[OPENJPA-90] "ON DELETE SET NULL" is getting overridden if the foreign column is "NOT NULL"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Assignee: Unassigned
• Reporter: Markus Herzog
• Created: 15/Dec/06 11:06
• Updated: 09/Mar/10 18:35
• Resolved: 15/Dec/06 18:03

Description

"ON DELETE SET NULL" is getting overridden if the foreign column is "NOT NULL".
This behaviour was introduced in Revision 449532 of the DBDictionary (getForeignKeyConstraintSQL). I think this is implemented wrongly - you're checking the wrong side of the relation.