https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35900 Bug ID: 35900 Summary: Different schema on MySQL 8 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: tomascohen@gmail.com QA Contact: testopia@bugs.koha-community.org I'm seeing this on the generated schema: $ git diff Koha/Schema/Result/BorrowerDebarment.pm diff --git a/Koha/Schema/Result/BorrowerDebarment.pm b/Koha/Schema/Result/BorrowerDebarment.pm index da2b1413284..63d715c4f80 100644 --- a/Koha/Schema/Result/BorrowerDebarment.pm +++ b/Koha/Schema/Result/BorrowerDebarment.pm @@ -158,12 +158,12 @@ __PACKAGE__->belongs_to( "type", "Koha::Schema::Result::RestrictionType", { code => "type" }, - { is_deferrable => 1, on_delete => "NO ACTION", on_update => "CASCADE" }, + { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" }, ); I'm not sure how important this is, but might be a clue for future compatibility issues. So worth reporting. To reproduce: 1. Start a fresh KTD with MySQL 8.0: $ DB_IMAGE=mysql:8.0 ktd up -d 2. Run: $ ktd --shell k$ dbic k$ git diff => FAIL: There's the diff I pasted above. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.