DDC-396: SchemaDiff not working well when using ON UPDATE RESTRICT #490

New Issue

admin · 2026-01-22T12:40:19+01:00

admin commented

2026-01-22 12:40:19 +01:00

Originally created by @doctrinebot on GitHub (Mar 9, 2010).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @guilhermeblanco:

SchemaDiff is considering the constraint to be always applied when calling the orm:schema-tool --update, even though it was already applied.

Example of output I get on orm:schema-tool --update --dump-sql:

ALTER TABLE user*ratings DROP FOREIGN KEY user_ratings_ibfk*2;
ALTER TABLE user*ratings DROP FOREIGN KEY user_ratings_ibfk*1;
ALTER TABLE user*ratings ADD FOREIGN KEY (to_user*id) REFERENCES users(id) ON UPDATE RESTRICT ON DELETE CASCADE;
ALTER TABLE user*ratings ADD FOREIGN KEY (user*id) REFERENCES users(id) ON UPDATE RESTRICT ON DELETE CASCADE;

Originally created by @doctrinebot on GitHub (Mar 9, 2010). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @guilhermeblanco: SchemaDiff is considering the constraint to be always applied when calling the orm:schema-tool --update, even though it was already applied. Example of output I get on orm:schema-tool --update --dump-sql: ``` ALTER TABLE user*ratings DROP FOREIGN KEY user_ratings_ibfk*2; ALTER TABLE user*ratings DROP FOREIGN KEY user_ratings_ibfk*1; ALTER TABLE user*ratings ADD FOREIGN KEY (to_user*id) REFERENCES users(id) ON UPDATE RESTRICT ON DELETE CASCADE; ALTER TABLE user*ratings ADD FOREIGN KEY (user*id) REFERENCES users(id) ON UPDATE RESTRICT ON DELETE CASCADE; ```

admin added the Bug label 2026-01-22 12:40:19 +01:00

admin closed this issue

2026-01-22 12:40:20 +01:00

admin commented

2026-01-22 12:40:20 +01:00

@doctrinebot commented on GitHub (Mar 10, 2010):

Comment created by @beberlei:

Are you on Mysql 5.0?

@doctrinebot commented on GitHub (Mar 10, 2010): Comment created by @beberlei: Are you on Mysql 5.0?

admin commented

2026-01-22 12:40:21 +01:00

@doctrinebot commented on GitHub (Mar 10, 2010):

Comment created by @guilhermeblanco:

mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (i486) using EditLine wrapper

@doctrinebot commented on GitHub (Mar 10, 2010): Comment created by @guilhermeblanco: mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (i486) using EditLine wrapper

admin commented

2026-01-22 12:40:22 +01:00

@doctrinebot commented on GitHub (Mar 11, 2010):

Comment created by @beberlei:

Fixed in 2ebd2c901e.

@doctrinebot commented on GitHub (Mar 11, 2010): Comment created by @beberlei: Fixed in https://github.com/doctrine/dbal/commit/2ebd2c901ec00e91b50b452467cc7097f66b8e8c.

admin commented

2026-01-22 12:40:23 +01:00

@doctrinebot commented on GitHub (Mar 11, 2010):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Mar 11, 2010): Issue was closed with resolution "Fixed"

admin referenced this issue

2026-01-22 15:59:10 +01:00

[PR #490] [MERGED] fix StatementMock bindParam parameters #8276

admin referenced this issue

2026-01-22 15:59:11 +01:00

[PR #490] fix StatementMock bindParam parameters #8280

Sign in to join this conversation.