Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-58

Schema tool does not see difference between onDelete="NO ACTION" and onDelete="RESTRICT"

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Schema Managers
    • Labels:
      None

      Description

      If database has ON DELETE CASCADE, schema tool detects change to NO ACTION and RESCRICT.
      If database has ON DELETE RESCRICT, schema tool detects change only in case of CASCADE.
      If database has ON DELETE NO ACTION, schema tool detect change only in case of CASCADE.

      Detecting of changes is done by:
      doctrine orm:schema-tool update --dump-sql
      and
      doctrine orm:validate-schema

        Activity

        obrys Jan Obrátil created issue -
        romanb Roman S. Borschel made changes -
        Field Original Value New Value
        Assignee Roman S. Borschel [ romanb ] Benjamin Eberlei [ beberlei ]
        obrys Jan Obrátil made changes -
        Attachment Example.php [ 10736 ]
        beberlei Benjamin Eberlei made changes -
        Project Doctrine 2 - ORM [ 10032 ] Doctrine DBAL [ 10040 ]
        Key DDC-743 DBAL-58
        Issue Type Bug [ 1 ] Improvement [ 4 ]
        Affects Version/s 2.0-BETA2 [ 10050 ]
        Component/s Schema Managers [ 10057 ]
        Component/s ORM [ 10012 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira [ 11754 ] jira-feedback2 [ 17562 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17562 ] jira-feedback3 [ 19916 ]
        deeky666 Steve Müller made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]

          People

          • Assignee:
            beberlei Benjamin Eberlei
            Reporter:
            obrys Jan Obrátil
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: