| Summary: | Different schema on MySQL 8 | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Tomás Cohen Arazi (tcohen) <tomascohen> |
| Component: | Database | Assignee: | Bugs List <koha-bugs> |
| Status: | NEW --- | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P5 - low | ||
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
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.