[DBIx-Class-Devel] [dbsrgits/sql-translator] Turned off foreign key checking in MySQL. (#135)

[Yoshiyuki Uehara]

This turns off foreign key constraint checking in MySQL not only for CREATE TABLE but also for ALTER TABLE and DROP TABLE.

This is because ALTER TABLE and DROP TABLE may also result in errors due to foreign key constraint checking.

Changed the process of changing the foreign_key_checks variable from before and after CREATE TABLE to before and after the entire diff.
You can view, comment on, or merge this pull request online at:

  https://github.com/dbsrgits/sql-translator/pull/135

-- Commit Summary --

  * Turn off foreign key checking in MySQL.

-- File Changes --

    M lib/SQL/Translator/Diff.pm (6)
    M lib/SQL/Translator/Producer/MySQL.pm (14)
    M t/30sqlt-new-diff-mysql.t (24)
    M t/38-mysql-producer.t (4)
    M t/64xml-to-mysql.t (4)

-- Patch Links --

https://github.com/dbsrgits/sql-translator/pull/135.patch
https://github.com/dbsrgits/sql-translator/pull/135.diff

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/pull/135
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20210408/8e57ca42/attachment.htm>