[jira] Created: (CAY-1099) DbMerger logic fails to fix invalid complex FKs

From: Scott Anderson (JIRA) ("Scott)
Date: Tue Aug 26 2008 - 18:29:11 EDT

Next message: Apache Hudson Server: "Cayenne-trunk - Build # 202 - Failure!"

Previous message: Andrey Razumovsky (JIRA): "[jira] Updated: (CAY-892) CM Usability: JEdit Syntax to all TextAreas"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

DbMerger logic fails to fix invalid complex FKs
-----------------------------------------------

                 Key: CAY-1099
                 URL: https://issues.apache.org/cayenne/browse/CAY-1099
             Project: Cayenne
          Issue Type: Bug
          Components: Cayenne Core Library
    Affects Versions: 3.0
         Environment: 3.0 M4, Derby
            Reporter: Scott Anderson
            Assignee: Andrus Adamchik

The merger tries to do the following:
ALTER TABLE mail ADD FOREIGN KEY (sentto) REFERENCES account (id)

Which fails with the error:
Foreign Key 'SQL080826163049030' is invalid because 'The table cannot be defined as a dependent of table APP.ACCOUNT because of delete rule restrictions. (The relationship causes the table to be delete-connected to the indicated table through multiple relationships and the delete rule of the existing relationship is SET NULL.). '.

mail has a 'sentto' and 'sentfrom' field, in the style of REFERENCES account (id) ON DELETE SET NULL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Next message: Apache Hudson Server: "Cayenne-trunk - Build # 202 - Failure!"
Previous message: Andrey Razumovsky (JIRA): "[jira] Updated: (CAY-892) CM Usability: JEdit Syntax to all TextAreas"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Aug 26 2008 - 18:29:39 EDT