[Koha-bugs] [Bug 23995] Check constraints are supported differently by MySQL and MariaDB so we should remove them for now.

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23995

--- Comment #2 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Mysql8 Manual:

`Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on
columns used in CHECK constraints. Likewise, CHECK constraints are prohibited
on columns used in foreign key referential actions.`

This is why the accountline check constraint must be dropped to support mysql8
(no such requirement in mariadb I believe)

-- 
You are receiving this mail because:
You are watching all bug changes.