Bug 35900

Summary: Different schema on MySQL 8
Product: Koha Reporter: Tomás Cohen Arazi (tcohen) <tomascohen>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Tomás Cohen Arazi (tcohen) 2024-01-24 19:11:22 UTC
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.