[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!"

    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.
    



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